autorep -J <job name> -q returns ORA-00942

Products

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

Issue/Introduction

Issue: 

autorep –J <job name> -q presents following error(s):

/*CAUAJM_E_18416 Event Server: <AEDB> Failed Query: <SELECT j.box_name, j.has_blob, j.has_box_failure, j.has_box_success, j.has_condition, j.has_notification, j.has_override, j.has_service_desk, j.as_applic, j.as_group, j.is_active, j.is_currver, j.job_name, j.job_type, j.job_ver, j.joid, j.machine, j.over_num, j.wf_joid from ujo_jobrowl j LEFT OUTER JOIN ujo_job z ON (z.joid=j.box_joid AND z.is_active=1 AND z.is_currver=1) AND (z.joid>0) AND (z.job_name LIKE 'test!_install' ESCAPE '!') WHERE (j.job_name like 'test!_install' escape '!' AND j.is_active=1 AND j.is_currver=1) AND (z.joid IS NULL) ORDER BY j.joid ASC NULLS FIRST > 
CAUAJM_E_18402 ORA-00942: table or view does not exist 
CAUAJM_I_18403 Processing OCI function not used(4) 
CAUAJM_E_18400 An error has occurred while interfacing with ORACLE. 
CAUAJM_E_18401 Function <doExecute> invoked from <execute> failed <864> 
CAUAJM_E_10320 Failed to retrieve jobs from database. 
*/      

Environment:  

Workload Automation AE 11.3.x, Oracle Database

Cause: 

Upgrade of system from prior version failed to properly upgrade database.

Resolution

1) Log in to Scheduler machine as root 
2) source /opt/CA/WorkloadAutomationAE/autouser.$AUTOSERV/autosys.sh.hostname 
3) stop WAAE services 
4) cd $AUTOSYS/dbobj/ORA 
5) perl RefreshAEDB.pl 
6) follow prompts, entering requested information 
7) start WAAE services 
8) To verify run autoflags -a and "select STR_VAL from AEDBADMIN.UJO_ALAMODE where TYPE = 'AEDB_VERSION';" to make sure the results match

Environment

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