Error while deleting the job via JIL
search cancel

Error while deleting the job via JIL

book

Article ID: 44009

calendar_today

Updated On:

Products

CA Workload Automation AE - Scheduler (AutoSys) Autosys Workload Automation

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:

  1. On the oracle db, run:

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

  1. Navigate to $AUTOSYS/bin and run:

#archive_jobs -j 1

  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.