When I execute autosys_secure, I do not have access to EDIT/EXEC superuser options.

book

Article ID: 3984

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA Workload Automation Agent

Issue/Introduction

After getting some errors to create super users in Autosys, now when I try to relaunch autosys_secure I can no longer access the Edit and Exec super user options. 

Cause

Due to some database errors, tables mdbadmin.ujo_keymaster and mdbadmin.ujo_alamode  might be corrupt

Environment

Autosys 11.0 on Unix/Linux

Resolution

The solution is to update the DB using the following queries:

  1. Truncate table mdbadmin.ujo_keymaster;
  2. Update mdbadmin.ujo_alamode set int_val=0 where type = 'JOB';
  3. Update mdbadmin.ujo_alamode set int_val=0 where type = 'EVT';
  4. Delete from mdbadmin.ujo_alamode where type = 'SEC'; commit;