Demantra Table ReOrg: Unique Constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) Violated ORA-00603 ORA-00600 (Doc ID 1606642.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.1.4 and later
Information in this document applies to any platform.

Symptoms

Updates from worksheet are failing with error:

ODPM: 10303: Application could not process your update request. encountered system inconsistencies.

The collaborator.log shows the following :

java.sql.SQLException: ORA-00603: ORACLE server session terminated by fatal error
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghalf()+55] [SIGSEGV] [ADDR:0x68] [PC:0x9367EE3] [Address not mapped to object] []
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kghalf()+55] [SIGSEGV] [ADDR:0x68] [PC:0x9367EE3] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [kqlidchg0], [], [], [], [], [], [], [], [], [], [], []
ORA-00604: error occurred at recursive SQL level 1
ORA-00001: unique constraint (SYS.I_PLSCOPE_SIG_IDENTIFIER$) violated

Changes

We were doing Table Reorg on the SALES_DATA table using seeded procedure TABLE_REORG.REORG, which has been done successfully before.

Last ACTION_NAME in table LOG_TABLE_REORG appears as 'compile_invalid_objects'.

After a successful run the last ACTION_NAME is usually 'reorg_complete'.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms