DBMAINT CAUAJM_E_60015 Failed

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

Description:

DBMAINT generate the following error:
CAUAJM_E_60015 Failed to retrieve space usage of ujo_afm. Verify the ujoadmin
account has select privileges on ALL_TABLES.
dbstatistics: Unable to run dbspace
...

Solution:

This is a privileges issue, the following queries should solve the problem

 	sqlplus sys/<passwd>@<ORACLE_SID> as sysdba
 	grant ANALYZE ANY to UJOADMIN;
 	grant SELECT ON DBA_TABLES to UJOADMIN;
 	GRANT ujoadmin TO aedbadmin;

Ensure ujoadmin account has select privileges on ALL_TABLES.

Environment

Release:
Component: ATSYS