SBX - Search With Button

SBX - Forum Post Title

D365 Can Not Sync Database After Upgrade from AX 2012 R3

Microsoft Dynamics AX Forum

Haroon Attari asked a question on 14 Jun 2018 3:31 AM
My Badges

Question Status

Unanswered

Hi

I am doing upgrade from AX 2012 R3 and while following this article the upgrade is failing at step 8 i.e. "Final DB Sync for data upgrade". The log file shows following error. Will appreciate if anyone can help. 

Thanks

Haroon

06/14/2018 00:17:31: Bindir: C:\AOSService\PackagesLocalDirectory
MetadataDir: C:\AOSService\PackagesLocalDirectory
Sql scripts:

06/14/2018 00:17:31: Setup mode is "servicesync".
06/14/2018 00:17:32: Beginning Sync...
06/14/2018 00:17:36: There are no tables missing from the database that are present in SQLDICTIONARY
06/14/2018 00:17:36: Getting fulltext catalog count using command: 'SELECT count(*) FROM sys.fulltext_catalogs;'
06/14/2018 00:17:36: Fulltext catalog count is: 1. Configuring default fulltext catalog will be skipped
06/14/2018 00:17:36: Getting Compatibilty Level for Database 'AxDB'. Command: SELECT compatibility_level from sys.databases where name=@databaseName;
06/14/2018 00:17:36: Compatibilty Level for Database 'AxDB' is: 130
06/14/2018 00:17:36: Compatibility level '130' meets minimum required level '130'. Skipping compitability level configuration for Database 'AxDB'
06/14/2018 00:17:36: Adding Nonclustered index to SQLDICTIONARY on (FIELDID, NAME) 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
CREATE NONCLUSTERED INDEX [SQLDICTIONARY_FieldId_Name]
ON [dbo].[SQLDICTIONARY] ([FIELDID], [NAME])
INCLUDE (TABLEID, ARRAY, SQLNAME, FIELDTYPE, STRSIZE, SHADOW, RIGHTJUSTIFY, NULLABLE, FLAGS, RECVERSION) WITH (ONLINE = ON);
END
END'.
06/14/2018 00:17:37: 2018-06-14T00:17:37.7211186-07:00 Beginning sync step: InitialSchema.
06/14/2018 00:17:40: 2018-06-14T00:17:40.3929878-07:00 InitialSchema finished. Time elapsed: 00:02:678.
06/14/2018 00:17:40: 2018-06-14T00:17:40.3929878-07:00 Beginning sync step: FullIds.
06/14/2018 00:17:40: Using legacy ids where possible.
06/14/2018 00:17:40: SyncType: LicenseCodes(LICENSECODEIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
06/14/2018 00:17:40: SyncType: Enums(ENUMIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
06/14/2018 00:17:40: SyncType: Edts(TYPEIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
06/14/2018 00:17:40: SyncType: Classes(CLASSIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
06/14/2018 00:17:50: SyncType: ConfigurationKeys(CONFIGKEYIDTABLE). All entries were able to have their requested or legacy id assigned. No new assignments will be made.
06/14/2018 00:17:50: 2018-06-14T00:17:50.7183638-07:00 FullIds finished. Time elapsed: 00:10:324.
06/14/2018 00:17:50: 2018-06-14T00:17:50.7183638-07:00 Beginning sync step: PreTableViewSyncActions.
06/14/2018 00:17:50: 2018-06-14T00:17:50.7183638-07:00 Beginning sync step: pre-sync custom action: '<RunFullSync>b__1'.
06/14/2018 00:19:59: 2018-06-14T00:19:59.6465252-07:00 pre-sync custom action: '<RunFullSync>b__1' finished. Time elapsed: 02:08:929.
06/14/2018 00:19:59: 2018-06-14T00:19:59.6465252-07:00 PreTableViewSyncActions finished. Time elapsed: 02:08:929.
06/14/2018 00:19:59: Microsoft.Dynamics.AX.InitializationException: Failed to open SQL connection
at Microsoft.Dynamics.AX.AOS.StartupInternal(String[] Arguments)
at Microsoft.Dynamics.AX.AOS.Startup()
at Microsoft.Dynamics.AX.AosConfig.?A0x20ac5ebd.GetAosConfig()
at Microsoft.Dynamics.AX.AosConfig.Config.InitInternal(Boolean isOfflineMode)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.StartAosCode(SyncOptions syncOptions, String sqlConnectionString)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunCustomAction(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Action`1 a)
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.PreTableSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync()
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync(SyncOptions options)
at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
06/14/2018 00:19:59: The operation failed.

Reply
Martin Dráb responded on 14 Jun 2018 3:38 AM

The message says "Failed to open SQL connection". Wasn't there any problem with the DB server at that time?

Reply
Haroon Attari responded on 14 Jun 2018 3:47 AM
My Badges

I encountered this error at step 3 also and added current user as db_owner which allowed the step to move further but do not know why it is giving the same error on step 8 again.

Reply

SBX - Two Col Forum

SBX - Migrated JS