SAP Knowledge Base Article - Preview

2972444 - SM:SCMON_CONTROL job fails with DBSQL_DUPLICATE_KEY_ERROR ST22 Dump

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

SAP Solution Manager 7.2

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.