Purge Failing With Error For Table XML_DOCUMENT : ORA-02292 Integrity Constraint B2B_DS_DOC_ID_FK Violated (Doc ID 1538253.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle SOA Suite - Version 11.1.1.4.0 and later
Information in this document applies to any platform.

Symptoms

 Executing a SOA purge script failed to delete orphaned instances in the XML_DOCUMENT table.  The following errors occur when running the soa.delete_instances procedure to purge old instances:

: Purge XML_DOCUMENT. Error Code = -2292, Error Message = ORA-02292: integrity constraint (SOAINFRA_SCHEMA.B2B_DS_DOC_ID_FK) violated - child record found
18-MAR-2013 14:29:28
: Create temp_cube_instance using CPST_INST_CREATED_TIME. Error Code = -2292, Error Message = ORA-02292: integrity constraint (SOAINFRA_SCHEMA.B2B_DS_DOC_ID_FK) violated - child record found
18-MAR-2013 14:29:28
: ERROR (deleteNoCompositeIdInstances). Error Code = -2292, Error Message = ORA-02292: integrity constraint (SOAINFRA_SCHEMA.B2B_DS_DOC_ID_FK) violated - child record found
18-MAR-2013 14:29:28
: ERROR(delete_instances) . Error Code = -2292, Error Message = ORA-02292: integrity constraint (SOAINFRA_SCHEMA.B2B_DS_DOC_ID_FK) violated - child record found

 

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