Skip to content
DataMiner DoJo

More results...

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
Search in posts
Search in pages
Search in posts
Search in pages
Log in
Menu
  • Blog
  • Questions
  • Learning
    • E-learning Courses
    • Open Classroom Training
    • Certification
      • DataMiner Fundamentals
      • DataMiner Configurator
      • DataMiner Automation
      • Scripts & Connectors Developer: HTTP Basics
      • Scripts & Connectors Developer: SNMP Basics
      • Visual Overview – Level 1
      • Verify a certificate
    • Tutorials
    • Video Library
    • Books We Like
    • >> Go to DataMiner Docs
  • Expert Center
    • Solutions & Use Cases
      • Solutions
      • Use Case Library
    • Markets & Industries
      • Media production
      • Government & defense
      • Content distribution
      • Service providers
      • Partners
      • OSS/BSS
    • DataMiner Insights
      • Security
      • Integration Studio
      • System Architecture
      • DataMiner Releases & Updates
      • DataMiner Apps
    • Agile
      • Agile Webspace
      • Everything Agile
        • The Agile Manifesto
        • Best Practices
        • Retro Recipes
      • Methodologies
        • The Scrum Framework
        • Kanban
        • Extreme Programming
      • Roles
        • The Product Owner
        • The Agile Coach
        • The Quality & UX Coach (QX)
    • DataMiner DevOps Professional Program
  • Downloads
  • More
    • Feature Suggestions
    • Climb the leaderboard!
    • Swag Shop
    • Contact
      • General Inquiries
      • DataMiner DevOps Support
      • Commercial Requests
    • Global Feedback Survey
  • PARTNERS
    • All Partners
    • Technology Partners
    • Strategic Partner Program
    • Deal Registration
  • >> Go to dataminer.services

DB Sync failing on Active agent in failover pair.

Solved1.31K views5th July 2023db sync external cassandra node
0
Curtis Baiden [DevOps Advocate]494 10th May 2023 2 Comments

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.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 5th July 2023
Arunkrishna Shreeder [SLC] [DevOps Advocate] commented 11th May 2023

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.

Curtis Baiden [DevOps Advocate] commented 11th May 2023

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

3 Answers

  • Active
  • Voted
  • Newest
  • Oldest
1
Paulo Henriques [SLC] [DevOps Member]550 Posted 12th May 2023 1 Comment

Hi Curtis,

That error is a false positive and can be safely ignored. As Danielle mentioned, this results from the fact you have just 1 node in the Cassandra cluster whilst Dataminer is expecting at least 2 nodes when you have a FO configuration.

Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 5th July 2023
Curtis Baiden [DevOps Advocate] commented 12th May 2023

Thank you Paulo

1
Danielle Falcone [SLC] [DevOps Advocate]1.41K Posted 12th May 2023 1 Comment

Hi,

normally cassandra cluster will have more than 1 node, so a synchronization will happen.

On test environments, you can have only one node, but on this way you will always have this sync error because there is nothing to be syncronized

Curtis Baiden [DevOps Advocate] Posted new comment 12th May 2023
Curtis Baiden [DevOps Advocate] commented 12th May 2023

Thank you for your help and clarification

0
Arunkrishna Shreeder [SLC] [DevOps Advocate]4.00K Posted 11th May 2023 1 Comment

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.

Paulo Henriques [SLC] [DevOps Member] Posted new comment 12th May 2023
Paulo Henriques [SLC] [DevOps Member] commented 12th May 2023

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 😉

Please login to be able to comment or post an answer.

My DevOps rank

DevOps Members get more insights on their profile page.

My user earnings

0 Dojo credits

Spend your credits in our swag shop.

0 Reputation points

Boost your reputation, climb the leaderboard.

Promo banner DataMiner DevOps Professiona Program
DataMiner Integration Studio (DIS)
Empower Katas

Recent questions

Web Applications exception in Cube due to invalid certificate 0 Answers | 0 Votes
Redundancy Groups and Alarming – Duplicate Alarms 0 Answers | 0 Votes
Correlation Engine: “Test rule” doesn’t result in a hit, despite functional rule 1 Answer | 3 Votes

Question Tags

adl2099 (115) alarm (62) Alarm Console (82) alarms (100) alarm template (83) Automation (223) automation scipt (111) Automation script (167) backup (71) Cassandra (180) Connector (109) Correlation (69) Correlation rule (52) Cube (151) Dashboard (194) Dashboards (188) database (83) DataMiner Cube (57) DIS (81) DMS (71) DOM (140) driver (65) DVE (56) Elastic (83) Elasticsearch (115) elements (80) Failover (104) GQI (159) HTTP (76) IDP (74) LCA (152) low code app (166) low code apps (93) lowcodeapps (75) MySQL (53) protocol (203) QAction (83) security (88) SNMP (86) SRM (337) table (54) trending (87) upgrade (62) Visio (539) Visual Overview (345)
Privacy Policy • Terms & Conditions • Contact

© 2025 Skyline Communications. All rights reserved.

DOJO Q&A widget

Can't find what you need?

? Explore the Q&A DataMiner Docs

[ Placeholder content for popup link ] WordPress Download Manager - Best Download Management Plugin