We investigated the situation where the physical inventory reports were running slower and slower. Months ago the reports only took a couple of minutes to run, now it was over an hour. Users tended to kill the sessions which caused the report to run even slower.
The report uses two tables in AX to build up the report data:
- InventSumDateTable
- InventSumDateTrans
When the report is started, the data in the tables is filled and after completing the generation of the report, the tables are emptied. However, when someone kills the sessions which is generating the report, the data in the tables isn't deleted and causes the report to generate slower on the next run.
When you have performance issues, check if these tables contains records and if so, delete them. After we cleaned up the data, the report ran within minutes again.
No comments:
Post a Comment