Views:

Applies to Product - Dynamics 365 Supply Chain Management

What’s happening?


Users experience issues with Sales Orders when pricing is updated, resulting in a temporary problem with the connection to the database. Additionally, users encounter SQL database errors when attempting to release production orders.

Reason:

  1. This Sales Orders is linked to a temporary database connection problem, which leads to multiple orders being created.
  2. The SQL database error when releasing a production order is due to a missing stored procedure, which is not created because a related flight has been disabled globally in the production environment.

Resolution:


For the Sales Order issue:

  1. Ensure that the database connection is stable and check for any ongoing maintenance or issues with the database server.
  2. If the problem persists, gather detailed error messages and screenshots to assist in further troubleshooting.
 
For the SQL database error when releasing a production order:
  1. Have a system administrator execute the Tutorial_WHSSetup runnable class in the UAT environment to ensure that the stored procedure is created.
  2. Confirm that the production environment is synchronized with the UAT environment to reflect the new flight settings.
  3. If the issue continues, consider creating a temporary copy of the UAT environment for further investigation.