Hi,
A DataMiner running 9.6 CU9 has a MySQL Central Database configured and is currently showing the error \"Central database not reachable\". The database has been migrated to a new machine using the MySQL Workbench Migration Wizard.
The credentials were double-checked and it is possible to query the DB via MySQL Workbench:
The same can be done from within Cube:
Checking the SLDBConnection.txt log shows the following:
I was able to find the same issue reported in task 125205. In this task, the issue was tracked to the character encoding, and changing it from latin1 to UTF-8 corrected the issue.
In my case, checking the encoding shows UTF-8:
Restarting the DataMiner Agent does not clear the error.
What further checks can be performed to find the root cause of the error?
What known root causes for this error could be at play here?
Thank you for your help.
Hi João,
Can you double check in the central database if the option sql_mode is set to '':
Once you are connected to the central database through MySQL Workbench, you can find this setting going in the Options File:
Made the worng edit. I should have used double prime symbols (”) instead of the quoatation marks (“).
In the MySQL Workbench (and here as well) they look similar, but in a text editor they are quite different.
Opening the my.ini file (configuration settings file), it is clear to see it under:
# Set the SQL mode to strict
sql-mode = ”
Edited the sql-mode from: “STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
To: ”
However I am still getting:
2020/08/17 15:17:36.687|SLDBConnection|SLDBConnection|DBG|5|67|Failed forwarding data for ‘dataavg’ table: MySql.Data.MySqlClient.MySqlException (0x80004005): Incorrect integer value: ” for column ‘iId’ at row 1
at SLCassandraClassLibrary.DBGateway.CentralDatabaseManager.ForwardData(SLSql centralConnection, String data)
at SLCassandraClassLibrary.DBGateway.CentralDatabaseManager.ForwardData(SLSql centralConnection)