As you can see from the attached screenshot, my DMA is claiming the database is 0KB in size, I'm assuming that means it's not using the DB, but it should, as long as it's configured, right? 1) can you confirm what the cassandra DB is used for (what does it store, and if it doesn't store it there where does it store it instead, or doesn't it, and the same for the elastic search please, then 2) is there a way to test DB connections in DMA or prove if the connections are OK, and if so why the DB is 0KB?
Cheers, James.
Hi James,
Sorry for late reply. Can you check SLDBConnection.txt logs?
I’ve checked and that log file seems to look OK, I see it attempt a connection to and it confirms it was established, and there’s many other lines too, none of which appear to be errors. I had a thought; perhaps it’s working fine, but the DMA Cube isn’t showing the size because one part of DM knows to use the default port (9042) and the monitoring part doesn’t, so can’t get the size info? I’ve updated the DB connection string to specify the 9042 port, I can’t restart the DMA right now to test this, but would make some sense to me. Will update when I’ve done this in an hour.
I specified the port number and that actually broke the DB connection, so looks to me like some sort of DB bug as to why it’s showing zero data consumption on the DB, could someone take a look at it please?
Hi James,
This seems to be an actual bug for databases other than a local Cassandra (So for database types Cassandra Cluster as wel as Storage as a Service).
The reason is likely that the database structure in these databases is different from the single Cassandra case, as all tables now have their own keyspace rather than everything being in one. DataMiner uses nodetool to fetch that information, but it is likely still using the old request.
I've created an internal task to tackle this issue. This should thus be fixed in one of the future versions.
Hi James,
With regards, to your first question.
The Cassandra database stores (https://docs.dataminer.services/develop/devguide/Connector/AdvancedDataMinerDataPersistenceNoSqlCassandra.html?q=database#database-structure):
While Opensearch/Elastic stores (https://docs.dataminer.services/user-guide/Advanced_Functionality/Databases/Indexing_database/Indexing_Database.html)
And to your next question, Could you try running command prompt in administrator and going to the bin folder of your Cassandra folder and send this command "nodetool status" to see if you can see your Database 
Hi Frans, thanks for your great answer, that really helps, I take it if the cassandra connection wasn’t working there isn’t a backup internal storage is there? I ask as DM is working fine from what I can tell, although a little slower sometimes than I’d expect, which is why I’m looking into this. P.S. when I ran ‘nodetool status’ it attempted to connect to 127.0.0.1, but the DB is hosted on another server, not the same one as the DMA, and the DB server is linux based not windows.
I am not the most familiar with Databases especially one running on Linux. Did you run the nodetool status where the DMA is located? as 127.0.0.1 is the localhost. If that is the case my guess would be that,the DB is not connected to the DM and cause DataMiner is pointing to the linux IP, it reflects 0KB.
Could you check if both the DMS and Linux servers can reach each other. I would also check the firewall to check if the port in question is open for communication.
If all of these are satisfied but is still not working, it might be a configuration issue and I would suggest asking your skyline contact to look into it
Does anyone clever have an answer for this please?