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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / PostServiceSync error ...
Finance | Project Operations, Human Resources, ...
Suggested answer

PostServiceSync error Invalid column name 'DEFERREDOPERATIONSTATE'

(0) ShareShare
ReportReport
Posted on by Tino 152

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.

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,233 Super User 2025 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?

  • Suggested answer
    Arunraj Rajasekar Profile Picture
    Arunraj Rajasekar 1,743 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?

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

    Hi Arunraj,

    yes, but I could not find i there.

  • Tino Profile Picture
    Tino 152 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.

  • Suggested answer
    CU07050638-0 Profile Picture
    CU07050638-0 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.
     
     
     

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…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

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

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 582 Most Valuable Professional

#3
CU05031448-0 Profile Picture

CU05031448-0 526

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans