MSPControl error. Can't Migrate Up or add log to Audit Log. An error occured executing the following sql:
IF NOT EXISTS (SELECT * FROM [dbo].[ServiceItemTypes] WHERE [ItemTypeID] = 380)
	INSERT [dbo].[ServiceItemTypes] ([ItemTypeID], [GroupID], [DisplayName], [TypeName], [TypeOrder], [CalculateDiskSpace], [CalculateBandwidth], [Suspendable], [Disposable], [Searchable], [Importable], [Backupable]) VALUES (380, 55, N'MsSQL2019Database', N'MSPControl.Providers.Database.SqlDatabase, MSPControl.Providers.Base', 1, 1, 0, 0, 1, 1, 1, 1)
The error was The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ServiceItemTypes_ResourceGroups". The conflict occurred in database "MSPControl", table "dbo.ResourceGroups", column 'GroupID'.
The statement has been terminated.
. Prepare migration.
Connecting to Db: server=192.168.5.1,3....
Start migration.
/* Beginning Transaction */


BEGIN TRANSACTION


/* 2000: Migration2000 migrating ============================================= */




/* ExecuteSqlStatement -- Changes to Assembly structures, where provider classes are located.
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.OS.Windows2003, MSPControl.Providers.OS.Windows' WHERE [ProviderID] = 1
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.OS.Windows2008, MSPControl.Providers.OS.Windows' WHERE [ProviderID] = 100
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.OS.Windows2012, MSPControl.Providers.OS.Windows' WHERE [ProviderID] = 104
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.OS.Windows2016, MSPControl.Providers.OS.Windows' WHERE [ProviderID] = 107
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Web.IIs60, MSPControl.Providers.Web.IIs' WHERE [ProviderID] = 2
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Web.IIs70, MSPControl.Providers.Web.IIs' WHERE [ProviderID] = 101
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Web.IIs80, MSPControl.Providers.Web.IIs' WHERE [ProviderID] = 105
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Web.IIs100, MSPControl.Providers.Web.IIs' WHERE [ProviderID] = 108
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.FTP.MsFTP80, MSPControl.Providers.FTP.IIs' WHERE [ProviderID] = 106
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.FTP.MsFTP60, MSPControl.Providers.FTP.IIs' WHERE [ProviderID] = 3
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.FTP.MsFTP100, MSPControl.Providers.FTP.IIs' WHERE [ProviderID] = 109
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.FTP.MsFTP70, MSPControl.Providers.FTP.IIs' WHERE [ProviderID] = 102
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.hMailServer43, MSPControl.Providers.Mail.hMailServer' WHERE [ProviderID] = 22
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.hMailServer5, MSPControl.Providers.Mail.hMailServer' WHERE [ProviderID] = 63
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.SmarterMail2, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 11
GO
UPDATE [dbo].[Providers] SET [ProviderType] =  N'MSPControl.Providers.Mail.SmarterMail3, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 14
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.SmarterMail5, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 29
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.SmarterMail6, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 60
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.SmarterMail7, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 64
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.SmarterMail9, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 65
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.SmarterMail10, MSPControl.Providers.Mail.SmarterMail' WHERE [ProviderID] = 66
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.Mail.Merak10, MSPControl.Providers.Mail.Merak' WHERE [ProviderID] = 61
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.EnterpriseStorage.Windows2012, MSPControl.Providers.EnterpriseStorage.Windows' WHERE [ProviderID] = 600
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.StorageSpaces.Windows2012, MSPControl.Providers.StorageSpaces.Windows' WHERE [ProviderID] = 700
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.RemoteDesktopServices.Windows2012, MSPControl.Providers.RemoteDesktopServices.Windows' WHERE [ProviderID] = 1501
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.DNS.SimpleDNS5, MSPControl.Providers.DNS.SimpleDNS' WHERE [ProviderID] = 28
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.DNS.SimpleDNS6, MSPControl.Providers.DNS.SimpleDNS' WHERE [ProviderID] = 35
GO
UPDATE [dbo].[Providers] SET [ProviderType] = N'MSPControl.Providers.DNS.SimpleDNS8, MSPControl.Providers.DNS.SimpleDNS' WHERE [ProviderID] = 36
GO

IF NOT EXISTS (SELECT * FROM [dbo].[ResourceGroups] WHERE [GroupName] = 'MySQL8')
	INSERT [dbo].[ResourceGroups] ([GroupID], [GroupName], [GroupOrder], [GroupController], [ShowGroup]) VALUES (53, N'MySQL8', 12, N'MSPControl.EnterpriseServer.DatabaseServerController', 1)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 360)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (360, 6, N'MySQLUnix', N'MySQL Server 4.x on Unix', N'MSPControl.Providers.Database.MySqlServerUnix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 361)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (361, 11, N'MySQLUnix', N'MySQL Server 5.0 on Unix', N'MSPControl.Providers.Database.MySqlServer50Unix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 362)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (362, 11, N'MySQLUnix', N'MySQL Server 5.1 on Unix', N'MSPControl.Providers.Database.MySqlServer51Unix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 363)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (363, 11, N'MySQLUnix', N'MySQL Server 5.5 on Unix', N'MSPControl.Providers.Database.MySqlServer55Unix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 364)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (364, 11, N'MySQLUnix', N'MySQL Server 5.6 on Unix', N'MSPControl.Providers.Database.MySqlServer56Unix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 365)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (365, 11, N'MySQLUnix', N'MySQL Server 5.7 on Unix', N'MSPControl.Providers.Database.MySqlServer57Unix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderName] = 'BindUnix')
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (370, 7, N'BindUnix', N'ISC BIND 8.x - 9.x on Unix', N'MSPControl.Providers.DNS.IscBindUnix, MSPControl.Providers.DNS.Bind', N'Bind', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderName] = 'PowerDNSUnix')
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (371, 7, N'PowerDNSUnix', N'PowerDNS on Unix', N'MSPControl.Providers.DNS.PowerDNSUnix, MSPControl.Providers.DNS.PowerDNS', N'PowerDNS', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderName] = 'EnterpriseStorage2016')
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (601, 44, N'EnterpriseStorage2016', N'Enterprise Storage Windows 2016', N'MSPControl.Providers.EnterpriseStorage.Windows2016, MSPControl.Providers.EnterpriseStorage.Windows', N'EnterpriseStorage', 1)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderName] = 'StorageSpace2016')
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (701, 49, N'StorageSpace2016', N'Storage Spaces Windows 2016', N'MSPControl.Providers.StorageSpaces.Windows2016, MSPControl.Providers.StorageSpaces.Windows', N'StorageSpaceServices', 1)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderName] = 'RemoteDesktopServices2016')
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (1502, 45, N'RemoteDesktopServices2016', N'Remote Desktop Services Windows 2016', N'MSPControl.Providers.RemoteDesktopServices.Windows2012,MSPControl.Providers.RemoteDesktopServices.Windows', N'RDS', 1)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 372)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (372, 53, N'MySQL', N'MySQL Server 8.x', N'MSPControl.Providers.Database.MySqlServer80, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderID] = 373)
	INSERT [dbo].[Providers] ([ProviderID], [GroupID], [ProviderName], [DisplayName], [ProviderType], [EditorControl], [DisableAutoDiscovery]) VALUES (373, 53, N'MySQLUnix', N'MySQL Server 8.x on Unix', N'MSPControl.Providers.Database.MySqlServer80Unix, MSPControl.Providers.Database.MySQL', N'MySQL', NULL)
GO
IF NOT EXISTS (SELECT * FROM [dbo].[Providers] WHERE [ProviderName] = 'Unix')
	INSERT [dbo].[Providers...