本文介绍了SSRS报告管理器 - 参数配置500错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

您好,


我正在尝试在报表服务器上修改特定报表的默认参数。 但是当我访问配置页面(上下文菜单 - > Manage - > Parameters)时,我在AJAX调用上收到500错误以加载页面内容。在检查
SSRS日志后,我看到以下内容:


RSPortal!reportserverwebapp!RSPortal.exe!6b!04/16 / 2019-14:15:55: :e错误:发生了OData异常:System.Reflection.TargetInvocationException:调用目标已抛出异常。 ---> Microsoft.SqlServer.ReportingServices2010.RSConnection2010 + MissingEndpointException:
尝试连接到报表服务器失败。 检查连接信息,并且报表服务器是兼容版本。 ---> System.InvalidOperationException:XML文档中存在错误(7,4825)。 ---> System.Xml.XmlException:
'。',十六进制值0x00,是无效字符。第7行,第4825位。


  在System.Xml.XmlTextReaderImpl.Throw(例外e)


  在System.Xml.XmlTextReaderImpl.ParseNumericCharRefInline(Int32 startPos,Boolean expand,StringBuilder internalSubsetBuilder,Int32& charCount,EntityType& entityType)


  在System.Xml.XmlTextReaderImpl.ParseCharRefInline(Int32 startPos,Int32& charCount,EntityType& entityType)


  在System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos,Int32& endPos,Int32& outOrChars)


  在System.Xml.XmlTextReaderImpl.ParseText()


  在System.Xml.XmlTextReaderImpl.ParseElementContent()


  在System.Xml.XmlReader.ReadElementString()


  在Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderSoapRsManagementConnection.Read42_ValidValue(Boolean isNullable,Boolean checkType)


  在Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderSoapRsManagementConnection.Read43_ItemParameter(Boolean isNullable,Boolean checkType)


  在Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderSoapRsManagementConnection.Read113_GetItemParametersResponse()


  在System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader,String encodingStyle,XmlDeserializationEvents事件)


   ---内部异常堆栈跟踪结束---


  在System.Xml.Serialization.XmlSerializer.Deserialize(XmlReader xmlReader,String encodingStyle,XmlDeserializationEvents事件)


  在System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage消息,WebResponse响应,Stream responseStream,布尔asyncCall)


  在System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName,Object [] parameters)


  在Microsoft.SqlServer.ReportingServices2010.ReportingService2010.GetItemParameters(String ItemPath,String HistoryID,Boolean ForRendering,ParameterValue [] Values,DataSourceCredentials [] Credentials)


  在Microsoft.SqlServer.ReportingServices2010.RSConnection2010。<> c__DisplayClassbf。< GetItemParameters> b__be()


  在Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)


   ---内部异常堆栈跟踪结束---


  在Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol)


  在Microsoft.SqlServer.ReportingServices2010.RSConnection2010.GetItemParameters(String itemPath,String historyId,Boolean forRendering,ParameterValue [] values,DataSourceCredentials [] credentials)


  在Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapRS2010Proxy。<> c__DisplayClassa。< GetItemParameters> b__9()


  在Microsoft.ReportingServices.Portal.Services.SoapProxy.SoapAuthenticationHelper.ExecuteWithWindowsAuth [TReturn](SoapHttpClientProtocol soapClient,IPrincipal userPrincipal,Func`1 func)


  在Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetReportParameterDefinitionsWithQueryAndCurrentValues(IPrincipal userPrincipal,String reportpath,IEnumerable`1 parameterValues)


  在Microsoft.ReportingServices.Portal.Repositories.CatalogItemRepository.GetReportParameterDefinitionsWithQuery(IPrincipal userPrincipal,String reportpath)


  在Model.Report.get_ParameterDefinitions()


  在lambda_method(Closure,ReportRepository)


   ---内部异常堆栈跟踪结束---


   at System.RuntimeMethodHandle.InvokeMethod(Object target,Object [] arguments,Signature sig,Boolean constructor)


   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj,Object [] parameters,Object [] arguments)


  在System.Delegate.DynamicInvokeImpl(Object [] args)


  在System.Web.OData.Query.Expressions.SelectExpandBinder.Bind(对象实体)


  在System.Web.OData.Query.SelectExpandQueryOption.ApplyTo(对象实体,ODataQuerySettings设置,IAssembliesResolver assembliesResolver)


  在System.Web.OData.Query.ODataQueryOptions.ApplySelectExpand [T](T实体,ODataQuerySettings querySettings)


  在System.Web.OData.Query.ODataQueryOptions.ApplyTo(对象实体,ODataQuerySettings querySettings)


  在System.Web.OData.EnableQueryAttribute.ExecuteQuery(对象响应,HttpRequestMessage请求,HttpActionDescriptor actionDescriptor)


  在System.Web.OData.EnableQueryAttribute.OnActionExecuted(HttpActionExecutedContext actionExecutedContext)


  在System.Web.Http.Filters.ActionFilterAttribute.OnActionExecutedAsync(HttpActionExecutedContext actionExecutedContext,CancellationToken cancellationToken)


---抛出异常的上一个位置的堆栈跟踪结束---


  在System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()


  在System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务任务)


  在System.Web.Http.Filters.ActionFilterAttribute。< CallOnActionExecutedAsync> d__5.MoveNext()


---抛出异常的上一个位置的堆栈跟踪结束---


  在System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()


  在System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务任务)


  在System.Web.Http.Filters.ActionFilterAttribute。< ExecuteActionFilterAsyncCore> d__0.MoveNext()


---抛出异常的上一个位置的堆栈跟踪结束---


  在System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()


  在System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务任务)


  在System.Web.Http.Controllers.ActionFilterResult。< ExecuteAsync> d__2.MoveNext()


---抛出异常的上一个位置的堆栈跟踪结束---


  在System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()


  在System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务任务)


  在System.Web.Http.Controllers.ExceptionFilterResult。< ExecuteAsync> d__0.MoveNext()。 | RequestID = s_0a92cf66-b039-4cf1-869e-cd346bebc4ee



此服务器上的其他报告似乎没有此问题,此报告可以在报表服务器上查看,因此我只能假设报表定义XML有效(我只是无法配置其参数)。 这是一个已知问题吗?


任何有关变通方法的建议都会受到赞赏。


谢谢


解决方案


这篇关于SSRS报告管理器 - 参数配置500错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-05 22:14