Version

Argent Advanced Technology – All Versions with SQL Express Database as Backend

Date

Monday, 13 March 2017

Summary

Argent AT requires a database backend for normal operations

While this Argent KBI is focused towards SQL Express, the following can be equally applied well to SQL Server

SQL Express is free entry level database

The maximum size of the database is limited to 10 GB

Ensuring the database size below maximum size is a good practice

Argent does not recommend Microsoft SQL Express for production environment.

Technical Background

Customers who are saving data into Argent Predictor and using SQL Express as their database backend for Argent AT may find Events are no longer processed and subsequent Alerts are not fired If the database has reached the allowed 10 GB size limit

Argent Console Log displays the following entries when the database has reached its maximum permitted size:

13 Mar 2017 10:00:07.212 ARGENTSERVER\argent ***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp (D6320_Commit_DB_Operation) at line 10855:

DAL could not modify the record set. Microsoft Error Code = Could not allocate space for object

‘dbo.ARGSOFT_AAC_CONSOLE’.’PK_ARGSOFT_AAC_CONSOLE’ in database ‘Argent_AT’ because the ‘PRIMARY’ filegroup is full.

Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.

….

13 Mar 2017 10:00:07.214 ARGENTSERVER\argent AddAlertToConsole: Failed to update ODBC table ‘ARGSOFT_AAC_CONSOLE’

13 Mar 2017 10:00:07.216 ARGENTSERVER\argent Failed to add event (#011513) of rule SVC_ARGENT_CONSOLE of relator REL_ARGENT_HEARTBEAT on node TESTSERVER to A1A console

Resolution

Customers should be running House Keeping tasks on the Argent Database periodically to prevent the maximum permitted size limit being reached

Typically, Argent database tables can grow if Argent Predictor Data is being stored in the database

Argent AT has option to keep Argent Predictor Data for a set Day Limit before the Data is purged automatically from the database

Argent AT also has further built in House Keeping options which can be configured to ensure the database and logs do not overgrow

Please refer to the following KBI article on House Keeping

https://help.argent.com/#Q051