Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

D365 Can Not Sync Database After Upgrade from AX 2012 R3

Posted on by 2,309

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.

*This post is locked for comments

  • haroonattari Profile Picture
    haroonattari 2,309 on at
    RE: D365 Can Not Sync Database After Upgrade from AX 2012 R3

    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.

  • Martin Dráb Profile Picture
    Martin Dráb 230,030 Most Valuable Professional on at
    RE: D365 Can Not Sync Database After Upgrade from AX 2012 R3

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans