SOA12c Purge In Infinite Loop When Temp_flowid_purge Pruned Empty
Last updated on APRIL 19, 2017
Applies to:Oracle SOA Suite - Version 188.8.131.52.0 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.
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