Applies to Product - Dynamics 365 Supply Chain Management
What’s happening?
The Standard Cost transaction page (Costing Version) does not open, resulting in an error message indicating a timeout occurred in the database while the query was executing.
Reason:
This is caused by a specific SQL query timing out during the process. The query has regressed multiple times, leading to poor execution plans.
Resolution:
- The SQL query causing the timeout should be analyzed and tuned to improve performance.
- A statistics update on the relevant tables may help in optimizing the query execution.
- Consider implementing a long-term solution to prevent the query from regressing again, such as forcing the query plan to ensure it picks up the optimal execution path.