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

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

 

Issue:

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.