Workload Automation AE: Event stops processing causing job to no longer run

book

Article ID: 186059

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent CA Workload Automation AE

Issue/Introduction

An AutoSys job has all of a sudden stopped processing. Manual intervention may be required to re-evaluate event in order to resume normal scheduling of job.

 

Cause

Due to database deadlock, which is common in Microsoft SQL Server Databases.

[03/06/2020 03:00:09]     CAUAJM_E_18802 Error from SQLExecute() Failed with SQL_ERROR.
[03/06/2020 03:00:09]     CAUAJM_E_18601 SQLSTATE: 40001, Native error: 1,205, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 79) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
[03/06/2020 03:00:09]     CAUAJM_E_18607 Event Server: <waaedev,1433:aedb>  Failed Stored Procedure: <{? = CALL ujo_setup_next (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} <<1,36206,'D1101qytpb00',' ',0,'Event was scheduled based on job definition.',1583481660,1,1583556960,1,'D11',' ',0,' ',0>>>
[03/06/2020 03:00:09]     CAUAJM_E_10160 The execution of the below query experienced an unrecoverable error and will not be retried:
[03/06/2020 03:00:09]     CAUAJM_I_18030 Event Server: <waaedev,1433:aedb>  Completed Stored Procedure: <{? = CALL ujo_setup_next (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} <<1,36206,'D1101qytpb00',' ',0,'Event was scheduled based on job definition.',1583481660,1,1583556960,1,'D11',' ',0,' ',0>>>
[03/06/2020 03:00:09]     CAUAJM_E_10123 Trouble updating 'next_start' for job: my_test_job_dev
[03/06/2020 03:00:09]     CAUAJM_E_40197 Error evaluating next start time for job <my_test_job_dev>. Cannot reschedule the job.
[03/06/2020 03:00:09]     CAUAJM_E_40225 Trouble processing Event [D1101qytop02]!

Environment

Release : 11.3.6 SP5
Component : CA Workload Automation AE 

Resolution

The Database Administrator should review and determine the cause for the deadlock.
In the meantime, the job can be force started to resume normal schedule operations.