DBMaint.out error message. ORA-00942

Products

• CA Workload Automation AE - Scheduler (AutoSys)
• Autosys Workload Automation

Issue/Introduction

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

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Oracle 11g

AutoSys 11.3.x

Platform - ANY

Resolution

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;