Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Getting synch error af...
Finance forum
Under review by Community Managers

Under review

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

Getting synch error after DB restore from Golden to VM

Posted on by 438

Hi Team,

I am getting below error after i restored DB from golden (tier 2) to dev VM. After restoration I did Database synchronization it is also successful.

but when i am doing Build + synch on my custom model then i am getting below issue.
Please suggest me if any one has face this issue.

I have already verified below points. 
DEV VM and Gold environment  both are on PU49.
I restarted DEV server.
Verified all SQL services are up.

Error Details 
Severity Code Description Project File Line Suppression State
Error syncengine.exe exited with code -1. 1
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c.<get_IndexInfoRepository>b__29_0(String c) 0
Error at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) 0
Error at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) 0
Error at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 0
Error at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) 0
Error at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory) 0
Error at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.get_IndexInfoRepository() 0
Error at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 0
Error at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) 0
Error --- End of stack trace from previous location where exception was thrown --- 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c__DisplayClass49_0.<SyncAll>b__5() 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync() 0
Error at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.PopulateTableFullTextIndexRepository(String sqlConnectionString) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync() 0
Error at System.Data.SqlClient.SqlDataReader.get_MetaData() 0
Error at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.<>c__DisplayClass31_0.<ExecuteReaderAction>b__0(SqlCommand command) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.<SyncAll>b__21_0() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action) 0
Error SqlException:Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 0
Error at System.Threading.Tasks.Task.FastWaitAll(Task[] tasks) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.SyncAll(IProducerConsumerCollection`1 modifiedViewDependencies) 0
Error at System.Data.SqlClient.SqlCommand.ExecuteReader() 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll() 0
Error at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() 0
Error at System.Threading.Tasks.Task.Execute() 0
Error at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync() 0
Error AOS database sync failed. Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: One or more errors occurred. 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass21_0.<RunFullTableSync>b__0() 0
Error Win32Exception:The wait operation timed out. 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler) 0
Error at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 0
Error at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.Initialize(String sqlConnectionString, Boolean reInitialize) 0
Error at System.Threading.Tasks.Parallel.Invoke(ParallelOptions parallelOptions, Action[] actions) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options) 0
Error at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.HandleException(ExceptionDispatchInfo edi, SqlExecutionInfo execInfo) 0
Error at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll() 0
Error at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 0
Error Inner exception: 0
Error at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) 0
Error at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.SqlCommandExtensions.<>c__DisplayClass4.<ExecuteReaderWithRetry>b__3() 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunFullTableSync>b__21_1(Tuple`2 result) 0
Error Inner exceptions: 0

Please help me on this.

BR

Vijay Yelmame

8805549377

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans