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

Document ID : KB000089342
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Remove inconsistent statistic records created as a result of a server bug up to version 6.00A
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.