Unable to load the SLA's after changing the DB account

Products

• iDash Workload Automation

Issue/Introduction

We created a user called IDASH_USER and replaced it in the admin tool with AEDBADMIN. We granted insert, update, delete privileges on ujo_alarm table and for rest all tables we provided read-only access.

After that,  iDash fails to load SLA's and throws the below error:

20-09-07 16.15.47 [ INFO] D10: FACondition query : SELECT cond_mode, j.joid, indx, indx_ptr, type, cond_job_name, cond_job_autoserv, operator, test_glovalue, value, c.job_ver, lookback_secs FROM AEDBADMIN.ujo_job_cond c, AEDBADMIN.ujo_job j WHERE c.joid = j.joid AND c.job_ver = j.job_ver AND cond_mode = 3 AND c.over_num = -1 AND is_active = 1 AND is_currver = 1 ORDER BY c.joid, c.job_ver, indx

20-09-07 16.15.48 [ERROR] D10: java.sql.SQLSyntaxErrorException:ORA-00942: table or view does not exist

com.ca.idash.core.exception.IdashException: java.sql.SQLSyntaxErrorException:ORA-00942: table or view does not exist

Resolution

The DBA needs to follow the steps below:

1.  Drop IDASH_USER
2.  Create IDASH_USER with profile AUT_APP_NONPER_NONEXP_PROFILE
3.  CREATE USER IDASH_USER  PROFILE AUT_APP_NONPER_NONEXP_PROFILE IDENTIFIED BY  Password   ACCOUNT UNLOCK;

4.  Grant CREATE_SESSION permissions
5.  Make sure that SESSIONS_PER_USER is set to unlimited
 

For Autosys team:

Log in as AEDBADMIN
Run the below 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;

commit;

iDashTeam:

1. Log in to admin tool using idashAdm
2. Change the Primary user and Password for each Autosys instance.
3. Save and test
4. Bounce Idash server – Both Primary and secondary