Hello all, I would like to ask regarding the Cassandra error as shown below:
It seems that the DMA has trouble offloading files to Cassandra cluster due to the database being in locked.
When I checked the offload folder on the server, there is still the issue of sqlite data not being offloaded due to the database being locked.
Using a 3rd party tool like DB Browser still shows that the sqlite file created by DataMiner is indeed locked:
Is there any procedure am I missing to fix this error? Thank you for the help.
Hi Min
Could you check C:/Skyline Dataminer/Logging/CassandraDriver.txt?
I'm suspecting to find something related to "SQLite error (...)" and "database table is locked" (-> DCP208118/RN37365)
If that's the case, the workaround to this would be:
- Stop DM
- Restart Cassandra
- Start DM
If that would fail, then the final workaround would be:
- Stop DM
- Stop Cassandra
- Delete the offload files (C:/Skyline Dataminer/Offload)
- Start Cassandra
- Start DM
!! removing offload files = losing that data !!