I am building 1+1 Dataminer system and have connected Cassandra hosted on a Linux server within the network. Dataminer can connect to this dbserver but only shows that it is synchronised to the offline dma agent and unsynchronised to the online agent.
Hello Arunkrishna,
This is the result of the nodetool status :
C:Program FilesCassandrabin>nodetool status
The JAVA_HOME environment variable must be set to run this program!
Press any key to continue . . .
C:Program FilesCassandrabin>
—————-
This is also a snippet of the SLDBConnection.txt file :
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Requests.RequestExecution.d__13.MoveNext() Cassandra.InvalidQueryException: Keyspace ‘SLDMADB’ does not exist
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Connection.d__88.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Connection.d__88.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Cassandra.Requests.RequestHandler.d__41.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Cassandra.Requests.RequestExecution.d__13.MoveNext()
— End of inner exception stack trace —
at SLCassandraClassLibrary.DBGateway.ExceptionHandlers.ExceptionHandler.handle(DBGatewayException exception)
at SLCassandraClassLibrary.DBGateway.Cassandra.StorageManagers.SingleNode.CassandraConnection.c__DisplayClass204_0.b__0(Task`1 c)
**********
Hi,
You need to set the JAVA_HOME environment variable; you can follow this guide : https://confluence.atlassian.com/doc/setting-the-java_home-variable-in-windows-8895.html --> this will help run nodetool status command.
From the log, I see the keyspace SLDMADB is not created. I would suggest to contact our support team for further assistance.
the SLDMADB is not created because the nodetool status was invoked locally on the DMA server when the Cassandra DB is running on a single external Linux node. So, all expected here 😉
Hi Curtis, what do you see when you type nodetool status on the online agent via cmd in the path C:Program FilesCassandrabin ?
Also, you can open the file “C:Skyline DataMinerLoggingSLDBConnection.txt” on the online agent and see if it has any errors.