SAPLCKMS CX_SY_OPEN_SQL_DB short dump Solution

If you are triying to execute T-CODE CKMLCP of "Costing Cockpit change"  and getting a short dump:

CX_SY_OPEN_SQL_DB

Open SQL array insert produces duplicate records in the database.

Error in the ABAP application program.

The current ABAP program "SAPLCKMS" had to be terminated because it found a
statement that could not be executed.

This happend because you need to reset the  number Range Buffer. During posting procedures within CO or updates to CO, short dumps with the message 'ABAP/4 runtime error SAPSQL_ARRAY_INSERT_DUPREC' occur. The termination occurs at the following point in the program SAPLKAUP (LKAUPF01): 'INSERT COBK FROM TABLE COBK_INS.'.

Cost management settelment job, CPTD, DBSQL_DUPLICATE_KEY_ERROR-COBK, deprecation run, DBSQL_DUPLICATE_KEY_ERROR INSERT COEP, deadlock table nriv, monthly depreciation, TABLE COEP_INS, express document cancelled.

Solution:

Apply the following note: Note

This its what the note say you need to do:

Solution First, reset the number range buffer of the application server: Call transaction SM56 and choose 'Goto -> Number Range Buffer -> Reset'. Fill the fields of the following dialog field as follows: Clilent Object RK_BELEG Subobject Range Year Global reset X Start the report RKANRCHK for the relevant controlling area. The system lists all number range intervals with internal number assignment for which CO documents already exist between the current number level and the upper interval limit. In Customizing, use the relevant maintenance transaction to set the current number level of the interval to the highest document number assigned so far. Alternatively, assign a new number range interval to the relevant procedures. You can find the maintenance transaction in Customizing, under the path 'Controlling -> Controlling General -> Organization'.