Deleted machines still appear in "autorep -M ALL" output.

Products

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

Issue/Introduction

We have recently deleted some machine definitions from Workload Automation AE, yet they still appear in the results from "autorep -M ALL"

Environment

Workload Automation AE 11.x

Databases - Oracle, Sybase, MS SQL

Platform - Windows, UNIX, Linux

Resolution

Depending on the options given to autorep information is pulled from different tables within the AE database.

autorep -M ALL -q for example will pull data from the ujo_machine table as it stores the actual machine definitions.

autorep -M ALL can pull from ujo_machine as well as ujo_jobst, ujo_job, ujo_proc_event  

DBMaint is part of Workload Automation AE's default operations.  It archives data from the AE database into text files and deletes them from the database tables.  If the machine is referenced in ujo_proc_event or ujo_job_runs, eventually the machine would stop appearing in the autorep listing as the data is archived.  If the machine is coming from a job's definition or the current / last status of a run, then the job would need to be deleted via jil and reinserted using a different, valid machine name for the older machine to stop appearing in the autorep results.