Hi All,
I am getting below error while executing the SSRS report in the AX 2012 R3 environment.
AX 2012 R3 Environment details
- Kernel Version: 6.3.6000.8149
- Application Version: 6.3.6000.151
Error:
"An internal error occurred on the report server. See the error log for more details. (rsInternalError) An internal error occurred on the report server. See the error log for more details. (rsInternalError) Microsoft.Reporting.WinForms.ReportServerException at Microsoft.Reporting.WinForms.SoapReportExecutionService.ServerUrlRequest(AbortState abortState, String url, Stream outputStream, String& mimeType, String& fileNameExtension) at Microsoft.Reporting.WinForms.SoapReportExecutionService.Render(AbortState abortState, String reportPath, String executionId, String historyId, String format, XmlNodeList deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) at Microsoft.Reporting.WinForms.AsyncMainStreamRenderingOperation.RenderServerReport(ServerReport report) at Microsoft.Reporting.WinForms.AsyncRenderingOperation.PerformOperation() at Microsoft.Reporting.WinForms.ReportViewer.AsyncReportOperationWrapper.PerformOperation() at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)"
Below are the solutions I have tried till now, but no luck. Any help will be great. TIA.
1) Restarted Microsoft Dynamics AX service and SQL Server Reporting Services.
2) Verified Reporting Services Configuration Manager.
3) Cleared usage data and cache
4) Redeployed report
5) Removed and again installed reporting service extension.
6) Opened Microsoft Dynamics AX 2012 Configuration from Administrator Tools and clicked on Configure services and refresh configuration.
7) Verified log files but much information is not available.
Log details
"library!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
library!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
library!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
library!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
library!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS11.MSSQLSERVER\Reporting Services\Logfiles
resourceutilities!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: Reporting Services starting SKU: EnterpriseCore
ui!ReportServer_0-2!f20!09/22/2020-23:21:07:: i INFO: Software Usage Metrics not enabled for EnterpriseCore edition
library!ReportServer_0-2!f20!09/22/2020-23:21:10:: i INFO: Catalog SQL Server Edition = Enterprise
crypto!ReportServer_0-2!f20!09/22/2020-23:21:10:: i INFO: Initializing crypto as user: (Removed user for security reasons)
crypto!ReportServer_0-2!f20!09/22/2020-23:21:10:: i INFO: Exporting public key
crypto!ReportServer_0-2!f20!09/22/2020-23:21:10:: i INFO: Performing sku validation
crypto!ReportServer_0-2!f20!09/22/2020-23:21:10:: i INFO: Importing existing encryption key
library!ReportServer_0-2!f20!09/22/2020-23:21:16:: i INFO: RenderForNewSession('/DynamicsAX/CustomSalesTax.ReportDesign')
library!ReportServer_0-2!f20!09/22/2020-23:21:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: segmentedChunkStore, Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.;
library!ReportServer_0-2!f20!09/22/2020-23:21:24:: i INFO: Dump result: External dump process return code 0x20000001.
External dump process returned no errors.
.
library!ReportServer_0-2!f20!09/22/2020-23:21:24:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
webserver!ReportServer_0-2!f20!09/22/2020-23:21:24:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
"