"ORA-02292: integrity constraint (xxxx.FK_SNP_SESSION_SB) violated - child record found" When Running ODIPurgeLog in ODI 12c

(Doc ID 2049524.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

Runing the ODIPurgeLog gives error:

oracle.odi.core.exception.OdiRuntimeException: com.sunopsis.dwg.SQLWorkReposException: ORA-02292: integrity constraint (ODI_REPO.FK_SNP_SESSION_SB) violated - child record found.

 

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