Error while deleting the job via JIL
Article ID: 44009
Updated On:
Products
Issue/Introduction
Problem & Symptoms:
Unable to update / delete the job via jil due to below error:
CAUAJM_I_50323 Inserting/Updating job: JOB_1
CAUAJM_E_10163 Exhausted maximum number of query retries.
CAUAJM_E_10160 The execution of the below query experienced an unrecoverable error and will not be retried:
CAUAJM_E_10620 Return values from dual database writes disagree. Databases may no longer be synchronized. ID[45] ESA[1] ESB[-1982]
CAUAJM_E_10160 The execution of the below query experienced an unrecoverable error and will not be retried:
CAUAJM_E_19028 Job <JOB_1> could not be modified properly due to a database failure. The job definition is in an unknown state.
CAUAJM_E_10302 Database Change WAS NOT successful.
Environment
Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Environment:
CA WAAE 11.3 & 11.3.*
Resolution
Workaround:
- On the oracle db, run:
update ujo_job set is_active=0 where job_name='JOB_1'
- Navigate to $AUTOSYS/bin and run:
#archive_jobs -j 1
- Check if the job is deleted by running:
autorep -j JOB_1
Additional Information
Additional Information:
By setting is_active=0, we are disabling the job and by running archive_jobs manually, we delete the job from database.
Feedback
