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

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• 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. 

Environment

Autosys 11.0 on Unix/Linux

Cause

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

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;