CAUAJM_E_19028 Job <> could not be modified properly due to a database failure. The job definition is in an unknown state.

Products

• Autosys Workload Automation

Issue/Introduction

Unable to delete a box job.
Below is the error being seen:

$ jil < deljob.jil
______________________________________________________________________________

CAUAJM_I_50200 Attempting to Delete Job: <Problem_Job_Name>
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_I_18030 Event Server: <AEDB>  Completed Stored Procedure: <BEGIN :RetVal := ujo_put_job (:I_insert,:I_joid,:I_job_ver,:I_over_num,:I_alarm_if_fail,:I_alarm_if_terminated, :I_alert,:I_application,:I_as_group,:I_auto_delete,:I_auto_hold,:I_avg_run_time,:I_box_joid,:I_box_name,:I_box_terminator,:I_continuous,:I_continuous_alert,:I_create_userid,:I_date_conditions,:I_days_of_week,:I_description,:I_destination_file,:I_envvars,:I_exclude_calendar,:I_external_app,:I_fail_codes,:I_has_blob,:I_has_box_failure,:I_has_box_success,:I_has_condition,:I_has_notification,:I_has_nr_cond,:I_has_override,:I_has_resource,:I_has_service_desk,:I_job_class,:I_job_load,:I_job_name, :I_newjob_name, :I_job_qualifier,:I_job_terminator,:I_job_type,:I_mach_name,:I_max_exit_success,:I_max_run_alarm,:I_min_run_alarm,:I_mode_type,:I_must_complete,:I_must_start,:I_n_retrys,:I_numero,:I_owner,:I_permission,:I_priority,:I_profile,:I_run_calendar,:I_run_window,:I_send_notification,:I_service_desk,:I_start_mins,:I_start_times,:I_sub_application,:I_success_codes,:I_tag,:I_term_run_time,:I_timezone,:I_wf_name,:I_status,:I_has_persist_payload,:I_has_persist_payload_var, :I_has_substitute_vars, :I_has_referring_jobs, :B_joid, :B_job_ver, :B_over_num, :B_wf_joid);  END; <<5,894116,-999,-999,0,0,'','','',0,0,0,-1,'',0,0,'','<autosysuser>@<hostname>.<example>.<com>   ',0,'','','',0,'','','',0,0,0,0,0,0,0,0,0,'',0,'','','',0,0,'',0,0,0,0,'','',0,0,'','',0,'','','',0,0,'','','','','',0,'','',0,0,0,0,0>>>
CAUAJM_E_19028 Job <> could not be modified properly due to a database failure. The job definition is in an unknown state.

CAUAJM_E_50201 Delete was not performed!
______________________________________________________________________________
CAUAJM_E_50198 Exit Code = 1
______________________________________________________________________________

 

Environment

Autosys 12.x 24.x

Cause

Problem with job data in the database

Resolution

It will be required to flag the job as deleted in the database directly.

Note:
Then archive_events and archive_jobs can purge it based on your archive retention settings.

It is recommended to have a DBA review and perform the following operations:

select joid from ujo_job where job_name='<Problem_Job_Name>';

Then take the number returned from the above query and use it as the value for X in the next two statements

update ujo_job set is_active=0 where joid=X
delete from ujo_job_tree where joid=X;


Commit those changes and confirm if "autorep -q -J <Problem_Job_Name>" returns without showing you the job definition.

Note:
If you are running Autosys in dual database mode, it will be required to run the above operation on BOTH databases.