Remove inconsistent statistic records created as a result of a server bug up to version 6.00A
Article ID: 89342
Updated On:
Products
CA Automic Workload Automation - Automation Engine
Issue/Introduction
Remove inconsistent statistic records created as a result of a server bug up to version 6.00A
Environment
Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:
Component:
Resolution
Detailed Description and Symptoms
Solution
Due to a server bug in old versions of Automic:Global statistic records have been created if a user tried to connect to a non existing client.
These records of course cannot be reorganized using the Automic utilities and will remain in the database until being removed manually.
These records of course cannot be reorganized using the Automic utilities and will remain in the database until being removed manually.
Solution
The attached files for the different database versions (MS-SQL-Server, Oracle and DB2) can be used to first check the current status (select statements).
If the situation is as expected, which menas only records of users in clients which do not exist are displayed, the delete statement can be used to remove these inconsistent statistic records.
If the situation is as expected, which menas only records of users in clients which do not exist are displayed, the delete statement can be used to remove these inconsistent statistic records.
Feedback
Yes
No
Powered by
