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
ABAP Program RAGS_CC_SCMON_CONTROL
Application Component SV-SMG-CCM
Open SQL array insert produces duplicate records in the database.
Error in the ABAP Application Program
The current ABAP program "RAGS_CC_SCMON_CONTROL" had to be terminated because
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
In the source code, the termination point is in line 100 of (Include)
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
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.
>>>>> INSERT ags_upl_setting FROM TABLE it_missing_notes_insert.
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.
Solution Manager 7.2 SP10 - SP11
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 pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.