Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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.
06/14/2018 00:17:31: Bindir: C:\AOSService\PackagesLocalDirectoryMetadataDir: C:\AOSService\PackagesLocalDirectorySql 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 SQLDICTIONARY06/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 skipped06/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: 13006/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); ENDEND'.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.
The message says "Failed to open SQL connection". Wasn't there any problem with the DB server at that time?
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.
Business Applications communities