My Oracle Support Banner

PrmPrcChg Family Messages Consumed and Fail in SIOCS MPS_STAGED_MESSAGE (Doc ID 3057067.1)

Last updated on MARCH 28, 2025

Applies to:

Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

SIOCS consumes messages from MultiBuyPromoDel Message Type into MPS_STAGED_MESSAGE.

PrmPrcChg Family - Message Types (MultiBuyPromoCre, MultiBuyPromoMod, MultiBuyPromoDel)

This is causing the server to become unstable and see below error:


sim-server1.log

000337> <[STUCK] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "3,030" seconds working on the request "Workmanager: default, Version: 0, Scheduled=false, Started=true, Started time: 3030064 ms
", which is more than the configured time (StuckThreadMaxTime) of "3,000" seconds in "server-failure-trigger". Stack trace:
....
oracle.retail.sim.server.dataaccess.daoimpl.PriceChangeOracleDao.insert(Unknown Source)
oracle.retail.sim.server.dataaccess.daoimpl.PriceChangeOracleDao$Proxy$_$$_WeldClientProxy.insert(Unknown Source)

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.