Wednesday, November 4, 2015

AX 2012 SSRS Report Out of Sync

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:
  1. On the Report Server, delete the report
  2. In AX, delete data for report from the SRSReportQuery table (Addins, Table browser) - often skip
  3. In AX, compile forward the DataProvider (DP) class  (Addins, Compile forward)
  4. In VS, refresh the datasets
  5. In VS, save the report to the AOT (use the Add xyzModel to AOT menu, not just save)
  6. In AX, restore the SSRS report object and check it's modified date/time stamp (have to click off/on object)
  7. In AX, clear the caches in the AOT (Tools, Caches)
  8. Restart SSRS service (Administrative Tools, Services: SQL Server Reporting Services)
  9. Close AX client and Restart AOT service (Microsoft Dynamics AX Object Server)
  10. Open AX client and Deploy the report 
  11. Delete AUC and KTI files for user running the report (Users\userName\AppData\Local) - ofthen 

1 comment: