Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The INVENTREPORTDIMHISTORY table has expanded significantly, reaching sizes of 40 GB or more shortly after the system went live, raising concerns about potential bugs or the absence of a standard clean-up job.
Reason:
The rapid growth of the INVENTREPORTDIMHISTORY table is likely due to the accumulation of dimension history data for documents, which has not been cleaned up since the system went live. This could indicate an issue with how data is being logged or retained.
Resolution:
- Run the "Dimension history for documents report data clean up" job via the Inventory management module to optimize database capacity and performance.
- Implement a custom clean-up job to manage the size of the INVENTREPORTDIMHISTORY table more effectively in the future.
- It is recommended to test any clean-up routines in a non-production environment first to ensure they do not inadvertently delete necessary data.