DBMaint errors - CAUAJM_E_18402 ORA-00942: table or view does not exist, all_tables, dba_tablespaces

Products

• Autosys Workload Automation

Issue/Introduction

We have a new installation of Autosys on new servers and it seems DBMaint is having issues with tables not found. 

-- excerpt from $AUTOUSER/out/DBMaint.out --

CAUAJM_E_18402 ORA-00942: table or view does not exist
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <903>
CAUAJM_E_18416 Event Server: <UNCAE>  Failed Query: <SELECT (a.blocks * d.block_size) / 1000.0 FROM all_tables a JOIN dba_tablespaces d ON a.tablespace_
name = d.tablespace_name WHERE lower(a.table_name) = 'ujo_zos_condcodes'>
CAUAJM_E_18402 ORA-00942: table or view does not exist
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <903>
CAUAJM_E_18416 Event Server: <UNCAE>  Failed Query: <SELECT (a.blocks * d.block_size) / 1000.0 FROM all_tables a JOIN dba_tablespaces d ON a.tablespace_
name = d.tablespace_name WHERE lower(a.table_name) = 'ujo_zos_dsn_trigger'>
CAUAJM_E_18402 ORA-00942: table or view does not exist
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <903>
CAUAJM_E_18416 Event Server: <UNCAE>  Failed Query: <SELECT (a.blocks * d.block_size) / 1000.0 FROM all_tables a JOIN dba_tablespaces d ON a.tablespace_
name = d.tablespace_name WHERE lower(a.table_name) = 'ujo_zos_job'>
CAUAJM_E_18402 ORA-00942: table or view does not exist
CAUAJM_I_18403 Processing OCI function not used(4)
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE.
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <903>
CAUAJM_I_60031 The AutoSys tables have used 0.0 MB disk space.

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Resolution

Run the following as sys in the ae database(s):

GRANT ANALYZE ANY TO ujoadmin;
GRANT SELECT ON DBA_TABLESPACES TO ujoadmin;
GRANT ujoadmin TO aedbadmin;
GRANT ujoadmin TO autosys;