KBI 310753 Issue Addressed: Argent Console Does Not Fire Alerts, Cannot Add New Definitions From Argent AT or Global Manager


Argent Advanced Technology all versions


Wednesday, 20 Nov 2013


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 to

                                              A1A console

The GUI will still start but no new entries (such as Rules, Alerts or Relators) can be created


Do the following to address the issue:

  1. Stop all Argent AT services
  2. Open SQL Management Studio and manually truncate transaction logs and shrink the database until sufficient DB space is available
  3. Also rebuild indexes for all tables in Argent AT database. It can be done in SQL Management Studio as well
  4. Restart Argent AT services