Autosys installation/Upgrade Failed

Products

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

Issue/Introduction

Autosys R11.3 x installation/Upgrade failed with ORA-00942. You would see below error in “install_aedb.log”.

 

SELECT COUNT(*) FROM dba_tables WHERE table_name = UPPER('UJO_ALAMODE') AND owner = UPPER('aedbadmin')
*
ERROR at line 1:
ORA-00942: table or view does not exist

 

Environment

ALL Supported Versions WAAE and DB's.

Cause

You would get this error if AEDBADMIN doesn’t have the 'SELECT_CATALOG_ROLE' role granted.

 

Resolution

Hence, the following should fix:

GRANT 'SELECT_CATALOG_ROLE' TO AEDBADMIN;

By the way, the following privileges are granted to AEDBADMIN user by default

GRANT CREATE VIEW TO AEDBADMIN
GRANT 'CONNECT' TO AEDBADMIN
GRANT 'EXECUTE_CATALOG_ROLE' TO AEDBADMIN
GRANT 'RESOURCE' TO AEDBADMIN
GRANT 'SELECT_CATALOG_ROLE' TO AEDBADMIN
GRANT CREATE PUBLIC SYNONYM TO AEDBADMIN

Additional Information

If this does not resolve the issue, please raise a case to support.