My Oracle Support Banner

SOA12c Purge In Infinite Loop When Temp_flowid_purge Pruned Empty (Doc ID 2254843.1)

Last updated on JULY 31, 2023

Applies to:

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


The SOA 12c purge runs into an infinite loop when the records in the table temp_flowid_purge are pruned empty

10-NOV-2016 03:32:01 : stoptime = 10/NOV/2016:03/32
10-NOV-2016 03:32:01 : loop count = 1774
10-NOV-2016 03:32:01 : deleting instances
10-NOV-2016 03:32:01 Number of rows in table temp_flowid_purge Inserted = 346
10-NOV-2016 03:32:02 Number of rows in table temp_flowid_purge Correlated flows pruned = 346

this results in 0 records left in table temp_flowid_purge and purge should be stopped, hence there are no flows left to delete.




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

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