Issue With CI_MSG_LOG Table , All The Batches Have The Unique Constraint Error (Doc ID 2662530.1)

Last updated on JUNE 15, 2021

Applies to:

Symptoms

On : 2.6.0.1.0 version

ACTUAL BEHAVIOR
---------------
Issue with CI_MSG_LOG table , all the batches have the Unique constraint error

Whenever there is a pending bill on usage account and has bill segments in error its is setting the error in CI_MSG_LOG saying Bill segment status invalid.

In CI_MSG_LOG table , all the batches have the Unique constraint error

 Error executing update for rawSQL:
  INSERT INTO CI_MSG_LOG ( SCHEDULER_ID, MESSAGE_SEQ, PROGRAM_NAME, MESSAGE_CAT_NBR, MESSAGE_NBR, MSG_SEVERITY_FLG, TBL_NAME, FLD_NAME, CALL_SEQ, VERSION) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, 1) /* SQL for program 'com.splwg.ccb.domain.common.common.ProgramCIPZMSGN_Impl', SQL name 'I_MSG' */
 with 'FixedCHAR' parameter named 'I-MSG-IN-DATA.TBL-NAME' to : ' ' to indices: 7
 with 'FixedCHAR' parameter named 'I-MSG-IN-DATA.PROGRAM-NAME' to : 'CIPBICGB' to indices: 3
 with 'string' parameter named 'I-MSG-IN-DATA.CALL-SEQ-VC' to : ' ' to indices: 9
 with 'integer' parameter named 'I-MSG-IN-DATA.MESSAGE-SEQ' to : '1' to indices: 2
 with 'integer' parameter named 'I-MSG-IN-DATA.MESSAGE-NBR' to : '11913' to indices: 5
 with 'integer' parameter named 'I-MSG-IN-DATA.SCHEDULER-ID' to : '2376747' to indices: 1
 with 'FixedCHAR' parameter named 'I-MSG-IN-DATA.FLD-NAME' to : ' ' to indices: 8
 with 'integer' parameter named 'I-MSG-IN-DATA.MESSAGE-CAT-NBR' to : '25' to indices: 4
 with 'FixedCHAR' parameter named 'I-MSG-IN-DATA.MSG-SEVERITY-FLG' to : '10' to indices: 6

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (CISADM.SYS_C0045901) violated

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.