Oracle Transportation Management (MOSC)

MOSC Banner

How to dequeue messages from an internal exception queue.

All:

I am looking for information on how to dequeue messages from an internal exception queue used by OTM 6.3.6. On rare occasions we get messages in what I believe is called an internal exception queue. These queues have a name that begins with AQ$. For example, I have an outbound queue named ETMS_OUTBOUND_CRS with an exception queue named AQ$_ETMS_OUT_CRS_TABLE_E in glogowner. If I attempt to execute GLOGOWNER.PKG_QUEUE_MANAGEMENT.DELETE_QUEUE_ENTRIES ('AQ$_ETMS_OUT_CRS_TABLE_E') as glogdba, AQ$_ETMS_OUT_CRS_TABLE_E gets dropped but not recreated. This causes a problem for me in that I then have to a DBA recreate both the outbound queue ETMS_OUTBOUND_CRS and AQ$_ETMS_OUT_CRS_TABLE_E. I asked

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center