KBI 310753 Issue Addressed: Argent Console Does Not Fire Alerts, Cannot Add New Definitions From Argent AT or Global Manager
Version
Argent Advanced Technology all versions
Date
Wednesday, 20 Nov 2013
Summary
SQL indexes are corrupted due to running out of database disk space
The primary key constraint error won’t go away after the SQL table is truncated
To correct this Microsoft bug, the SQL indexes need to be rebuilt
Technical Background
Customer typically discovers the SQL issue when Argent Console fires no alert for a period of time
Lines in the Argent Console log similar to following will be present:
18 Nov 2013 00:13:20.451 HESTIA RBF\argentsvc ***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp (D6320_Commit_DB_Operation) at line 5133:
DAL could not modify the record set. Microsoft Error Code = Violation of PRIMARY KEY constraint
'PK_ARGSOFT_AAC_CONSOLE'. Cannot insert duplicate key in object 'dbo.ARGSOFT_AAC_CONSOLE'.
The statement has been terminated.
. State:23000,Native:2627,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:01000,Native:3621,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
18 Nov 2013 00:13:20.453 HESTIA RBF\argentsvc Failed to add event (#006542)of rule HST_HDW_BAD_NIC of relator REL_RBF_ESX_HOST_HARDWARE on node 107.100.100.111 to
A1A console
The GUI will still start but no new entries (such as Rules, Alerts or Relators) can be created
Resolution
Do the following to address the issue:
- Stop all Argent AT services
- Open SQL Management Studio and manually truncate transaction logs and shrink the database until sufficient DB space is available
- Also rebuild indexes for all tables in Argent AT database. It can be done in SQL Management Studio as well
- Restart Argent AT services