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
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.
The message says "Failed to open SQL connection". Wasn't there any problem with the DB server at that time?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156