Symptom
When creating inspection plan in Create Inspection Plan app, you get the error message "open SQL array insert produces duplicate records".
Environment
SAP S/4HANA Public Cloud
Cause
This is a data inconsistency.
Check in SSCUI 105731 - Define Number Ranges for Inspection Plans, we can see that the current number range status for inspection plan is smaller than the largest group number of inspection plan (can be checked in Manage Inspection Plans app). As a result, when creating an inspection plan, the system is trying to assign a group number that is already existing in the system, which will cause the duplicate key error.
Resolution
Set the number range status to a big enough value.
Keywords
inspection plan, QP01, open SQL, duplicate records, number range status, largest group number, SSCUI 105731 - Define Number Ranges for Inspection Plans , KBA , QM-PT-IP-2CL , Inspection Planning (Public Cloud) , Problem