iDash Alerts for Missed SLA's are not coming in event demon logs for Production Instances

Products

• CA Workload Automation AE - System Agent (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation
• iDash Workload Automation

Issue/Introduction

iDash Alerts for Missed SLA's are not appearing in AutoSys event demon logs. The following error is seen in the iDash server logs:

[ERROR] idash-SLA-processing:com.ca.idash.core.sla.AESLA: AstridUSAEFGBatch^P11-20201126-1100
com.ca.idash.core.exception.IdashException: java.sql.SQLException:ORA-06550: line 25, column 7:
PLS-00201: identifier 'AEDBADMIN.UJO_SENDEVENT' must be declared
ORA-06550: line 25, column 1:
PL/SQL: Statement ignored

Environment

Release : 11.3.6

Component : CA Workload Automation AE (AutoSys)
Component: iDash

Cause

The database user that has been configured in the iDash AdminTool to connect to the AutoSys DB does not have the necessary permissions/grants.

Resolution

The specific error reported can be resolved by granting 'execute' permission on the 'ujo_sendevent' function to the DB user:

grant execute on aedbadmin.ujo_sendevent to IDASH_USER;

Where IDASH_USER is a database user who can connect to the AutoSys DB. In addition to the above, the user must have all of the following grants:

grant select on aedbadmin.ujo_alamode to IDASH_USER; 
grant select,insert on aedbadmin.ujo_alarm to IDASH_USER; 
grant select on aedbadmin.ujo_audit_info to IDASH_USER; 
grant select on aedbadmin.ujo_audit_msg to IDASH_USER; 
grant select on aedbadmin.ujo_avg_job_runs to IDASH_USER; 
grant select on aedbadmin.ujo_calendar to IDASH_USER; 
grant select on aedbadmin.ujo_command_job to IDASH_USER; 
grant select on aedbadmin.ujo_file_watch_job to IDASH_USER; 
grant select on aedbadmin.ujo_glob to IDASH_USER; 
grant select,insert on aedbadmin.ujo_intcodes to IDASH_USER; 
grant select on aedbadmin.ujo_job to IDASH_USER; 
grant select on aedbadmin.ujo_job_cond to IDASH_USER; 
grant select on aedbadmin.ujo_job_runs to IDASH_USER; 
grant select on aedbadmin.ujo_job_status to IDASH_USER; 
grant select on aedbadmin.ujo_jobrow to IDASH_USER; 
grant select on aedbadmin.ujo_last_eoid_counter to IDASH_USER; 
grant select on aedbadmin.ujo_proc_event to IDASH_USER; 
grant select on aedbadmin.ujo_sched_info to IDASH_USER; 
grant select on aedbadmin.ujo_timezones to IDASH_USER;