STKPRG_JOB Failing With ERROR: Duplicate key
(Doc ID 3062859.1)
Last updated on DECEMBER 10, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.1 and laterInformation in this document applies to any platform.
Symptoms
On : 24.1 version, Merch - Inventory Tracking
STKPRG_JOB failing with ERROR whenever the MFCS nightly is running.
Re-running the job manually is executed successfully.
ERROR
-----------------------
2024-12-04T11:01:28,677 [pool-4-thread-383] ERROR AbstractJobExecutor - An exception occurred :Duplicate key oracle.retail.apps.poam.agent.model.entity.BatchJobRequest@ef5c634[agentId=rmsbatchclient-7d679d9fb7-fnbbg_043445,applicationName=RMS,createDate=2024-12-04 11:01:28.0,cycleNumber=2,endTime=,execEngReqId=100879,info=,instanceId=069413ce-fe15-48c2-b49e-79d4d9040837,jobName=START_RIB_ADAPTOR_INV_JOB,jobPayload={"links":null,"workingDir":"/u01/retail/rms/oracle/proc/bin","script":"/u01/retail/rms/oracle/proc/bin/rmswrap.ksh","jobParameters":"dummy /@RMSAlias NIGHTLY_INV_END","safeMode":false,"safeModeSleepInterval":5,"estimatedRunTime":3600,"businessDate":"2024-12-03","killRequestId":null,"killCleanupScript":null,"restartRequestId":null,"priority":0,"phase":null,"sync":false,"hyperMediaContent":null},jobRunId=11990070,lastUpdateDate=2024-12-04 11:01:28.0,processName=RDE_START_RIB_ADAPTOR_INV_24x7_PROCESS,requestId=286916,requestType=EXEC,scheduleName=MERCH,schedulerDay=8070,startTime=2024-12-04 11:01:28.0,status=RUNNING]
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Allow STKPRG_JOB to run in nightly
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 |
| References |