After 100 Attempt Counts, Failure Message Gets Exception and turns Into Poison Message

(Doc ID 2098803.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Retail Integration Bus - Version 13.2 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.

Symptoms

On : 13.2.8 version, Failure

After reaching 100 attempt counts, hospital message gets an exception and goes like Poison message, when retried.
i.e A failure message retried from Retail integration Bus (RIB) Error Hospital for 101st time, gets below error and goes into POISON message scenario.

Error:

Steps to Reproduce:

1. Choose a message from RIB Error Hospital, where ATTEMPT_COUNT = 100. Note that there will be 100 rows in RIB_MESSAGE_FAILURE table for the chosen message.
2. From RIHA retry this massage for 101st time. Note the above errors in adapter log files:
3. Message still have business exception, but RIB is not able to create a new row (101st) in RIB_MESSAGE_FAILURE for this message.
4. Further message stays on JMS Topic with RIB_MESSAGE.IN_QUEUE=1 and fails as POISON resulting to shutting down of the adapter with above error.

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