Hi Guys,
We have a Dataminer Agent which is able to start, however none of the functionality is available (no elements running), as the log files complain of the error above.
We are using a Cassandra database, and this is a standalone agent.
Is there any way to get the Database “unstuck” so we can use the agent properly?
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2023
Hey Rodrigo,
It sounds like there is an issue with the .SQLite file used when the cassandra was not reachable. More specifically some lock in there got stuck.
If the data is not critical, then I would just advice to move the files in C:\Skyline Dataminer\Offload to another folder (whilst the dataminer is stopped).
If the data is critical then you can perform the following steps
- Get the sqlite command line tool from the sqlite website (under Precompiled Binaries for Windows)
- Stop the dma
- Open an elevated command prompt
- Run SQLITE3.exe c:\skyline dataminer\Offload\OffloadedData.sqlite3
- Run “.backup main OffloadedData-Backup.sqlite3” (!!notice the .)
- Remove all files in c:\skyline dataminer\Offload\
- Place OffloadedData-Backup.sqlite3 in c:\skyline dataminer\Offload\
- Rename OffloadedData-Backup.sqlite3 to OffloadedData.sqlite3
- Start the dma (it could take a while if there is a lot of data in the file needing to be processed by the DMA)
Let us know if you have issues.
Marieke Goethals [SLC] [DevOps Catalyst] Selected answer as best 18th July 2023