KBI 311134 Argent for Topology Webpage Shows Empty Graphs
Version
Argent for Topology 1406-A or Earlier
Date
Friday, 19 Dec 2014
Summary
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
(<PATH >\ARGENTFORTOPOLOGYDATACOLLECTOR\ARGENT_FOR_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
Resolution
Set Default Language to English in Logins
- Open SQL Management Studio
- Logon with SQL Admin account
- Click Security > Logins > Right Click > Properties > Default Language
- Set to English > Click OK