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

Document ID : KB000046229
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue: 

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

 

Environment:  

Autosys 11.3 SP1+

 

Cause: 

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 

 

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';