My Oracle Support Banner

Failed Messages are not Getting Retried to Retry Limit and Messages are Stuck in MPS_STAGED_MESSAGE Table. (Doc ID 2428101.1)

Last updated on AUGUST 16, 2022

Applies to:

Oracle Retail Store Inventory Management - Version 14.1 and later
Information in this document applies to any platform.

Symptoms

Store Inventory Management (SIM) is not retrying to process the staged messages after 1st trail and staged messages are not flagged as failed when retry limit is exceeded.

Steps To Recreate:

  1. Try publishing message of any family in SIM.
  2. If the message fails it will not be re-tried and the message will stay with retry count as 1 in MPS_STAGED_MESSAGE.
  3. Create any inbound message to SIM from external system such as RMS
  4. Make sure that the message has an error.
  5. Verify the retry limit for message_family "Global" in MPS_WORK_TYPE, it must be 30
  6. Observe in MPS_STAGED_MESSAGE table that the message is not getting retried to the "Global" message_family retry limit.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


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