Performance Issue: A Large Number of Records Are Stuck in MPS_STAGE_MESSAGE Table (Doc ID 1937981.1)

Last updated on DECEMBER 02, 2016

Applies to:

Oracle Retail Store Inventory Management - Version 14.0.1 to 14.0.2 [Release 14.0]
Information in this document applies to any platform.

Symptoms

The issue described in this document is known to Oracle, and a fix is already scheduled for future release.
This article will be updated as official patch becomes available.


In Store Inventory Management (SIM) 14.0.1, when attempting to process a large number of messages in MPS_STAGE_MESSAGE table, the performance is extremely bad and the following error occurs in the log:


Steps to Reproduce:

  1. Create many new messages in Retail Merchandising System (RMS) and let them flow to SIM.
  2. SIM almost stops processing any message in table MPS_STAGE_MESSAGE.

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