Importing rdm entries into MariaDB

Hi guys,

I'm migrating away from Windows/MS SQL as RDM backend to Ubuntu and MariaDB. I'm importing entries on MariaDB through RDM, but half way through I have the following error from the image captured attached here. I end up with about 30% of my entries imported.

I've tried to export the entries without security groups as well to test if it was a problem with MariaDB not supporting some sort of entry from RDM but it didn't make any difference.

The error that I get is the following:


MySql.Data.MySqlClient.MySqlException (0x80004005): Cannot add or update a child row: a foreign key constraint fails (`rdm`.`Connections`, CONSTRAINT `FK_Connections_GroupInfo` FOREIGN KEY (`SecurityGroup`) REFERENCES `GroupInfo` (`ID`))
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.ExecuteNonQuery(String sql, IDbTransaction dbTransaction, IDbDataParameter[] parameters, Int32 commandTimeout)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.InsertConnection(Connection connection, IDbTransaction dbTransaction, ISecurityProvider provider, Nullable`1 repositoryID)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.SaveConnections(IEnumerable`1 connections, IDbTransaction dbTransaction, ISecurityProvider provider, Nullable`1 repositoryID)
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.SaveConnection(Connection connection)


I'm using RDM 14.1.3.0 64bit