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.
Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Environment:
CA WAAE 11.3 & 11.3.*
Workaround:
update ujo_job set is_active=0 where job_name='JOB_1'
#archive_jobs -j 1
autorep -j JOB_1
Additional Information:
By setting is_active=0, we are disabling the job and by running archive_jobs manually, we delete the job from database.