CAUAJM_E_18402 ORA-00942: table or view does not exist during dbstatistics

Products

• Autosys Workload Automation

Issue/Introduction

DBMaint.log contains errors below:

CAUAJM_I_60019 dbstatistics: Running dbstatistics at: Tue Dec 16 03:35:12 2025

CAUAJM_I_60020 dbspace:  Running dbspace at : Tue Dec 16 03:35:34 2025

CAUAJM_E_18416 Event Server: <ORACLE>  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_afm'>
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 <919>
CAUAJM_E_18416 Event Server: <ORACLE>  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_afm_strings'>

Cause

Database user autosys missing grants on dba_tablespaces

Resolution

DBA to login to the database using sysdba privileged again and grant below privileges:

-- sqlplus SYS/password@Instance as sysdba

GRANT ANALYZE ANY TO ujoadmin;

GRANT SELECT ON DBA_TABLESPACES TO ujoadmin;

GRANT ujoadmin TO aedbadmin;

GRANT ujoadmin TO autosys;