Possible Solution for a DBMAINT Specific Error when a SQL Query Fails

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

DBMaint is not running properly due to a failing DB query.

 

CAUAJM_I_60019 dbstatistics: Running dbstatistics at: Fri Aug 26 16:25:37 2016 

CAUAJM_I_60020 dbspace: Running dbspace at : Fri Aug 26 16:25:45 2016 

CAUAJM_E_18416 Event Server: <aedbd> Failed Query: <SELECT a.blocks, d.block_size 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 <862> 

We have customized tablespaces such AEDBADMIN_DATA and AEDBADMIN_IDX 

 

 

Environment

Workload Automation AE

Resolution

Follow the steps below resolve this issue:

'ujoadmin' is a role in the AEDB and needs to have the following permissions granted (if they do not exist):

GRANT ANALYZE ANY TO ujoadmin;

GRANT SELECT ON DBA_TABLESPACES TO ujoadmin;

 

Also, 'aedbadmin' needs the following permissions granted (if they do not exist):

GRANT ujoadmin TO aedbadmin;

 

Run the following SELECT statement against the AEDB :

SELECT a.blocks, d.block_size FROM all_tables a

JOIN dba_tablespaces d ON a.tablespace_name=d.tablespace_name

WHERE lower(a.table_name)='ujo_afm';