SA-11927

Summary

Errors occur when IS61x_Concurrency_DataCleanup.sql, provided with Hotfix-796, is run.

Error Messages

ORA-00001: unique constraint (CDM_IS.SYS_C0023456) violated.
ORA-00001: unique constraint (CDM_IS.SYS_C0023456) violated
ORA-06512: at line 186
00001. 00000 - "unique constraint (%s.%s) violated"
*Cause: An UPDATE or INSERT statement attempted to insert a duplicate key.
For Trusted Oracle configured in DBMS MAC mode, you may see
this message if a duplicate entry exists at a different level.
*Action: Either remove the unique restriction or do not insert the key.
SYS_C0023457 is the primary key constraint created on CHRD_IFR_LAST_OFFRD.
SYS_C0023456 is the primary key constraint created on CHRD_IFR_NUM_OFFERS.

Steps to Reproduce

Run the IS61x_Concurrency_DataCleanup.sql provided with Hotfix-796.

Root Cause

The data cleanup script was executed multiple times on the same database without completing any execution successfully. This results in the data still present in the temporary tables.

Resolution

Perform the following local-change:

1. Drop the IS_FACT_RESPONSE table and all other temporary tables created by a previous execution of the data clean-up script.
2. Re-create the IS_FACT_RESPONSE table from the backup.
3. Run the script again.