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