Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'

Posted on by 144

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.

  • Suggested answer
    CU07050638-0 Profile Picture
    CU07050638-0 6 on at
    PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'
    Hi,
     
    I encountered this error also. It resolved on its own when I resolved the other errors.
    Try building only your custom objects and resolve errors if there are any.
     
     
     
  • Tino Profile Picture
    Tino 144 on at
    RE: PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'

    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.

  • Tino Profile Picture
    Tino 144 on at
    RE: PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'

    Hi Arunraj,

    yes, but I could not find i there.

  • Suggested answer
    Arunraj Rajasekar Profile Picture
    Arunraj Rajasekar 1,731 on at
    RE: PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'

    Hi,

    Did you check to see if the column name is listed in the SQLDictionary table?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,228 Super User 2024 Season 2 on at
    RE: PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'

    Hi Tino,

    What exactly got changed on this VM and did the DB sync work before correctly?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans