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***

Symptoms

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>
SQL>
SQL> spool off;

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