Version

Argent Advanced Technology 3.1A-1507-A and earlier

Date

Tuesday, 18 August 2015

Summary

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:

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’

Resolution

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

SOFTWARE\ARGENT\ARGENT_CONSOLE\ODBC_TXTBUF_IN_KB

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

SOFTWARE\ARGENT\COMMON\ODBC_TXTBUF_IN_KB