KBI 311272 Issue Addressed: Argent Console Old Events Are Only Partially Archived


Argent Advanced Technology 3.1A-1507-A and earlier


Tuesday, 18 August 2015


Argent Console Events can be configured to be archived daily

However, customer might find not all old Events are archived

By inspecting Argent Console service log, following lines can be found:

***** ERROR ***** An error condition has been detected by ArgSoft_DAL.cpp (D6240_Move_Next) at line

7266: DAL could not modify the record set. Microsoft Error Code = Data truncated.

This is caused by some Event records having very long text content in column ‘MEMO’ or ‘ALERT_MEMO’ exceeding the default 32 KB

The issue has been corrected in Argent AT 1507-T2

Technical Background

Argent AT uses ODBC to access SQL backend

Unless explicitly specified in the code, Argent AT Engine pre-allocates 32 KB buffer by default to access columns with type ‘text’ or ‘ntext’

When some Argent Console Events (stored in SQL table ‘ARGSOFT_AAC_CONSOLE’) have very long content in column MEMO or ALERT_MEMO, ODBC data truncation error can happen causing the archiving process to terminate

As a result, the Event archiving is only partially done

Argent AT 3.1A-1507-T2 has been corrected to handle these two columns up to 1 MB to be the same as the column ‘LONG_DESCRIPTION’


Upgrade to Argent AT 3.1A-1507-T2 or later

For customer who cannot upgrade immediately, he can adjust registry ‘ODBC_TXTBUF_IN_KB’ to 128 or 256 to address the issue

For Argent AT 3.1A-1410-A, the registry is


For Argent AT 3.1A-1501-A and later, the registry is