SAP Knowledge Base Article - Public

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

Symptom

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".

Environment

SAP S/4HANA Cloud

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.

Cause

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

Resolution

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.

Keywords

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

Product

SAP S/4HANA Cloud all versions