My Oracle Support Banner

"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 OCTOBER 04, 2022

Applies to:

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


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( 
 at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(
 at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(
 at com.sunopsis.dwg.dbobj.SnpLoadPlan.purgeLoadPlanLogs( at
 at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(
 at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(
 at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand( ................


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.