Cleanup Messages In AIAJMSModule Error Queue

(Doc ID 2412804.1)

Last updated on JUNE 19, 2018

Applies to:

Oracle Process Integration Pack for Oracle Utilities Field Work - Version 12.1.0.0.0 and later
Information in this document applies to any platform.

Goal

LAst year, customer upgraded CCB, MWM, SOA, and FWPIP.  Customer has a process to look at the AIA JMS Modules in WebLogic when there are issues and to retry failed messages. Today, the CCB and MWM error queues have the following numbers:

For CCB:
Services > Messaging > JMS Module > AIAJMSModule > AIA_OUCCBWorkOrderJMSQueue_ErrorQ

AIAJMSModule!AIAJMSServer_auto_1@AIA_OUCCBWorkOrderJMSQueue_ErrorQ 84042
AIAJMSModule!AIAJMSServer_auto_2@AIA_OUCCBWorkOrderJMSQueue_ErrorQ 71709

For MWM:
Services > Messaging > JMS Module > AIAJMSModule > AIA_OUMWMWorkOrderJMSQueue_ErrorQ

AIAJMSModule!AIAJMSServer_auto_1@AIA_OUMWMWorkOrderJMSQueue_ErrorQ 463
AIAJMSModule!AIAJMSServer_auto_2@AIA_OUMWMWorkOrderJMSQueue_ErrorQ 392

Customer would like to clean these items from the queue. What is the best way to remove (archived or delete) these items?  Customer does not want to retry these as the older transaction may cause more harm than good.
 

Solution

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