On our Staging environment DMA, we can see that one of the Database connections isn't working correctly when viewing the failover status. The fail reason is shown as 'Object reference not set to an instance of an object.'
Looking in the SLDatabase[SLWatchDog].txt log file, I can see
2022-09-14 10:08:46.858|10|Exception on GetConnection: System.NullReferenceException: Object reference not set to an instance of an object.
at Skyline.DataMiner.SLDatabase.SLDatabaseCOM.Init(Boolean bLocal)
Does anyone have any suggestions?
Hi Ive,
There doesn’t appear to be a SLDBConnection.txt log file on that DMA. It’s (active) failover partner DMA does have the log file.
Could you verify if the SLDataGateway service is running?
It might also be a good idea to inspect the c:Skyline DataMinerdb.xml configuration file to verify that it is correctly formatted and has a tag which is marked as active=”true” local=”true”
@Jens Gellynck – The SLDataGateway service is not running. On closer inspection I can see that the service attempts to start, and then stops.
Windows Event Viewer reports:
“The description for Event ID 0 from source SLDataGateway cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
Service started/resumed”
Hi Dave,
i want to add to this question that we also now have a flowchart that helps you to debug these kind of issues:
There is also quite some information about troubleshooting database issues:
These flowcharts have now been moved to docs.dataminer.services: https://docs.dataminer.services/user-guide/Troubleshooting/Troubleshooting_Flowcharts/Finding_a_Root_Cause.html
Hi Dave,
Do you see any errors in the SLDBConnection.txt log file on the agent that shows the null reference exception?