ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to execute jobs

book

Article ID: 200525

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) Workload Automation Agent CA Workload Automation AE

Issue/Introduction

Getting the following in Autosys log when executing job.

 

[09/29/2020 13:47:31]     CAUAJM_I_10082 [NAUSP-WAPP0991 connected for test_prd 101.4.1]
[09/29/2020 13:47:32]     CAUAJM_E_18802 Error from SQLExecute() Failed with SQL_ERROR.
[09/29/2020 13:47:32]     CAUAJM_E_18601 SQLSTATE: 42000, Native error: 229, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'ujo_afm_sendevent', database 'AEDB_PRD_NEW', schema 'dbo'.
[09/29/2020 13:47:32]     CAUAJM_E_18607 Event Server: <NAUSP-WSQL0286\SQL16A,57700:AEDB_PRD_NEW>  Failed Stored Procedure: <{? = CALL ujo_afm_sendevent (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} <<'PRD000010a01',0,'PRD',0,'',12345,1601401651,0,'','','6728','test_prd',1,101,'NAUSP-WAPP0991',1,-1,'6728',10,0,4,1,'Executing at WA_AGENT',1,'WAAE_WF0',2,1,28679,0,8,'WA_AGENT NAUSP-WAPP0991',1>>>
[09/29/2020 13:47:37]     CAUAJM_I_80021 The agent inventory service has evaluated the statuses of 1 machine(s) in 0.109 seconds.
[09/29/2020 13:47:42]     CAUAJM_E_18802 Error from SQLExecute() Failed with SQL_ERROR.
[09/29/2020 13:47:42]     CAUAJM_E_18601 SQLSTATE: 42000, Native error: 229, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'ujo_afm_sendevent', database 'AEDB_PRD_NEW', schema 'dbo'.
[09/29/2020 13:47:42]     CAUAJM_E_18607 Event Server: <NAUSP-WSQL0286\SQL16A,57700:AEDB_PRD_NEW>  Failed Stored Procedure: <{? = CALL ujo_afm_sendevent (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} <<'PRD000010a01',0,'PRD',0,'',12345,1601401651,0,'','','6728','test_prd',1,101,'NAUSP-WAPP0991',1,-1,'6728',10,0,4,1,'Executing at WA_AGENT',1,'WAAE_WF0',2,1,28679,0,8,'WA_AGENT NAUSP-WAPP0991',1>>>
[09/29/2020 13:47:52]     CAUAJM_E_18802 Error from SQLExecute() Failed with SQL_ERROR.
[09/29/2020 13:47:52]     CAUAJM_E_18601 SQLSTATE: 42000, Native error: 229, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'ujo_afm_sendevent', database 'AEDB_PRD_NEW', schema 'dbo'.
[09/29/2020 13:47:52]     CAUAJM_E_18607 Event Server: <NAUSP-WSQL0286\SQL16A,57700:AEDB_PRD_NEW>  Failed Stored Procedure: <{? = CALL ujo_afm_sendevent (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} <<'PRD000010a01',0,'PRD',0,'',12345,1601401651,0,'','','6728','test_prd',1,101,'NAUSP-WAPP0991',1,-1,'6728',10,0,4,1,'Executing at WA_AGENT',1,'WAAE_WF0',2,1,28679,0,8,'WA_AGENT NAUSP-WAPP0991',1>>>
[09/29/2020 13:48:00]     ----------------------------------------
[09/29/2020 13:48:02]     CAUAJM_E_18802 Error from SQLExecute() Failed with SQL_ERROR.
[09/29/2020 13:48:02]     CAUAJM_E_18601 SQLSTATE: 42000, Native error: 229, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]The EXECUTE permission was denied on the object 'ujo_afm_sendevent', database 'AEDB_PRD_NEW', schema 'dbo'.
[09/29/2020 13:48:02]     CAUAJM_E_18607 Event Server: <NAUSP-WSQL0286\SQL16A,57700:AEDB_PRD_NEW>  Failed Stored Procedure: <{? = CALL ujo_afm_sendevent (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} <<'PRD000010a01',0,'PRD',0,'',12345,1601401651,0,'','','6728','test_prd',1,101,'NAUSP-WAPP0991',1,-1,'6728',10,0,4,1,'Executing at WA_AGENT',1,'WAAE_WF0',2,1,28679,0,8,'WA_AGENT NAUSP-WAPP0991',1>>>

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)

Resolution

The autosys user was denied execution stored procedure ujo_afm_sendevent.
Executing RefreshAEDB.pl resolved the issue.