Re-deployment Of Cartridge Failed - ORA-02292: Integrity Constraint Violated - Child Record Found

(Doc ID 2242611.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Communications Order and Service Management - Version 7.2.2 and later
Information in this document applies to any platform.

Goal

Re-deployment of cartridge failed with the error: ORA-02292: integrity constraint violated - child record found  

ERROR
-----------------------
[java] [deployCartridge] <07-Mar-2017 1:06:34,922 CET PM> <ERROR> <cartridgemgmt.DeployCartridgeMDB> <[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'> <Cartridge deployment failed:>
    [java] [deployCartridge] com.mslv.oms.metadatahandler.handler.HandlerException: Exception thrown while deploying MetadataEntity entity [Process:ipbs_create_access]
    [java] [deployCartridge]   at com.mslv.oms.metadatahandler.handler.DeployHandler.deploy(Unknown Source)
    [java] [deployCartridge]   at com.mslv.oms.metadatahandler.operation.ImportOperation.processEntity(Unknown Source)
    [java] [deployCartridge]   at com.mslv.oms.metadatahandler.operation.ImportOperation.doProcess(Unknown Source)

 [java] [deployCartridge] Caused by: com.mslv.oms.metadatahandler.dataaccesslayer.ProxyException: ORA-02292: integrity constraint (ORDERMGMT4.FK_OM_ORDER_POS_INPUT_02) violated - child record found
    [java] [deployCartridge] Nested Exception: ORA-02292: integrity constraint (ORDERMGMT4.FK_OM_ORDER_POS_INPUT_02) violated - child record found
    [java] [deployCartridge] Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (ORDERMGMT4.FK_OM_ORDER_POS_INPUT_02) violated - child record found

Solution

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