Dynamics Community Forum Thread Details

After importing a database, and attempting to run a db sync out of Visual Studio, I get the following error message "syncengine.exe exited with code -1073740791." I ran a Full Build of all of our models and packages and continue to get this error. Here is the full log:
=== SyncEngine Parameters ===
MetadataBinaries: k:\AOSService\PackagesLocalDirectory
BinFolder: 
MetadataFolder: 
DatabaseConnectionString: **Intentionally omitted for security**
TableOrViewList: 
DropTableOrViewList: 
SyncMode: FullAll
SecurityRoleList: 
SecurityRoleExtensionList: 
SecurityDutyList: 
SecurityDutyExtensionList: 
SecurityPrivilegeList: 
SecurityPolicyList: 
DropRoleList: 
DropRoleExtensionList: 
DropDutyList: 
DropDutyExtensionList: 
DropPrivilegeList: 
DropPolicyList: 
MIDisplayList: 
MIActionList: 
MIOutputList: 
FormList: 
ReportList: 
DropTableExtensionList: 
TableExtensionList: 
KpisList: 
DropKpisList: 
ADEsList: 
DropADEsList: 
CompositeEntityList: 
IgnoreIndexList: 
ContinueOnError: True
ParallelExecution: False
PauseForDebugger: False
SkipInitialSchema: False
IndexCompressionTimeLimitMinutes: 0
LargeTableThresholdMB: 20480
TableThresholdMBForIndexManipulation: 15000
LogVerbosity: Diagnostic
RaiseDataEntityViewSyncNotification: False
AnalysisDirectory: 
SkipInitialSchemaRegionHashing: False
DisableMonitorSync: False
DisableRollbackDecisionGuide: False
RelatedActivityId 00000000-0000-0000-0000-000000000000
Retrieved build version from database.
Could not determine db version info due to Invalid object name 'DBSYNCSCHEMAUPDATESHISTORY'.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: Aborting DAMS resumabe index rebuilds...
Abort DAMS resumable indexes completed.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: Aborting paused resumabe index from last post service sync run...
No index aborted in this run.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: Beginning Sync...
Flighting service init with type: Microsoft.Dynamics.ApplicationPlatform.AOSFlighting.StaticFlightingProvider, Unknown, 
Added TenantID=07303b65-0627-4366-949d-14fc6b71f952 to flighting context
Added EnvironmentId=7757cfdd-ef20-4651-9e1f-32d19bd1f7bd to flighting context
Added PlatformVersion=7.0.7279.51 to flighting context
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: Starting monitoring for application DBSync
Failed to create event session with name dbsync_deadlock_capture, will drop the event session and try to re-create it
Retrying to create deadlock capture session event. Number of retries left: 2
2024-07-31T15:12:48.7959492+00:00 Beginning sync step: DisableConfigKeyMitigation for SysDeletedObjectSysRowVersionNumber.

IF EXISTS (SELECT 1 from sys.tables where name = 'CONFIGKEYIDTABLE')
IF EXISTS (SELECT 1 from sys.tables where name = 'SYSCONFIG')
BEGIN
declare @configKeyId bigint = (select ID from dbo.CONFIGKEYIDTABLE where name = 'SysDeletedObjectSysRowVersionNumber')
declare @configType int = 6
if @configKeyId is not null and not exists (select 1 from dbo.SYSCONFIG where CONFIGTYPE = @configType and ID = @configKeyId)
insert into dbo.SYSCONFIG (CONFIGTYPE, ID, MODIFIEDBY, CREATEDBY) values (@configType, @configKeyId, 'Admin', 'Admin')
END


IF EXISTS (SELECT 1 from sys.tables where name = 'CONFIGKEYIDTABLE')
IF EXISTS (SELECT 1 from sys.tables where name = 'SYSCONFIG')
BEGIN
declare @configKeyId bigint = (select ID from dbo.CONFIGKEYIDTABLE where name = 'SysDeletedObjectSysRowVersionNumber')
declare @configType int = 6
select 1 from dbo.SYSCONFIG where CONFIGTYPE = @configType and ID = @configKeyId
END

Config key 'SysDeletedObjectSysRowVersionNumber' is disabled
2024-07-31T15:12:48.8099398+00:00 DisableConfigKeyMitigation for SysDeletedObjectSysRowVersionNumber finished. Time elapsed: 00:00:00.0141942.
2024-07-31T15:12:48.8119904+00:00 Beginning sync step: DisableConfigKeyMitigation for SysDeletedObjectSysRowVersionNumber2.

IF EXISTS (SELECT 1 from sys.tables where name = 'CONFIGKEYIDTABLE')
IF EXISTS (SELECT 1 from sys.tables where name = 'SYSCONFIG')
BEGIN
declare @configKeyId bigint = (select ID from dbo.CONFIGKEYIDTABLE where name = 'SysDeletedObjectSysRowVersionNumber2')
declare @configType int = 6
if @configKeyId is not null and not exists (select 1 from dbo.SYSCONFIG where CONFIGTYPE = @configType and ID = @configKeyId)
insert into dbo.SYSCONFIG (CONFIGTYPE, ID, MODIFIEDBY, CREATEDBY) values (@configType, @configKeyId, 'Admin', 'Admin')
END


IF EXISTS (SELECT 1 from sys.tables where name = 'CONFIGKEYIDTABLE')
IF EXISTS (SELECT 1 from sys.tables where name = 'SYSCONFIG')
BEGIN
declare @configKeyId bigint = (select ID from dbo.CONFIGKEYIDTABLE where name = 'SysDeletedObjectSysRowVersionNumber2')
declare @configType int = 6
select 1 from dbo.SYSCONFIG where CONFIGTYPE = @configType and ID = @configKeyId
END

Config key 'SysDeletedObjectSysRowVersionNumber2' is disabled
2024-07-31T15:12:48.8129400+00:00 DisableConfigKeyMitigation for SysDeletedObjectSysRowVersionNumber2 finished. Time elapsed: 00:00:00.0013622.
2024-07-31T15:12:48.8159385+00:00 Beginning sync step: DisableConfigKeyMitigation for InventDimension9.

IF EXISTS (SELECT 1 from sys.tables where name = 'CONFIGKEYIDTABLE')
IF EXISTS (SELECT 1 from sys.tables where name = 'SYSCONFIG')
BEGIN
declare @configKeyId bigint = (select ID from dbo.CONFIGKEYIDTABLE where name = 'InventDimension9')
declare @configType int = 6
if @configKeyId is not null and not exists (select 1 from dbo.SYSCONFIG where CONFIGTYPE = @configType and ID = @configKeyId)
insert into dbo.SYSCONFIG (CONFIGTYPE, ID, MODIFIEDBY, CREATEDBY) values (@configType, @configKeyId, 'Admin', 'Admin')
END


IF EXISTS (SELECT 1 from sys.tables where name = 'CONFIGKEYIDTABLE')
IF EXISTS (SELECT 1 from sys.tables where name = 'SYSCONFIG')
BEGIN
declare @configKeyId bigint = (select ID from dbo.CONFIGKEYIDTABLE where name = 'InventDimension9')
declare @configType int = 6
select 1 from dbo.SYSCONFIG where CONFIGTYPE = @configType and ID = @configKeyId
END

Config key 'InventDimension9' is disabled
2024-07-31T15:12:48.8179394+00:00 DisableConfigKeyMitigation for InventDimension9 finished. Time elapsed: 00:00:00.0012647.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: DroppedTableValidator: There are no tables missing from the database that are present in SQLDICTIONARY
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: AdminUserValidator: There are no disabled Admin user accounts in UserInfo table.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: WideIndexesValidator: There are no indexes with 46 or more columns.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: DefaultTextCatalogConfigurator: Getting fulltext catalog count using command: 'SELECT count(*) FROM sys.fulltext_catalogs;'
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: DefaultTextCatalogConfigurator: Fulltext catalog count is: 1. Configuring default fulltext catalog will be skipped
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: CompatibilityLevelConfigurator: Getting Compatibilty Level for Database 'AxDB'. Command: SELECT compatibility_level from sys.databases where name=@databaseName;
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: CompatibilityLevelConfigurator: Compatibilty Level for Database 'AxDB' is: 150
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: CompatibilityLevelConfigurator: Compatibility level '150' meets minimum required level '130'. Skipping compitability level configuration for Database 'AxDB'
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: SystemTableIndexConfigurator: Adding Nonclustered index to SQLDICTIONARY table with command: 'IF EXISTS ( SELECT * from sys.tables where name = 'SQLDICTIONARY')
BEGIN
	IF NOT EXISTS(SELECT * FROM sys.indexes WHERE name = 'SQLDICTIONARY_FieldId_Name' AND object_id = OBJECT_ID('SQLDICTIONARY'))
	BEGIN
		declare @sqlStatement nvarchar(512)
        set @sqlStatement = 'CREATE NONCLUSTERED INDEX [SQLDICTIONARY_FieldId_Name]
		        ON [dbo].[SQLDICTIONARY] ([FIELDID], [NAME]) 
		        INCLUDE (TABLEID, ARRAY, SQLNAME, FIELDTYPE, STRSIZE, SHADOW, RIGHTJUSTIFY, NULLABLE, FLAGS, RECVERSION)'
        IF SERVERPROPERTY('EngineEdition') = 5 or SERVERPROPERTY('EngineEdition') = 3 --SQL Azure or Enterprise
        BEGIN
	        set @sqlStatement = @sqlStatement + ' WITH (ONLINE = ON)'
        END

        exec(@sqlStatement);
	END
END'.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: SystemTableIndexConfigurator: Adding Nonclustered index to DATAAREA table with command: 'IF EXISTS ( SELECT * from sys.tables where name = 'DATAAREA')
BEGIN
	IF NOT EXISTS(SELECT * FROM sys.indexes WHERE name = 'DATAAREA_RecId' AND object_id = OBJECT_ID('DATAAREA'))
	BEGIN
        declare @sqlStatement nvarchar(512)
        set @sqlStatement = 'CREATE NONCLUSTERED INDEX [DATAAREA_RecId]
		        ON [dbo].[DATAAREA] ([RECID]) 
		        INCLUDE ([ID], [NAME], [ISVIRTUAL], [ALWAYSNATIVE], [TIMEZONE], [RECVERSION], [PARTITION])'
        IF SERVERPROPERTY('EngineEdition') = 5 or SERVERPROPERTY('EngineEdition') = 3 --SQL Azure or Enterprise
        BEGIN
	        set @sqlStatement = @sqlStatement + ' WITH (ONLINE = ON)'
        END

        exec(@sqlStatement);
	END
END'.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: GlobalTempTableConfigurator: Getting GLOBAL_TEMPORARY_TABLE_AUTO_DROP flag using command: 'SELECT CAST(VALUE AS INT) FROM SYS.DATABASE_SCOPED_CONFIGURATIONS WHERE NAME = 'GLOBAL_TEMPORARY_TABLE_AUTO_DROP''
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: GlobalTempTableConfigurator: GLOBAL_TEMPORARY_TABLE_AUTO_DROP flag is already OFF. No need to configure this flag for Database 'AxDB'
2024-07-31T15:12:56.4051244+00:00 Beginning sync step: InitialSchema.
2024-07-31T15:12:56.4971089+00:00 InitialSchema finished. Time elapsed: 00:00:00.0920866.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: WideEnumerationsValidator: Flight DbSyncEnable32bitEnumCreation flag is not enabled, Hence xpp enum. should have less than 256 values.
[DbSync: 7.0.30673] [Platform: 7.0.7279.51] [SourcePlatform: 7.0.7279.51] [DatabaseVersion: 7.0.7279.51]: WideEnumerationsValidator: Found an enumeration with more than 240 values in metadata: 'LedgerPostingType' - 242
2024-07-31T15:12:56.8811254+00:00 Beginning sync step: FullIds.
SyncType: LicenseCodes(LICENSECODEIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
SyncType: Enums(ENUMIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
SyncType: Edts(TYPEIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
SyncType: Classes(CLASSIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
Entity keys synced during ID sync
SyncType: TableIdSync(TABLEIDTABLE, TABLEFIELDIDTABLE, TABLEINDEXIDTABLE, TABLEFULLINDEXIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
Using force resync for TableIdSync.
Resync is required for TableIdSync. Writing records to the database.
Records existing in table id tables will be removed with the following commands:
DELETE FROM TABLEFIELDIDTABLE
DELETE FROM TABLEINDEXIDTABLE
DELETE FROM TABLEFULLTEXTIDTABLE
DELETE FROM TABLEIDTABLE
SyncType: ConfigurationKeys(CONFIGKEYIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
2024-07-31T15:13:39.0758491+00:00 FullIds finished. Time elapsed: 00:00:42.1916124.
2024-07-31T15:13:39.0918508+00:00 Beginning sync step: FullTablesAndViews.
2024-07-31T15:13:39.1318511+00:00 Beginning sync step: kernel bootstrap sync.
Syncing Table: SQLDICTIONARY
Schema has not changed between new table 'SqlDictionary' and old table 'SqlDictionary' with table id '65518'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: SQLDICTIONARY. Time elapsed: 0:00:00:01.0320686
Syncing Table: USERINFO
Schema has not changed between new table 'UserInfo' and old table 'UserInfo' with table id '65531'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: USERINFO. Time elapsed: 0:00:00:00.3850230
Syncing Table: SYSCONFIG
Schema has not changed between new table 'SysConfig' and old table 'SysConfig' with table id '65514'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: SYSCONFIG. Time elapsed: 0:00:00:00.2220192
Syncing Table: SECURITYROLE
Schema has not changed between new table 'SecurityRole' and old table 'SecurityRole' with table id '65491'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: SECURITYROLE. Time elapsed: 0:00:00:00.2190068
Syncing Table: AOSDUPLICATEKEYEXCEPTIONMESSAGE
Schema has not changed between new table 'AosDuplicateKeyExceptionMessage' and old table 'AosDuplicateKeyExceptionMessage' with table id '65483'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: AOSDUPLICATEKEYEXCEPTIONMESSAGE. Time elapsed: 0:00:00:00.2230200
Syncing Table: TIMEZONESLIST
Schema has not changed between new table 'TimeZonesList' and old table 'TimeZonesList' with table id '65496'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: TIMEZONESLIST. Time elapsed: 0:00:00:00.2280144
Syncing Table: DATABASELOG
Schema has not changed between new table 'DatabaseLog' and old table 'DatabaseLog' with table id '65508'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: DATABASELOG. Time elapsed: 0:00:00:00.2290142
Syncing Table: TIMEZONESRULESDATA
Schema has not changed between new table 'TimeZonesRulesData' and old table 'TimeZonesRulesData' with table id '65495'. Returning from ManagedSyncTableWorker.ExecuteModifyTable()
Syncing Table Finished: TIMEZONESRULESDATA. Time elapsed: 0:00:00:00.2190126
2024-07-31T15:13:41.9340345+00:00 kernel bootstrap sync finished. Time elapsed: 00:00:02.8017444.
2024-07-31T15:13:42.0000366+00:00 Beginning sync step: AosConfig.Init.
Database synchronization completed (113199 ms). Errors found.
syncengine.exe exited with code -1073740791.
Categories:
Administration and Setup