KBI 311134 Argent for Topology Webpage Shows Empty Graphs


Argent for Topology 1406-A or Earlier


Friday, 19 Dec 2014


After new installation of Argent for Topology, Collector Logs showing NetFlow/SFlow Data is coming consistently but Argent for Topology Webpage Graphs are empty

Error in Argent Topology Web logs


17 Dec 2014 17:03:14.803 ACME\User *** ERROR *** Failed to execute SQL query

17 Dec 2014 17:03:14.818 ACME\User *** ERROR *** [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

17 Sep 2013 17:03:14.818 ACME\User *** ERROR *** Microsoft Error Code -2147217913

17 Dec 2014 17:03:14.818 ACME\User *** ERROR *** SQL Query…………….

Technical Background

Date format of SQL query is not same as data stored inside the table

Argent service account has user login in SQL Server

The default language of the service account should be ‘English’ (this means US English)

Please note: ‘British English’ is not same as ‘English’ in SQL Logins


Set Default Language to English in Logins

  1. Open SQL Management Studio
  2. Logon with SQL Admin account
  3. Click Security > Logins > Right Click > Properties > Default Language
  4. Set to English > Click OK