KBI 311683 Database Full Transaction Log Causes Argent Services To Stop Running
Version
Argent Advanced Technology – All versions
Date
Friday, 22 June 2018
Summary
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]
Resolution
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
https://help.argent.com/#kbi_310092
KBI 220220 Huge SQL Transaction Log When Running Argent
https://help.argent.com/#kbi_220220
KBI 310275 Slow SQL Server
https://help.argent.com/#KBI_310275
KBI 310215 Database Tuning for ODBC Timeouts and GUI Freezing