Autosys installation/Upgrade Failed

book

Article ID: 8690

calendar_today

Updated On:

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

 

Cause

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

 

Environment

ALL Supported Versions WAAE and DB's.

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.