My Oracle Support Banner

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 MARCH 14, 2019

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

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


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