DBMAINT CAUAJM_E_60015 Failed

book

Article ID: 19753

calendar_today

Updated On:

Products

CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) CA 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