Unable to execute jobs

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.