KBI 310910 Argent Predictor Stopped To Be Saved Resulting Blank Reports And Charts


Argent Advanced Technology all versions


Wednesday, 9 Apr 2014


Large Argent AT installation can generate huge volume of Argent Predictor data

It can be several thousand data points every few seconds

Customer can notice spotty data at the beginning

It can deteriorate until no data is saved

If Argent AT 3.1A-1404 or later is used, customer can see ‘ODBC error: SQL insert failed‘ in the service log

Technical Background

The issue is caused by stressed SQL Server

SQL update statement fails randomly due to the load


The solution is to turn on SQL Bulk Insert

See KBI 310359 Enabling SQL Bulk Insert In Argent Guardian Ultra And Argent For Compliance for How-To