How to investigate the root cause of a Failing status on the Failover database status.
The reason shown is: object reference not set to an instance of an object.
Is there a log file with more info on what caused the error?
Hi Mieke,
I would start the investigation by looking at the following two logfiles on your DataMiner server: SLDBConnection and SLDataGateway.
Paths:
"C:\Skyline DataMiner\logging\SLDBConnection.txt"
"C:\Skyline DataMiner\logging\SLDataGateway.txt"
I believe you will find your first hints on what's going wrong in here.
Goodluck!
Hi Thijs and Wouter,
The problem was that the cassandra password was not correct.
When looking in the SLDBConnection I could find that prior to the vague exception there was one about the password. Most likely because the login failed, an other operation caused the exception.
– MySQL => see SLDatabase[SLNet].txt (a simple query is being executed to check the database)
– Cassandra => see SLDBConnection.txt
You can also try to send the GetCassandraHealthMessage and/or DatabaseHealthRequest through the SLNetClientTest tool and interpret the output. “Database Status” reports problems when the status isn’t GREEN or when the number of nodes is less than 2.