Error while deleting the job via JIL

Document ID : KB000044009
Last Modified Date : 14/02/2018
Show Technical Document Details

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:  

CA WAAE 11.3 & 11.3.*

Workaround:

1. On the oracle db, run:

update ujo_job set is_active=0 where job_name='JOB_1'

2. Navigate to $AUTOSYS/bin and run:

#archive_jobs -j 1

3. Check if the job is deleted by running:

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.