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.
- Stop All Argent Services.
- Access the Argent SQL database using the SQL Server 2000 Enterprise Manager or Microsoft SQL Server Management Studio.
- Locate the AAC_ConsoleArchive table.
- Right Click on AAC_ConsoleArchive and select Design Table
This will open the table properties as shown below:
- Modify the Length value from 16 to 32 for the ruletype field.
- Start All Argent Services and purge the Argent Data Consolidator events.