DBMaint.out shows the following error for the compliance application
ORA-00942 for select count(*) machine_count from ujo_machine where type not in ('p', 'v', 'w') and parent_name = ' '
Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:
Oracle 11g
AutoSys 11.3.x
Platform - ANY
The ORA-00942 error messages can happen if one or more of the public synonyms are missing.
Run the following in the AE database to correctly create them, which will resolve the error.
create or replace public synonym ALAMODE for AEDBADMIN.ALAMODE;
create or replace public synonym EVENT for AEDBADMIN.EVENT;
create or replace public synonym INTCODES for AEDBADMIN.INTCODES;
create or replace public synonym PROC_EVENT for AEDBADMIN.PROC_EVENT;
create or replace public synonym SEND_EVENT for AEDBADMIN.SEND_EVENT;
create or replace public synonym TIMEZONES for AEDBADMIN.TIMEZONES;
grant select on dba_tablespaces to UJOADMIN;