After I installed NFA, the watchdog log shows "System.Data.Odbc.OdbcException: ERROR".

book

Article ID: 38061

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Issue: 

After I installed NFA, the watchdog log shows the following error: 

12:51:35 2 - Reporter Status - Validate error checking :
System.Data.Odbc.OdbcException: ERROR [42000] [MySQL][ODBC 5.1 Driver][mysqld-5.6.22-enterprise-commercial-advanced]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '8345184326172, ODBCConnectStatus = 'Successful', ODBCTables = 298, ODBCRepairs =' at line 1
at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader, Object[] methodArguments, SQL_API odbcApiMethod)
at System.Data.Odbc.OdbcCommand.ExecuteReaderObject(CommandBehavior behavior, String method, Boolean needReader)
at System.Data.Odbc.OdbcCommand.ExecuteNonQuery()
at WatchdogMain.ReporterStatus.Validate() 

Environment: 

Microsoft Windows Server 2012 R2 Standard Edition

Cause:

Incorrect system regional settings.

Resolution:

Please perform the following on the NFA servers:

1) Change the Windows regional settings to "English US"
2) Make sure all registry values sShortDate, sLongDate and sdecimal are correct:

a) Enter the Windows Registry, and highlight My Computer.
Go to Edit > Find, and search for string 'yyyy'.
Change only keys sLongDate and sShortDate to the following values:

sLongDate = dddd, MMMM dd, yyyy
sShortDate = M/d/yyyy

b) Search the registry for "sdecimal" entries and change them all to "." 

 

Additional Information:  

https://docops.ca.com/display/NFA933/Known+Issues#KnownIssues-DecimalValueforRegionalSetting

 

Environment

Release: RAIB1H99000-9.3-Network Flow Analysis-Interface Bundle-Hardware
Component: