Performance Issue: A Large Number of Records Are Stuck in MPS_STAGE_MESSAGE Table
(Doc ID 1937981.1)
Last updated on SEPTEMBER 16, 2019
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.
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