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

Last updated on APRIL 19, 2017

Applies to:

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

Symptoms

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.

Cause

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