DLYPRG_JOB Batch Job Failing as art of Nightly Batch
(Doc ID 2816931.1)
Last updated on JUNE 22, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]Information in this document applies to any platform.
Symptoms
The DLYPRG_JOB batch job is failing as part of the night batch.
It is throwing the following exception:
2021-06-23T15:43:12,862 [[ACTIVE] ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR AbstractPOMBatchlet - An exception occurred Forked process failed, returned exit code(255).
java.lang.RuntimeException: Forked process failed, returned exit code(255).
at oracle.retail.apps.poam.ext.jobadmin.batchlet.AbstractPOMBatchlet.throwRuntimeException(AbstractPOMBatchlet.java:403) [PomJobAdminExtensions.jar:?]
at oracle.retail.apps.poam.ext.jobadmin.batchlet.custom.BatchShellCommandRunnerBatchlet.doWork(BatchShellCommandRunnerBatchlet.java:78) ~[PomJobAdminExtensions.jar:?]
at oracle.retail.apps.poam.ext.jobadmin.batchlet.AbstractPOMBatchlet.process(AbstractPOMBatchlet.java:139) [PomJobAdminExtensions.jar:?]
at com.ibm.jbatch.container.artifact.proxy.BatchletProxy.process(BatchletProxy.java:33) [com.ibm.jbatch.container-1.0.3.jar:1.0.1]
For reference, this is what is showing on JOB_AUDIT_LOGS for this execution:
Connection established successfully.
Started by default user
dlyprg_1~20210623154311~del_item~ITEM_MASTER~-20001~ORA-20001: ~CLOSE cursor C_ITEM in package DEL_ITEM ITEM: , key_value=101
-
CLOSE cursor C_ITEM in package DEL_ITEM ITEM: , key_value=101
Thread 1 - Aborted in process.
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 |