KBI 311683 Database Full Transaction Log Causes Argent Services To Stop Running


Argent Advanced Technology – All versions


Friday, 22 June 2018


Database maintenance is critical to maintaining stable Argent product functionality

A failed (or missed) SQL Server backup or scheduled job may cause the SQL Server Argent database Transaction Log to grow and if the Transaction Log is of a limited size there is a potential to reach the maximum size and then prevent the Argent products from performing SQL queries, essentially stopping monitoring

Internal alerts such as ‘Engine Offline’ may indicate the Transaction Log is full

Further investigation will be required or contact Argent Instant Help Live Chat if there is any doubt

Argent Instant Help Live Chat


Technical Background

The indication that the Transaction Log is full is found in the Argent Services Log

**** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp (D6320_Commit_DB_Operation) at line 10861: >>> Recordset SQL: SELECT…

***** 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 = The transaction log for database ‘ArgentAT’ is full

To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

State:37000,Native:9002,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]


To address the issue perform a SQL Server Argent database backup (or truncate transaction log)

Also confirm the SQL Server scheduled jobs are functioning correctly

Argent provides Housekeeping to maintain the Transaction Log if required and should be enabled as a secondary safety-catch to avoid monitoring outages

Argent recommends that the database property “Recovery Model” is “Simple”, allowing the Transaction Log to grow more slowly

For details see the following KBIs

KBI 310092 MSSQL Simple Vs. Full Recovery Model


KBI 220220 Huge SQL Transaction Log When Running Argent


KBI 310275 Slow SQL Server


KBI 310215 Database Tuning for ODBC Timeouts and GUI Freezing