My Oracle Support Banner

DLYPRG_JOB Batch Job Failing as art of Nightly Batch (Doc ID 2816931.1)

Last updated on OCTOBER 26, 2021

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.