Error When Trying To Run Auto Purge

(Doc ID 2374834.1)

Last updated on MAY 10, 2018

Applies to:

Oracle SOA Suite - Version 12.2.1.3.0 and later
Oracle Business Process Management Suite - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

 The error below is seen when running Auto Purge:

javax.management.RuntimeMBeanException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint (DEV1P_SOAINFRA.FA_CORR_FLOW_INSTANCE_FK) violated - child record found ORA-06512: at "DEV1P_SOAINFRA.SOA", line 707 ORA-06512: at "DEV1P_SOAINFRA.SOA", line 3158 ORA-06512: at "DEV1P_SOAINFRA.SOA", line 2010 ORA-06512: at "DEV1P_SOAINFRA.SOA", line 1512 ORA-06512: at line 1 Error Code: 2292 Call: BEGIN soa.run_auto_purge_job(job_name_v=>?); END; bind => [1 parameter bound] Query: ResultSetMappingQuery(name="soa.run_auto_purge_job" )

 

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