DBMaint.out error message. ORA-00942

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

Issue:

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:  

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;