My Oracle Support Banner

Error When Trying To Run Auto Purge (Doc ID 2374834.1)

Last updated on MAY 10, 2018

Applies to:

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


 The error below is seen when running Auto Purge: 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" )





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.