My Oracle Support Banner

"ORA-02292: integrity constraint (ODI_REPOSITORY_SCHMA_NAME.FK_SNP_SESSION_SB) violated - child record found" Error Thrown During ODI Purge Log (Doc ID 2681197.1)

Last updated on AUGUST 07, 2024

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 to 12.2.1.4.200721 [Release 12c]
Oracle Data Integrator Cloud Service - Version 17.1.3 to 17.2.1
Oracle Data Integrator on Marketplace - Version 1.0.2 to 12.2.1.4.200721
Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.201020 [Release 12c]
Information in this document applies to any platform.

Symptoms

When attempting to purge the Session log using the Oracle Data Integrator (ODI) Operator purge log tool, the following error occurs:

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.