Performance Issue: A Large Number of Records Are Stuck in MPS_STAGE_MESSAGE Table
Last updated on MAY 23, 2018
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.
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:
- Create many new messages in Retail Merchandising System (RMS) and let them flow to SIM.
- SIM almost stops processing any message in table MPS_STAGE_MESSAGE.
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