When something isn't refreshing correctly between AX, VS, and the Report server, follow these steps to get things back in sync.
In this order:
- On the Report Server, delete the report
- In AX, delete data for report from the SRSReportQuery table (Addins, Table browser) - often skip
- In AX, compile forward the DataProvider (DP) class (Addins, Compile forward)
- In VS, refresh the datasets
- In VS, save the report to the AOT (use the Add xyzModel to AOT menu, not just save)
- In AX, restore the SSRS report object and check it's modified date/time stamp (have to click off/on object)
- In AX, clear the caches in the AOT (Tools, Caches)
- Restart SSRS service (Administrative Tools, Services: SQL Server Reporting Services)
- Close AX client and Restart AOT service (Microsoft Dynamics AX Object Server)
- Open AX client and Deploy the report
- Delete AUC and KTI files for user running the report (Users\userName\AppData\Local) - ofthen
Great list, thanks Thank you so much for sharing.
ReplyDeleteMS Dynamics Online Training