ORA-20006: Workflow thread does not exist” exceptions during task processing after a Database Purge

(Doc ID 1620312.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Communications Order and Service Management - Version 7.2.0 to 7.2.2 [Release 7.2]
Information in this document applies to any platform.
This KM note applies to OSM 7.2.0.7, 7.2.0.8 , 7.2.2.2 and 7.2.2.3
***Checked for relevance on 16-JUL-2015***

Symptoms

Beginning with 7.2.0.7 you can use the om_part_maintain.purge_partitions procedure to purge partitions. This procedure allows you to retain orders that do not satisfy the purge criteria and optionally consolidate retained orders into a single partition while dropping empty purged partitions. This is done by specifying an order ID range that spans multiple partitions and supplying a_drop_empty_ptns=true (the default). In this case, in the releases affected by this bug, purge_partitions erroneously deletes some rows from om_order_flow_coordinator and om_coord_node_instance tables that should be retained while consolidating partitions. The missing rows give rise to these exceptions during task processing:

You will see several instances of this exception in the OSM log file for each affected task because of repeated transaction rollbacks and JMS message redelivery. After each of those JMS messages reaches the redelivery limit configured for its queue it is redirected to the configured error queue. As a result, the order gets stuck.

 

This issue is not present in 7.0.1 and 7.0.3 because these releases do not have the ability to consolidate purged partitions. This issue is also not present in 7.2.x in the following cases:

•             You purge entire partitions

•             You retain orders but you purge only one partition at a time

•             You retain orders and you purge multiple partitions but you don’t drop empty partitions during the purge (a_drop_empty_ptns=false).

Changes

 

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