Hello all,

We built a new DMA from scratch yesterday. Added it into the cluster, no apparent issues. However when attempting to create an element (Skyline Microsoft Platform Driver), we noticed it would not start and had this error in the logs:

InitializeParameters failed General database failure. (hr = 0x80040226)
InitializeProtocol for Element GOHGL11-DNMA1 failed with General database failure.. (hr = 0x80040226)
** Setting error : Initializing the protocol for GOHGL11-DNMA1 failed. General database failure. (hr = 0x80040226)CElement::Activate|ERR|0|Start failed. General database failure. (hr = 0x80040226)

Looking into the SLDataGateway logs it became apparent it was failing to connect to the DB. Looking in the SLDBConnection logs we see this:

2021/10/28 23:21:42.671|SLDBConnection|DBGateway.Initialize|DBG|0|32|Setting up connections and storage...

2021/10/28 23:21:42.671|SLDBConnection|DBGateway::Initialize|INF|0|32|Error: code = CantOpen (14), message = System.Data.SQLite.SQLiteException (0x800007FF): unable to open database file

   at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)

   at System.Data.SQLite.SQLiteConnection.Open()

   at SLDataGateway.Types.FileOffload.OfflineStorageUtil.SQLiteConnectionFactory.Create(String connectionString)

   at SLDataGateway.Types.FileOffload.OfflineStorageUtil.SQLiteDB.CreateWithFile(String filePath, Int32 maxTransactionSize)

   at SLCassandraClassLibrary.DBGateway.DBGateway.<>c.<.cctor>b__330_0()

   at System.Lazy`1.CreateValue()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()

   at System.Lazy`1.get_Value()

   at SLCassandraClassLibrary.DBGateway.DBGateway.Initialize()

Any ideas/thoughts why this may have happened. This is a completely clean agent. We customised the commitlog_directory variable in the cassandra.yaml file but this has been done for many other agents in the past and this appears to be no different.

Many thanks