如何解决sharepoint错误-500 Internal Server Error? [英] How to resolve sharepoint error- 500 Internal Server Error?

问题描述

我要在sharepoint上进行查询，以下是查询和连接详细信息.

Hi I'm querying on sharepoint, below is the query and connection details.

   <sharepoint:online-connection-config name="Microsoft_SharePoint_2013__Online_Connection" username="${Sharepoint.Username}" password="${Sharepoint.Password}" siteUrl="${Sharepoint.SiteUrl}" disableCnCheck="true" doc:name="Microsoft SharePoint 2013: Online Connection">
        <reconnect frequency="10000" count="5"/>
    </sharepoint:online-connection-config>

    <sharepoint:file-query config-ref="Microsoft_SharePoint_2013__Online_Connection" query="dsql:SELECT Author,CheckInComment,CheckOutType,CheckedOutByUser,ContentTag,CustomizedPageStatus,ETag,Exists,Length,Level,LinkingUrl,ListItemAllFields,LockedByUser,MajorVersion,MinorVersion,ModifiedBy,Name,ServerRelativeUrl,TimeCreated,TimeLastModified,Title,UIVersion,UIVersionLabel,UniqueId,Versions FROM 'Sell sheetsBrochures' ORDER BY TimeLastModified DESC LIMIT ${sharepoint.file.fetch.number}" doc:name="Modified File query "/>

查询共享点时，它抛出以下错误.

It is throwing below error while querying the sharepoint.

    ********************************************************************************
    Message               : Failed to invoke fileQuery. Message payload is of type: String
    Type                  : org.mule.api.MessagingException
    Code                  : MULE_ERROR-29999
    JavaDoc               : http://www.mulesoft.org/docs/site/current3/apidocs/org/mule/api/MessagingException.html
    Payload               : 
    ********************************************************************************
    Exception stack is:
    1. 500 Internal Server Error (org.springframework.web.4.1.6.RELEASE.shaded.client.HttpServerErrorException)
      org.springframework.web.4.1.6.RELEASE.shaded.client.DefaultResponseErrorHandler:94 (null)
    2. Code: 500 Message: {"error":{"code":"-2146232832, Microsoft.SharePoint.SPException","message":{"lang":"en-US","value":"User cannot be found."}}} (org.mule.module.sharepoint.exception.SharepointException)
      org.mule.module.sharepoint.rest.AbstractSharepointClientImpl:148 (http://www.mulesoft.org/docs/site/current3/apidocs/org/mule/module/sharepoint/exception/SharepointException.html)
    3. Failed to invoke fileQuery. Message payload is of type: String (org.mule.api.MessagingException)
      org.mule.devkit.processor.DevkitBasedMessageProcessor:133 (http://www.mulesoft.org/docs/site/current3/apidocs/org/mule/api/MessagingException.html)

********************************************************************************
Root Exception stack trace:
org.springframework.web.4.1.6.RELEASE.shaded.client.HttpServerErrorException: 500 Internal Server Error
    at org.springframework.web.4.1.6.RELEASE.shaded.client.DefaultResponseErrorHandler.handleError(DefaultResponseErrorHandler.java:94)
    at org.springframework.web.4.1.6.RELEASE.shaded.client.RestTemplate.handleResponse(RestTemplate.java:614)
    at org.springframework.web.4.1.6.RELEASE.shaded.client.RestTemplate.doExecute(RestTemplate.java:570)
    at org.springframework.web.4.1.6.RELEASE.shaded.client.RestTemplate.execute(RestTemplate.java:545)
    at org.springframework.web.4.1.6.RELEASE.shaded.client.RestTemplate.exchange(RestTemplate.java:466)
    at org.mule.module.sharepoint.rest.AbstractSharepointClientImpl.exchangeForObject(AbstractSharepointClientImpl.java:144)

推荐答案

您有一个500 Internal Server Error，这意味着您正在查询的服务器出了点问题.错误消息为User cannot be found.，您在Microsoft_SharePoint_2013__Online_Connection配置上配置的用户可能不再存在于SharePoint服务器上，或者存在一些配置问题.

You have a 500 Internal Server Error, meaning something went wrong on the server you are querying. The error message is User cannot be found., the user you configured on your Microsoft_SharePoint_2013__Online_Connection configuration probably doesn't exists anymore on your SharePoint server, or have some configuration issue.

使用您提供的详细信息，您配置的用户似乎在服务器端引起了一些错误.如果您有权访问服务器，则应检查日志并确保已正确配置此用户并可以访问该用户.

with the details you gave, it seems the user you have configured is causing some bug on the server side. If you have access to the server you should check the logs and ensure this user is properly configured and accessible.

这篇关于如何解决sharepoint错误-500 Internal Server Error?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！