Finance | Project Operations, Human Resources, ...

After restoring Database there is sync error from UAT to Cloud hosted environment

(0) Share

Report

Posted on by AX 2012 r3

2,426

This is my Cloud hosted environment Version

and this is my UAT Environment version (Where Database backup is taken)

Here is when i do sync the error is copied from event viewer

+ System

- Provider

[ Name] Microsoft-Dynamics-AX-DatabaseSynchronize

EventID 53

- Execution

[ ProcessID] 11928
[ ThreadID] 17652

exceptionDetails 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.?A0x0ecd63ac.GetAosConfig() at Microsoft.Dynamics.AX.AosConfig.Config.InitInternal() at Microsoft.Dynamics.AX.AosConfig.Config.InitOnce(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.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider) at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync() at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync() at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync() at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
Message [DbSync: 7.0.30182.0] [Platform: 7.0.5407.35455]: Failed to open SQL connection

When i do some research on this i found this blog Stating this

https://community.dynamics.com/365/financeandoperations/f/dynamics-365-for-finance-and-operations-forum/237572/synchronization-failed-after-database-restore-data-import?pifragment-94775=1

"This issue may arise when the platform build number of the current environment is lower than the platform build number of the source environment. I had the same one and resolved by upgrading my environment’s platform to match the source environment. Also, it's possible to adjust the expected version in the database, but I didn't try that. Read more about it here: https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/database/copy-database-from-azure-sql-to-sql-server"

So my doubt is is this really because of version mismatch ?

If this is the case how can we "Also, it's possible to adjust the expected version in the database," ?

How can i proceed now with this sync error ?

Experts please provide some solution on this.

Regards.

Have a nice day.

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

zhifeng Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

There are some known issues during database refresh:

Incompatible application versions between source and target environments

The database refresh process (self-service or via service request) cannot be completed if the Application release of your source and target environment are not the same. This is because the data upgrade process is not executed by database movement operations such as refresh, and data loss can occur.

If upgrading your sandbox UAT environment to a newer Application version (for example, 7.3 to 8.1), be sure to perform the database refresh action prior to starting the upgrade. After your sandbox is upgraded to the newer version, you cannot restore an older production environment database in to the sandbox UAT environment.

Conversely, if your production environment is newer than your target sandbox, you will need to either upgrade the target sandbox prior to the refresh or simply deallocate, delete, and redeploy prior to performing the refresh.

You can find more details here: docs.microsoft.com/.../database-refresh

Was this reply helpful? Yes No
AX 2012 r3 2,426 on at

Like (0)

Report
Copy link

Link copied!

Hi Kevin,

Thanks for your quick reply.

Yes i have gone through this as well.

Well that's my concer is

What should i do now.

Is there any work around that i can update in SQL with new version related kind of thing or

Should i update my machine and restore db.?

Please provide some suggestions on this.

Regards.

Was this reply helpful? Yes No
zhifeng Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, upgrade same version then try database restore. If it doesn't work, i would suggest raise a ticket to MS.

Was this reply helpful? Yes No