My Oracle Support Banner

Error running prodfixsql script - 9662059.sql; ORA-02292: integrity constraint (ASAP.FK_DL_CO_CA_VA__CO_CA_VA) (Doc ID 1324889.1)

Last updated on JULY 29, 2013

Applies to:

Oracle Communications MetaSolv Solution - Version 6.0.15 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Jul-2013***


Received a "ORA-02292: integrity constraint (ASAP.FK_DL_CO_CA_VA__CO_CA_VA) violated - child record found" error running the 9662059.sql file when upgrading from 6.0.15.b693 to 6.0.15.b745. Below is the error captured in the 9662059.log:

Procedure created.

SQL> show errors;
No errors.
SQL> --EDIT the below statement
SQL> execute ASAP.SP_9662059;
Fetch Started Time : Mon 21-Feb-2011 10:44:38
--last chance exception failure
-- -2292, ORA-02292: integrity constraint (ASAP.FK_DL_CO_CA_VA__CO_CA_VA) violated - child record found
--Area: STEP 2
--Action: del
--Related_Table: asap.conn_ca_value
--Severity: FATAL
--Addl Info: Deleted from conn_ca_value
--Contact customer support

PL/SQL procedure successfully completed.

SQL> --EDIT the below statement
SQL> drop procedure ASAP.SP_9662059;

Procedure dropped.

SQL> spool off;


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

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