KBI 220740 Cannot Purge Argent Data Consolidator Events

Version

Argent Console 8.0A-0707-C

Date

6 September 2007

Summary

Argent Data Consolidator events cannot be purged.

Technical Background

The Argent Console prevents the Argent Data Consolidator Events from being purged either manually or automatically after x number of days.

When attempting to purge these events, it may appear that the purging process is in progress. However on rechecking the Events List, the events are still listed.

Resolution

To resolve this issue, upgrade the Argent Extended Technology to version 8.0A-0707-D or later. Please note, a simple upgrade may not resolve the issue and further steps are required.

During an upgrade, the database integrity check AAC_DBCeck.exe will produce the following error:

You can continue the installation and the upgrade will complete successfully. However, the issue will still exist until a manual change in the Argent database is made.

  1. Stop All Argent Services.
  2. Access the Argent SQL database using the SQL Server 2000 Enterprise Manager or Microsoft SQL Server Management Studio.
  3. Locate the AAC_ConsoleArchive table.
  4. Right Click on AAC_ConsoleArchive and select Design Table

    This will open the table properties as shown below:

  5. Modify the Length value from 16 to 32 for the ruletype field.
  6. Start All Argent Services and purge the Argent Data Consolidator events.