"ORA-02292: integrity constraint (Schema.FK_CURRENT_LP_RUN) violated - child record found" Error When Using OdiPurgeLog Tool (Doc ID 2282677.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Data Integrator - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to purge the ODI session logs using the OdiPurgeLog tool in a package, the following error occurs:

 Session PURGE_LOGS (18337) fails with return code 7000.[[ ODI-1217: Session PURGE_LOGS (18337) fails with return code 7000. ODI-1226: Step OdiPurgeLog 1 fails after 1 attempt(s). ODI-1241: Oracle Data Integrator tool execution fails.
 Caused By: oracle.odi.core.exception.OdiRuntimeException: com.sunopsis.dwg.SQLWorkReposException: ORA-02292: integrity constraint (ODI_REPO.FK_CURRENT_LP_RUN) violated - child record found
 at com.sunopsis.dwg.dbobj.SnpLoadPlan$2.doAction(SnpLoadPlan.java:646) 
 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
 at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
 at com.sunopsis.dwg.dbobj.SnpLoadPlan.purgeLoadPlanLogs(SnpLoadPlan.java:634) at com.sunopsis.dwg.tools.PurgeLog.purgeLogs(PurgeLog.java:677)
 at com.sunopsis.dwg.tools.PurgeLog.actionExecute(PurgeLog.java:203)
 at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:219)
 at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:901)
 at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:582) ................

Changes

 

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