Error Processing RmsCountSchedule Messages in MPS_STAGED_MESSAGE - CreationException: null
(Doc ID 3021335.1)
Last updated on MAY 14, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 24.0 and laterInformation in this document applies to any platform.
Symptoms
On : 24.0 version, Inventory Management
When processing RmsCountSchedule message type messages after installing a patch, you are getting the following error:
ERROR
-----------------------
Caused by: oracle.retail.sim.common.core.SimServerException: Error executing query statement. CreationException: null
at oracle.retail.sim.server.dataaccess.BaseOracleDao.querySingle(Unknown Source)
at oracle.retail.sim.server.dataaccess.BaseOracleDao.queryForLong(Unknown Source)
at oracle.retail.sim.server.dataaccess.BaseOracleDao.selectNextId(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.RmsPublishOracleDao.getNextStockCountScheduleId(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.RmsPublishOracleDao.insertStockCountSchedule(Unknown Source)
at oracle.retail.sim.server.dataaccess.daoimpl.RmsPublishOracleDao$Proxy$_$$_WeldClientProxy.insertStockCountSchedule(Unknown Source)
at oracle.retail.sim.server.integration.publisher.dps.StockCountScheduleRmsPublisher.processDeo(Unknown Source)
at oracle.retail.sim.server.integration.publisher.dps.StockCountScheduleRmsPublisher.handleMessage(Unknown Source)
at oracle.retail.sim.server.integration.publisher.SimMessagePublisherProviderImpl.publish(Unknown Source)
... 63 more
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1 - Try to process the following message in MPS
<?xml version="1.0" encoding="UTF-8"?>
<StockCountScheduleRmsDeo>
<scheduleId>1971</scheduleId>
<scheduleDate>2024-03-10T12:00:00Z</scheduleDate>
<storeIds>5000</storeIds>
<allItems>false</allItems>
</StockCountScheduleRmsDeo>
2 - See the error as above.
Due to this issue, users cannot process the stock count schedule.
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 |
Cause |
Solution |