B2B 11g: Inbound and Outbound EDIEL Messages get Stuck in MSG_WAIT_FA (never MSG_COMPLETE) (Doc ID 1553163.1)

Last updated on NOVEMBER 13, 2023

Applies to:

Symptoms

The scenario has inbound EDIEL MSCONS messages that are acknowledged with outbound CONTRL messages. For each MSCONS there is an outbound EDIEL APERAK, which is acknowledged with an inbound CONTRL. In this case both the inbound MSCONS messages and the outbound APERAK messages sometimes get stuck in MSG_WAIT_FA even though B2B has sent an outbound CONTRL with status MSG_COMPLETE or has received and processed an inbound CONTRL with status MSG_COMPLETE. There is no hard and fast rule, but for 50.000+ messages about two thirds suffer from this problem.

If we put 1000 inbound MSCONS messages put into a file listening channel. Each are acknowledged with outbound CONTRL messages. All 1000 CONTRL messages end up in MSG_COMPLETE state, but only a small number of the MSCONS messages end up in MSG_COMPLETE, with the majority staying in MSG_WAIT_FA. It is expected that all 1000 MSCONS messages would end up in MSG_COMPLETE since all of the CONTRL acks have been sent.

The scenario works fine if say only one MSCONS message is put into the listening channel, the bulk handling of messages is what triggers the state problem.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.