Symptom
The job SM:SCMON_CONTROL fails with error:
SAP Usage Logging Note note is missing on system note
Internal session terminated with a runtime error DBSQL_DUPLICATE_KEY_ERROR (see ST22)
The subsequent ST22 dump is as follows:
Category ABAP Programming Error
Runtime Errors DBSQL_DUPLICATE_KEY_ERROR
Except. CX_SY_OPEN_SQL_DB
ABAP Program RAGS_CC_SCMON_CONTROL
Application Component SV-SMG-CCM
Short Text
Open SQL array insert produces duplicate records in the database.
What happened?
Error in the ABAP Application Program
The current ABAP program "RAGS_CC_SCMON_CONTROL" had to be terminated because
it has
come across a statement that unfortunately cannot be executed.
Information on where terminated
The termination occurred in ABAP program "RAGS_CC_SCMON_CONTROL", in
"INSERT_MISSING_NOTE". The main program
was "RAGS_CC_SCMON_CONTROL".
In the source code, the termination point is in line 100 of (Include)
program "S_CC_SCMON_CONTROL_F04".
Program "RAGS_CC_SCMON_CONTROL" was started as a background job.
Job name....... SM:SCMON_CONTROL
The termination is due to exception "CX_SY_OPEN_SQL_DB" occurring in procedure
"INSERT_MISSING_NOTE" "(FORM)".
This exception was not handled locally or declared in the RAISING
clause in the procedure's signature however.
The procedure is in program "RAGS_CC_SCMON_CONTROL". The source code begins in
line 94 of
(include) program "S_CC_SCMON_CONTROL_F04".
97 PERFORM delete_old_way_missing_note USING iv_system_id.
98 PERFORM delete_old_missing_note USING iv_system_id.
99
>>>>> INSERT ags_upl_setting FROM TABLE it_missing_notes_insert.
101
102 IF sy-subrc <> 0.
103 "202 Failure to update the missing SAP Notes status for system &1
104 MESSAGE i200(ags_cc_setup) WITH iv_system_id.
105 ENDIF.
Read more...
Environment
Solution Manager 7.2 SP10 - SP11
Product
Keywords
CCM, Custom Code Management, SM:SCMON_CONTROL, DBSQL_DUPLICATE_KEY_ERROR, RAGS_CC_SCMON_CONTROL , KBA , SV-SMG-CCM , Custom Code Management , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.