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

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


Article ID: 37681


Updated On:


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



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. 


Workload Automation AE 11.3.x, Oracle Database


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


1) Log in to Scheduler machine as root 
2) source /opt/CA/WorkloadAutomationAE/autouser.$AUTOSERV/ 
3) stop WAAE services 
4) cd $AUTOSYS/dbobj/ORA 
5) perl 
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


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