Version

Argent Console 3.1A-1401-A or below

Date

Wednesday, 29 Jan 2014

Summary

If some Argent Console event to purge or archive has a large data (>32KB) in column ‘LONG_DESCRIPTION‘, the Argent Console service won’t be able to purge or archive events due to ODBC error ‘Data Truncation‘ or ‘String Truncation‘

Technical Background

The issue is confirmed and addressed in Argent AT 3.1A-1401-B

Resolution

Upgrade to Argent AT 3.1A-1401-B or later

For customer who cannot upgrade immediately, he has to manually remove such event records from database

The following query can be useful to find out culprit event records:

select * from ARGSOFT_AAC_CONSOLE where datalength(LONG_DESCRIPTION) > 32768 order by RECORD_TIME