Workload Automation AE: Event stops processing causing job to no longer run
Article ID: 186059
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)
CA Workload Automation AE - System Agent (AutoSys)
CA Workload Automation AE - Scheduler (AutoSys)
Workload Automation Agent
Autosys Workload Automation
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.
Environment
Workload Automation AE
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]!
[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]!
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.
In the meantime, the job can be force started to resume normal schedule operations.
Feedback
Yes
No
Powered by
