Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The job that is used to determine the ABC classification of released products never completes and often results in errors.
Reason:
The process is very heavy due to a significant number of SQL updates that take up most of the compute time. Customizations to the process add to the execution time. Additionally, there may be missing schema in SQL that affects the job's ability to finish.
Resolution:
- Build a shadow copy of the environment to analyze the execution logic and time spent.
- Run the job without any customizations to compare performance.
- Review the parameters used to run the job to ensure they are appropriate (e.g., whether it is run wide open or for a filtered set of items).
- Investigate telemetry from recent runs to identify potential issues with interactions and customizations.
- If the job continues to fail, consider database synchronization as a potential resolution step.