SAP Note 24097 - CO01/CO40:Termination: "ERROR DURING STATUS_UPDATE"

Symptom:

When you create a production order, the system generates error message: "ERROR DURING STATUS_UPDATE" The update was canceled
ABAP processor: SAPSQL_ARRAY_INSERT_DUPREC;
The termination occurred in the ABAP/4 program "SAPLBSVU"

Cause and prerequisites

The copying of sales order data between clients means that objects were transferred with numbers that are higher than the current status of the respective number range objects in the target client. When a new order is created, number assignment according to the status of the number range objects results in double entries.

Solution
You must adapt the status of the number range objects according to the copied data: In the configuration menu of Master Planning (Transaction OLPF) under Master Data -> Order -> Number ranges (Transactions CO80, CO81, CO82, CO83, CY89).
You can transport the statuses of the number range objects from the source client of your copied sales order data into the target client.
However, you should always be careful when changing the number ranges since multiple assignment of the same numbers can result in IRREPARABLE inconsistencies in your system.
You should only ever INCREASE the current status of a number range object !!!
You can determine the highest number status of the respective objects with attached selection report. For the order numbers, you must note that the highest current number status can only be determined correctly if no external number assignment was used.

Additional key words

CO01, CO40, CO41, MD04, VA01, COR1, Create order