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

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() 

 

 

 

 

Cause

Incorrect system regional settings.

Resolution

Follow the steps below:

Enter the Windows regional settings menu through Control Panel on the server itself.
 
Modify this setting to "English (United States)".
 
Click OK.
 
Now, enter the Windows Registry, and highlight My Computer.
 
Go to Edit > Find, and search for the following registry keys and update them to the following values:

sLongDate = dddd, MMMM dd, yyyy

sShortDate = M/d/yyyy

sLanguage: ENU

Locale: 00000409

LocaleName: en-US

sCountry: United States

sDecimal: .

 

Use the F3 key to continue searching the registry for more instances of these keys.
 
Then search for the following
Keep doing so until it states it has finished searching the registry.
 
The regional settings change in the control panel doesn't always update every registry entry and that can still affect the database if all entries are not updated manually in the registry. This is a windows issue, so the full search through the registry is necessary.
 
After all changes are made, Restart the Server to apply the registry changes.

Additional Information

Regional Settings KB:

What are the Regional Settings Required for NFA, ADA, and UCM