search cancel

Remove inconsistent statistic records created as a result of a server bug up to version 6.00A

book

Article ID: 89342

calendar_today

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:

Resolution

Detailed Description and Symptoms
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.

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.