Our development environment has been updated to PeopleTools 8.59, and problems are being encountered. An AutoSys job has been failing consistently, indicating this error: "Error: E139011 Agent error response: [Could not get value for Jobid]" when I attempt to look at the log or trace files in the AutoSys WCC.
The autorep command returns this:
psstg_sec_purge_deleted_accounts 04/18/2022 07:00:01 04/18/2022 07:00:01 FA 3986908/1 106
Status/[Event] Time Ntry ES ProcessTime Machine
-------------- --------------------- -- -- --------------------- ----------------------------------------
STARTING 04/18/2022 07:00:00 1 PD 04/18/2022 07:00:00 autosys-prd.acsu.buffalo.edu_PSSTG
RUNNING 04/18/2022 07:00:01 1 PD 04/18/2022 07:00:01 autosys-prd.acsu.buffalo.edu_PSSTG
FAILURE 04/18/2022 07:00:01 1 PD 04/18/2022 07:00:01
<ORA-00942: table or view does not exist >
[STARTJOB] 04/25/2022 07:00:00 0 UP
<Event was scheduled based on job definition.>
Is there anyway to find out what table or view is not existing?
Prior to the upgrade, the job has had a successfully run history.
Can anyone tell me more about this error, and/or how to troubleshoot this issue? Has this job been dropped from a table? Another job has been running successfully during this time.
Thanks!