Hello,
on our OneBox-Dev-Environment with SR 10.0.30 the Database Synchronization fails. We did a full build on the environment without errors.
Apparently the step "abort paused PostServiceSync resumable index from last run" fails. The exception "Invalid column name 'DEFERREDOPERATIONSTATE' is mentioned, but without mention of a table or view. I can't find the column anywhere.
This is the full error when synchronizing the database in Visual Studio:
Failed to abort paused PostServiceync resumable index from last run: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'DEFERREDOPERATIONSTATE'.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Dynamics.AX.Data.Management.DBExecute.<>c__DisplayClass85_0.<AbortPausedPostServiceSyncResumableIndexFromLastRun>b__0()
at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.<ExecuteAction>b__0()
at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Microsoft.Dynamics.AX.Data.Management.SqlCommandFactory.ExecuteWithRetry[T](Action callback, TimeSpan maxBackOff, TimeSpan deltaBackOff, String label, Int32 retryCount)
at Microsoft.Dynamics.AX.Data.Management.DBExecute.AbortPausedPostServiceSyncResumableIndexFromLastRun(String sqlConnectionString, Action`2 logger)
ClientConnectionId:57c22080-3cc8-488f-b8ab-363ed1f9e930
Number:207,State:1,Class:16
[DbSync: 7.0.30566.0] [Platform: 7.0.6592.33] [SourcePlatform: 7.0.6592.33]: WideIndexesValidator: Table 'RETAILTRANSACTIONSALESTRANS' has index 'IX_RETAILTRANSACTIONSALESTRANS_TRANSACTIONID' with a high number of columns: 48
Database synchronization completed (304960 ms). Errors found.
syncengine.exe exited with code -1073740791.
And this is the log when we start syncengine.exe in the command prompt:
[DbSync: 7.0.30566.0] [Platform: 7.0.6592.33] [SourcePlatform: 7.0.6592.33]: Aborting DAMS resumabe index rebuilds...
Abort DAMS resumable indexes completed.
[DbSync: 7.0.30566.0] [Platform: 7.0.6592.33] [SourcePlatform: 7.0.6592.33]: Aborting paused resumabe index from last post service sync run...
Failed to abort paused PostServiceync resumable index from last run: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'DEFERREDOPERATIONSTATE'.
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.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.Dynamics.AX.Data.Management.DBExecute.<>c__DisplayClass85_0.<AbortPausedPostServiceSyncResumableIndexFromLastRun>b__0()
at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.<>c__DisplayClass1.<ExecuteAction>b__0()
at Microsoft.Practices.EnterpriseLibrary.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func)
at Microsoft.Dynamics.AX.Data.Management.SqlCommandFactory.ExecuteWithRetry[T](Action callback, TimeSpan maxBackOff, TimeSpan deltaBackOff, String label, Int32 retryCount)
at Microsoft.Dynamics.AX.Data.Management.DBExecute.AbortPausedPostServiceSyncResumableIndexFromLastRun(String sqlConnectionString, Action`2 logger)
ClientConnectionId:9bf7693a-118d-4994-b200-029c6d59946b
Number:207,State:1,Class:16
[DbSync: 7.0.30566.0] [Platform: 7.0.6592.33] [SourcePlatform: 7.0.6592.33]: Beginning Sync...
Any help is appreciated. Thank you in advance.
Hi André,
we moved it from one to another Hyper-V-Server. It worked for some days but then the error occurred. I can't say what exactly happened right before. The developer said he got the latest files from TFS and did a full build.
Hi Arunraj,
yes, but I could not find i there.
Hi,
Did you check to see if the column name is listed in the SQLDictionary table?
Hi Tino,
What exactly got changed on this VM and did the DB sync work before correctly?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,228 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156