web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How to resolve databas...
Finance | Project Operations, Human Resources, ...
Suggested Answer

How to resolve database synchronization error in onebox env D365FO?

(0) ShareShare
ReportReport
Posted on by Michael Antony 314

Hi Guys. I need help for my error in database synchronization error.

The error output is like this:

=== SyncEngine Parameters ===
MetadataBinaries: C:\AOSService\PackagesLocalDirectory
BinFolder: 
MetadataFolder: 
DatabaseConnectionString: **Intentionally omitted for security**
TableOrViewList: 
DropTableOrViewList: 
SyncMode: FullAll
SecurityRoleList: 
SecurityRoleExtensionList: 
SecurityDutyList: 
SecurityDutyExtensionList: 
SecurityPrivilegeList: 
SecurityPolicyList: 
DropRoleList: 
DropRoleExtensionList: 
DropDutyList: 
DropDutyExtensionList: 
DropPrivilegeList: 
DropPolicyList: 
MIDisplayList: 
MIActionList: 
MIOutputList: 
FormList: 
ReportList: 
DropTableExtensionList: 
TableExtensionList: 
KpisList: 
DropKpisList: 
ADEsList: 
DropADEsList: 
CompositeEntityList: 
IgnoreIndexList: 
ContinueOnError: True
ParallelExecution: False
PauseForDebugger: False
SkipInitialSchema: False
IndexCompressionTimeLimitMinutes: 0
LargeTableThresholdMB: 20480
TableThresholdMBForIndexManipulation: 15000
LogVerbosity: Minimal
RaiseDataEntityViewSyncNotification: False
AnalysisDirectory: 
SkipInitialSchemaRegionHashing: False
DisableMonitorSync: False
DisableRollbackDecisionGuide: False
RelatedActivityId 00000000-0000-0000-0000-000000000000
[DbSync: 7.0.30285.0] [Platform: 7.0.5746.35600]: WideIndexesValidator: Table 'RETAILTRANSACTIONSALESTRANS' has index 'IX_RETAILTRANSACTIONSALESTRANS_TRANSACTIONID' with a high number of columns: 48
AOS database sync failed.	Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: One or more errors occurred.
   at System.Threading.Tasks.Task.FastWaitAll(Task[] tasks)
   at System.Threading.Tasks.Parallel.Invoke(ParallelOptions parallelOptions, Action[] actions)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.SyncAll()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.b__21_0()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll()
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider)
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass15_0.b__0()
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
Inner exceptions:
SqlException:Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   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)
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.SqlCommandExtensions.<>c__DisplayClass4.b__3()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.<>c__DisplayClass31_0.b__0(SqlCommand command)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.HandleException(ExceptionDispatchInfo edi, SqlExecutionInfo execInfo)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
   at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.PopulateTableNormalIndexRepository(String sqlConnectionString)
   at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.Initialize(String sqlConnectionString, Boolean reInitialize)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c.b__27_0(String c)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.get_IndexInfoRepository()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c__DisplayClass42_0.b__5()
   at System.Threading.Tasks.Task.Execute()
Inner exception:
Win32Exception:The wait operation timed out.
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.b__15_1(Tuple`2 result)
AOS database sync failed.	Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: One or more errors occurred.
   at System.Threading.Tasks.Task.FastWaitAll(Task[] tasks)
   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)
   at System.Threading.Tasks.Parallel.Invoke(ParallelOptions parallelOptions, Action[] actions)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.SyncAll()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.b__21_0()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll()
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider)
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass15_0.b__0()
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
Inner exceptions:
SqlException:Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   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)
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.SqlCommandExtensions.<>c__DisplayClass4.b__3()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.<>c__DisplayClass31_0.b__0(SqlCommand command)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.HandleException(ExceptionDispatchInfo edi, SqlExecutionInfo execInfo)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
   at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.PopulateTableNormalIndexRepository(String sqlConnectionString)
   at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.Initialize(String sqlConnectionString, Boolean reInitialize)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c.b__27_0(String c)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.get_IndexInfoRepository()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c__DisplayClass42_0.b__5()
   at System.Threading.Tasks.Task.Execute()
Inner exception:
Win32Exception:The wait operation timed out.
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.b__15_1(Tuple`2 result)
   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)
Database synchronization completed (785242 ms). Errors found.
AOS database sync failed.	Microsoft.Dynamics.AX.Framework.Database.TableSyncException: Full sync did not complete successfully. Error: One or more errors occurred.
   at System.Threading.Tasks.Task.FastWaitAll(Task[] tasks)
   at System.Threading.Tasks.Parallel.Invoke(ParallelOptions parallelOptions, Action[] actions)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.SyncAll()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncWorkerManager.SyncAll()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.b__21_0()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.EnsureMetadataProviderCacheCleared(Action action)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSync.SyncAll()
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullManagedSync(SyncOptions options, String sqlConnectionString, IMetadataProvider metadataProvider)
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c__DisplayClass15_0.b__0()
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
Inner exceptions:
SqlException:Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   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)
   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)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.SqlCommandExtensions.<>c__DisplayClass4.b__3()
   at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.<>c__DisplayClass31_0.b__0(SqlCommand command)
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.ExecuteSql[T](SqlCommand cmd, Func`2 sqlFunc)
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Dynamics.AX.Data.Sql.SqlDataAccessManager.HandleException(ExceptionDispatchInfo edi, SqlExecutionInfo execInfo)
   at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.PopulateTableNormalIndexRepository(String sqlConnectionString)
   at Microsoft.Dynamics.AX.Data.Management.TableIndexInfoRepository.Initialize(String sqlConnectionString, Boolean reInitialize)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c.b__27_0(String c)
   at System.Collections.Concurrent.ConcurrentDictionary`2.GetOrAdd(TKey key, Func`2 valueFactory)
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.get_IndexInfoRepository()
   at Microsoft.Dynamics.AX.Data.Management.ManagedSyncTableWorker.<>c__DisplayClass42_0.b__5()
   at System.Threading.Tasks.Task.Execute()
Inner exception:
Win32Exception:The wait operation timed out.
   at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.b__15_1(Tuple`2 result)
   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)
syncengine.exe exited with code -1.

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 237,908 Most Valuable Professional on at

    Do you have 48 fields in TransactionId index in RetailTransactionSalesTrans table? If so, why? You can't have that - the database server doesn't support such a high number.

  • Michael Antony Profile Picture
    Michael Antony 314 on at

    Hi, it is by standard Martin.

    I do not have any customization on that table.

  • Ahmad_Sufyan Profile Picture
    Ahmad_Sufyan on at

    Can you please let me know the build version of your onebox.

  • Michael Antony Profile Picture
    Michael Antony 314 on at

    Hi Ahmad,

    This is my onebox build version.

    Installed product version : 10.0.13 (10.0.569.10005)

    Installed platform version : Update37 (7.0.5746.35600)

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at

    Can you try my response on your development machine?

    community.dynamics.com/.../database-sync-issue-for-d365-f-o

  • Michael Antony Profile Picture
    Michael Antony 314 on at

    Hi Sohail,

    I do not have any customization on the IX_RETAILTRANSACTIONSALESTRANS_TRANSACTIONID Index.

    And I have checked that i have included PersonnelManagement to my model.

  • Michael Antony Profile Picture
    Michael Antony 314 on at

    At last, I have been successfully synchronized database after I did a full build on my model and all the other packages that my model referenced to.

  • Suggested answer
    Sheikh Sohail Profile Picture
    Sheikh Sohail 6,125 on at

    Hi Michael

    If my recommendation helped you then please mark the verified answer to help others.

Under review

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

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 544 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 450 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 250 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans