Share
Report
35Hi
I'm having some trouble using a new SSRS report I've created in Dynamics AX. The report consists of 2 datasets. Both datasets are retrieved from a single data provider. I’m assuming these datasets/sources are setup correctly in the data provider because I can add them as datasets on the report.
-
· SrsReportDataSetAttribute is used with tableStr(…) to the source tmp table
-
· SrsReportDataProviderPreProcess is the parent class for my dataprovider
-
· Both tmp tables have a ‘CreatedTransactionId’
Error
When running the report, I get the following error:
An error occurred during report data sets execution.
Detail (from event viewer):
System.ArgumentException: No report data table with name [REPLACED] exists in report schema for data provider [REPLACED]DP. at Microsoft.Dynamics.AX.Framework.Reporting.Shared.AxReportProviderServiceExecuter.GetDataTable(AxReportProviderQueryElements reportProviderQueryElements) at Microsoft.Dynamics.AX.Framework.Reporting.Shared.AxReportProviderServiceExecuterExtensions.GetDataTableReader(AxReportProviderServiceExecuter executer, AxReportProviderQueryElements reportProviderQueryElements) at Microsoft.Dynamics.Framework.Reports.AxReportProviderCommand.OnExecuteReader(CommandBehavior behavior) at Microsoft.Dynamics.Framework.Reports.DbCommand.ExecuteReader(CommandBehavior behavior)
Potential fixes
I’ve already tried the following potential fixes, but none of them actualy fixed the problem:
-
· Clear user cache
-
· Restarting SSRS service
-
· Deleting and re-deploying report on SSRS
-
· Restarting VS and iisexpress
-
· Renaming the report
-
· Renaming the tmp tables (shorter names)
-
· Renaming the datasets
- Full model build and database sync (EDIT: 23/01/2020)
Version info
· 2019 release wave 2
· Installed product version : Finance and Operations (10.0.6)
· Installed platform version : Update30 (7.0.5407.35455)
Does anyone have any suggestions on how to fix the problem?
Thanks in advance!
All responses (
Answers (
