/
Server Error- SSRS Reports

Server Error- SSRS Reports



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











Related content

Error Running Canned SSRS Reports from Munis - This report requires a default or user-defined value for the report parameter 'ReportYear'
Error Running Canned SSRS Reports from Munis - This report requires a default or user-defined value for the report parameter 'ReportYear'
More like this
Canned reports MunisNet server Runtime Error
Canned reports MunisNet server Runtime Error
More like this
Tyler Deploy Step to Verify SSRS Failed on MunisERP Project
Tyler Deploy Step to Verify SSRS Failed on MunisERP Project
More like this
Custom SSRS report shows ErrorImpersonatingUser error
Custom SSRS report shows ErrorImpersonatingUser error
More like this
Configure SSRS Data Source Connections
Configure SSRS Data Source Connections
More like this
Step 11 - Verify SSRS Fails Due to Invalid SSRS Connection
Step 11 - Verify SSRS Fails Due to Invalid SSRS Connection
More like this