Server Error- SSRS Reports

Owned by Knowledge Assistant
Last updated: Jan 23, 2023
2 min read



Description of Issue

The following error populates when browsing to Balance Sheet Summary 

Error listed on Munis App server:

Server Error in '/xxxx<env>/munis/munisnet' Application

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Context

  • Munis

  • SSRS

  • SQL

  • Data Source

  • Balance Sheet Summary



Cause

Incorrect configuration for SSRS log into the data source within Munis ERP SSRS variables in Tyler Deploy and or incorrect SSRS Report Server URL



Resolution

Please contact TSM Support for assistance. 



Additional Information

Full error as listed on Munis App server:


Server Error in '/xxxx<env>/munis/munisnet' Application.

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Microsoft.Reporting.WebForms.ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ReportServerException: For more information about this error navigate to the report server on the local server machine, or enable remote errors]


[ReportServerException: Log on failed. Ensure the user name and password are correct. (rsLogonFailed)]


[ReportServerException: Cannot impersonate user for data source ' Data source for shared dataset'. (rsErrorImpersonatingUser)]


[ReportServerException: The execution failed for the shared data set 'AppNames'. (rsDataSetExecutionError)]


[ReportServerException: An error has occurred during report processing. (rsProcessingAborted)]

   Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e) +108

   Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.ProxyMethodInvocation.Execute(RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod) +704

   Microsoft.Reporting.WebForms.SoapReportExecutionService.LoadReport(String report, String historyId) +33

   Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession() +110

   Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1 parameters) +81

   Tyler.Munis.Hosting.WebClients.Report.OnInit(EventArgs e) in C:\azp\agent\_work\14\s\Source\MunisHosting\Tyler.Munis.Hosting.WebClients\Report.aspx.cs:213

   System.Web.UI.Control.InitRecursive(Control namingContainer) +173

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +491