We use AX 2012 R3. I have an existing SSRS report that takes too long to open. So, converted to a pre-processing report. The only changes I have made is changing the DP class extension from SRSReportDataProviderBase to SRSReportDataProviderPreProcessTempDB and the Temp table tableType property to TempDB.
These changes worked for all the other reports. However, it is throwing me the following error when I run the report.
Tried the following steps, but no luck:
Synchronized the Temp table
Restore the report and deploy
Clean the cache and restart the AOS
Below is the Event viewer screenshot and it doesn’t provide any clue unless I am missing something
Any inputs are appreciated!
Thanks!