My Oracle Support Banner

Purge Not Cleaning All Records (Dangling Records) (Doc ID 2650841.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle SOA Suite - Version 12.2.1.2.0 and later
Oracle Business Process Management Suite - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

In some cases with the SOA, there will be instances that cannot been cleaned after purge or auto-purge (a.k.a. dangling records).

Execute the below SQL queries as SOAINFRA user to see whether a significant number of instances are not being purged:

I) Check the number of instances in a particular state:

  

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.