Error When Trying To Run Auto Purge
(Doc ID 2374834.1)
Last updated on AUGUST 11, 2023
Applies to:
Oracle Business Process Management Suite - Version 12.1.3.0.0 to 12.1.3.0.0 [Release 12c]Oracle SOA Suite - Version 12.2.1.3.0 and later
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
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |