2972444 - SM:SCMON_CONTROL job fails with DBSQL_DUPLICATE_KEY_ERROR ST22 Dump

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.

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