search cancel

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

book

Article ID: 200203

calendar_today

Updated On:

Products

iDash Workload Automation

Issue/Introduction

We crated a user called IDASH_USER and replaced it in the admin tool with AEDBADMIN. We granted insert, update, delete priviages 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


Environment

Release : 12.0

Component : CA WORKLOAD AUTOMATION iDASH FOR CA 7

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