ASNOut Messages Are Stuck in etASNOut RIB Topic (Doc ID 1596888.1)

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Retail Integration Bus - Version 13.2.3 and later
Information in this document applies to any platform.

Symptoms

In Oracle Retail Integration Bus (RIB) 13.2.3, ASNOut messages are stuck in etASNOut RIB topic.  The ETASNOUTTABLE table in the AQ database is showing a number of records stuck on the topic.  Records are increasingly getting stuck and are not processed at all.

In addition, the following queries were found to be running for a long time (more than 24 hours) in the DB:


Once this DB session is killed, records are processed.

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