SAP Knowledge Base Article - Public

3252520 - Error message "Problem occurred: Error while executing a database procedure" shows up during an MRP run


You schedule an MRP run using app Schedule MRP Runs, however, the run fails with an error message "Problem occurred: Error while executing a database procedure".



Reproducing the Issue

1. Open app Schedule MRP Runs.
2. Schedule an MRP run with proper parameters.
3. After the run finished, the status is "Failed".
4. Open the log, you can find the mentioned error message.


The root cause of the issue might be the exhaustion of the number ranges of purchase requisitions (PRs) .


The error message can be eliminated with the following 2 steps:
1. Extend the number ranges of PRs in SSCUI 105616 - Define Number Ranges for Purchase Requisitions.
2. Assign the extended number ranges of PRs to MRP on a plant level in SSCUI 102397 - Assign Number Ranges for MRP Run to Plant. 

In the meanwhile, you are strongly suggested to run MRPs in planning mode 1, rather than planning mode 3, to avoid the number ranges from being exhausted.


Schedule MRP Runs, number range, purchase requisition, SSCUI, 105616, 102397, planning mode , KBA , PP-MRP , Material Requirements Planning , Problem


SAP S/4HANA Cloud all versions