Timed Batches Do Not Work
Last updated on JANUARY 03, 2018
Applies to:Oracle Utilities Customer Care and Billing - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, UT - Utilities
Batch does not work
Having issues with the timed generation when using the Batch Control in our production environment. This involves a job that is used to generate hourly reports, but without satisfying results.
After setting the Batch Control Type to “Timed” and the Timer Interval to 3600 (1 hour) and Timer Active to Yes, but the result is as follows:
Table CI_BATCH_JOB. batch_job_stat_flg =ST / PD
The job does not run.
Some of the times, the batch_job_stat_flg is set to ST, others it remains in PD but without ever starting or finishing correctly. This causes that all the jobs following after the ‘CMBPOBT’ execution to not run, and wait for this batch to end before their execution starts. This stops the whole flow of batch executions in standby state.
Unable to produce logs of the issue, because this only happens in production environment, and we cannot risk blocking all the other sequential jobs.
There is a screenshot 1 example of the batch control attached.
Another issue with the batch is that is only runs when using the Batch Job Submission and the field “Thread Number” must be set to 1, otherwise it remains eternally in the state ”Pending” . Please refer to screenshot 2. (Attached)
At this time, the only way we have of running the batch successfully is by configuring a batch job submission one by one, hour by hour, and setting the date and time and thread number.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms