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, ... / Sync error in D365FO
Finance | Project Operations, Human Resources, ...
Answered

Sync error in D365FO

(0) ShareShare
ReportReport
Posted on by Suren_G 252

Hi,

I am trying to upgrade the version of D365FO to the latest. Upgrade process is completed successfully, but I am getting the below error while on sync process in the application. Please let me know if there are any suggestions!

Severity Code Description Project File Line Suppression State
Error AND EXTENDEDDATATYPE = 'LEDGERDIMENSIONDEFAULTACCOUNT' 0
Error I.DIMENSIONDISPLAYVALUE, 0
Error ), 0), 0
Error I.INCLUDEINREPORT, 0
Error COALESCE(I.CONTINUEABSENCE, 0), 0
Error I.MAINACCOUNTDISPLAYVALUE <> '' 0
Error at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) 0
Error I.DataAreaId, 0
Error SELECT DISTINCT 0
Error I.OFFSETACCOUNTDISPLAYVALUE <> '' 0
Error JMGINCLUDEINREPORT = I.INCLUDEINREPORT, 0
Error ENUMVALUE, 0
Error [IF OBJECTPROPERTY(OBJECT_ID('HCMABSENCECODEENTITYDELETETRIGGER'), 'ISTRIGGER') = 1 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync() 0
Error HIERARCHYTYPE, 0
Error IF UPDATE(OFFSETACCOUNTDISPLAYVALUE) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options) 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.DataEntityTriggerSync.ThrowOnSqlExecuteException(SqlException e, String commandText) 0
Error I.OFFSETACCOUNTDISPLAYVALUE, 0
Error Inner Exception: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out 0
Error Error Number:-2,State:0,Class:11 0
Error AND ENUMNAME = '' 0
Error COALESCE(I.ABSENCECODE, ''), 0
Error I.PARTITION, 0
Error PARTITION, 0
Error IF UPDATE(MAINACCOUNTDISPLAYVALUE) 0
Error [IF OBJECTPROPERTY(OBJECT_ID('HCMABSENCECODEENTITYINSERTTRIGGER'), 'ISTRIGGER') = 1 0
Error COALESCE(I.COLUMN_, 0), 0
Error GROUP BY I.BACKGROUNDCOLOR, 0
Error DROP TRIGGER HCMABSENCECODEENTITYDELETETRIGGER 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.DataEntityTriggerSync() 0
Error I.ABSENCECODE, 0
Error INTEGRATIONSTRING = I.DIMENSIONDISPLAYVALUE 0
Error I.PARTITION 0
Error at Microsoft.Dynamics.AX.Framework.Database.Synchronize.SqlDdl.Run(SqlCommand command) 0
Error COALESCE(I.DESCRIPTION, ''), 0
Error I.MAINACCOUNTDISPLAYVALUE, 0
Error ), 0) 0
Error System.InvalidOperationException: Database execution failed: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 0
Error IF NOT EXISTS(SELECT 'ConfigKeyIsDisabled' FROM SYSCONFIG SC WHERE SC.CONFIGTYPE = 6 AND EXISTS (SELECT 'x' FROM CONFIGKEYIDTABLE CKIT WHERE SC.ID = CKIT.ID AND CKIT.NAME = '')) 0
Error ] 0
Error at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 0
Error JMGJOBID = I.JOBIDENTIFICATION, 0
Error ENUMNAME, 0
Error ) 0
Error EXTENDEDDATATYPE, 0
Error WHERE 0
Error -- Ensure dimension resolution is done for all accounts in field OFFSETACCOUNTDISPLAYVALUE 0
Error --- End of inner exception stack trace --- 0
Error I.MAINACCOUNTDISPLAYVALUE, 0
Error I.OFFSETACCOUNT, 0
Error Inner Exception: System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out 0
Error I.DESCRIPTION, 0
Error LEDGERDIMENSION = COALESCE(( 0
Error OFFSETLEDGERDIMENSION = COALESCE(( 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.DataEntityTriggerSync.ThrowOnSqlExecuteException(SqlException e, List`1 statements) 0
Error I.DIMENSION, 0
Error I.COLUMN_, 0
Error 'LEDGERDIMENSIONDEFAULTACCOUNT', 0
Error COALESCE(I.INCLUDEINREPORT, 0), 0
Error INTEGRATIONSTRING, 0
Error COALESCE(( 0
Error AND DATAAREAID = I.DataAreaId 0
Error I.ICON, 0
Error , 0
Error JMGICONID = I.ICON, 0
Error I.CONTINUEABSENCE, 0
Error JMGABSENCELETTERCODE = I.LETTERCODE, 0
Error COALESCE(I.DAYS, 0), 0
Error AND HIERARCHYNAME = '' 0
Error JMGCONTINOUSABSENCE = I.CONTINUEABSENCE, 0
Error JMGCOLINDEX = I.COLUMN_, 0
Error FROM INSERTED I 0
Error at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() 0
Error 18, 0
Error COALESCE(I.METHOD, 0), 0
Error DESCRIPTION = I.DESCRIPTION, 0
Error [CREATE TRIGGER HCMABSENCECODEENTITYDELETETRIGGER ON HCMABSENCECODEENTITY INSTEAD OF DELETE AS BEGIN 0
Error AND EXTENDEDDATATYPE = 'LEDGERDEFAULTDIMENSIONVALUESET' 0
Error INTEGRATIONSTRING = I.OFFSETACCOUNTDISPLAYVALUE 0
Error I.METHOD, 0
Error DATAAREAID, 0
Error HRMABSENCECODEID = I.ABSENCECODE, 0
Error FORECOLOR = I.TEXTCOLOR, 0
Error INSERT INTO HRMABSENCECODE (BACKGROUNDCOLOR,DESCRIPTION,FORECOLOR,HRMABSENCECODEGROUPID,HRMABSENCECODEID,JMGABSENCELETTERCODE,JMGABSENCEMETHODENUM,JMGABSENCEPAYCTYPE,JMGABSENCEPAYQTY,JMGCOLINDEX,JMGCONTINOUSABSENCE,JMGICONID,JMGINCLUDEINREPORT,JMGJOBID,JMGSIGNIN,DEFAULTDIMENSION,LEDGERDIMENSION,OFFSETLEDGERDIMENSION,I.RECVERSION,I.DATAAREAID,I.PARTITION) 0
Error I.JOBIDENTIFICATION, 0
Error COALESCE(I.REGISTRATION, 0), 0
Error AND SECONDARYENUMVALUE = 1 0
Error UPDATE HRMABSENCECODE SET 0
Error INTEGRATIONSTRING = I.MAINACCOUNTDISPLAYVALUE 0
Error DELETE HRMABSENCECODE FROM HRMABSENCECODE JOIN DELETED D ON D.RECID = HRMABSENCECODE.RECID 0
Error AND HIERARCHYTYPE = 17 0
Error ClientConnectionId:3c02c7f7-d320-4fae-bda0-ac5b8554038e 0
Error DROP TRIGGER HCMABSENCECODEENTITYINSERTTRIGGER 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync() 0
Error at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) 0
Error COALESCE(I.TEXTCOLOR, 0), 0
Error SELECT TOP 1 RESOLVEDREFERENCE 0
Error JMGABSENCEPAYQTY = I.DAYS, 0
Error I.ABSENCEGROUP, 0
Error DEFAULTDIMENSION = COALESCE(( 0
Error I.REGISTRATION, 0
Error DROP TRIGGER HCMABSENCECODEENTITYUPDATETRIGGER 0
Error at Microsoft.Dynamics.AX.Framework.Database.Tools.DataEntityTriggerSync.RunSync() 0
Error END 0
Error HIERARCHYNAME, 0
Error I.MAINACCOUNT, 0
Error I.OFFSETACCOUNTDISPLAYVALUE, 0
Error JMGABSENCEMETHODENUM = I.METHOD, 0
Error 0, 0
Error WHERE 0
Error at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 0
Error I.PARTITION FROM INSERTED I 0
Error [IF OBJECTPROPERTY(OBJECT_ID('HCMABSENCECODEENTITYUPDATETRIGGER'), 'ISTRIGGER') = 1 0
Error 0, 0
Error '', 0
Error COALESCE(I.JOBIDENTIFICATION, ''), 0
Error COALESCE(I.ABSENCEGROUP, ''), 0
Error COALESCE(I.PAYTYPE, ''), 0
Error AND HIERARCHYTYPE = 18 0
Error I.PAYTYPE, 0
Error I.LETTERCODE, 0
Error SECONDARYENUMVALUE 0
Error JMGSIGNIN = I.REGISTRATION 0
Error FROM DIMENSIONDATAENTITYSFKCACHE 0
Error [CREATE TRIGGER HCMABSENCECODEENTITYUPDATETRIGGER ON HCMABSENCECODEENTITY INSTEAD OF UPDATE AS BEGIN 0
Error AND ENUMVALUE = 0 0
Error HRMABSENCECODEGROUPID = I.ABSENCEGROUP, 0
Error BEGIN 0
Error SELECT COALESCE(I.BACKGROUNDCOLOR, 0), 0
Error I.DAYS, 0
Error at Microsoft.Dynamics.AX.Framework.Database.Synchronize.SqlExecute.Execute(IEnumerable`1 commands) 0
Error COALESCE(I.ICON, 0), 0
Error I.DATAAREAID, 0
Error JMGABSENCEPAYCTYPE = I.PAYTYPE, 0
Error ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception: The wait operation timed out 0
Error I.TEXTCOLOR, 0
Error 1 0
Error -- Ensure dimension resolution is done for all accounts in field MAINACCOUNTDISPLAYVALUE 0
Error at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 0
Error COALESCE(I.LETTERCODE, ''), 0
Error [CREATE TRIGGER HCMABSENCECODEENTITYINSERTTRIGGER ON HCMABSENCECODEENTITY INSTEAD OF INSERT AS BEGIN 0
Error IF (UPDATE(BACKGROUNDCOLOR) OR UPDATE(DESCRIPTION) OR UPDATE(TEXTCOLOR) OR UPDATE(ABSENCEGROUP) OR UPDATE(ABSENCECODE) OR UPDATE(DIMENSION) OR UPDATE(LETTERCODE) OR UPDATE(METHOD) OR UPDATE(PAYTYPE) OR UPDATE(DAYS) OR UPDATE(COLUMN_) OR UPDATE(CONTINUEABSENCE) OR UPDATE(ICON) OR UPDATE(INCLUDEINREPORT) OR UPDATE(JOBIDENTIFICATION) OR UPDATE(REGISTRATION) OR UPDATE(MAINACCOUNT) OR UPDATE(OFFSETACCOUNT) OR UPDATE(DIMENSIONDISPLAYVALUE) OR UPDATE(DATAAREAID) OR UPDATE(MAINACCOUNTDISPLAYVALUE) OR UPDATE(DATAAREAID) OR UPDATE(OFFSETACCOUNTDISPLAYVALUE) OR UPDATE(DATAAREAID)) 0
Error BACKGROUNDCOLOR = I.BACKGROUNDCOLOR, 0
Error FROM INSERTED I WHERE I.RECID = HRMABSENCECODE.RECID 0
Error INSERT INTO DIMENSIONDATAENTITYSFKCACHE ( 0
Error syncengine.exe exited with code -1. 1

Thanks!

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,193 Super User 2025 Season 2 on at
    RE: Sync error in D365FO

    Hi Suren,

    If your question has been answered, would you mind to mark the answer(s) which helped you? Then the question will get the status answered which would also be beneficial for other users looking for similar answers.

  • Suren_G Profile Picture
    Suren_G 252 on at
    RE: Sync error in D365FO

    Hi All,

    Increasing the RAM of the VM resolved the issue. Thanks for the suggestions!

    Thanks!

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 298,193 Super User 2025 Season 2 on at
    RE: Sync error in D365FO

    Hi Suren,

    If you still have the issue, then monitor the system resources during the sync process. Then you can see if it is related to lack of CPU, Disk I/O or memory.

  • Suggested answer
    Rahul Mohta Profile Picture
    Rahul Mohta 21,030 on at
    RE: Sync error in D365FO

    also if you adding new unique indexes and data does not support it then also it could happen

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at
    RE: Sync error in D365FO

    Hi Suren_G,

    You could try to make a full sync from command line with higher timeouts and use -sqltimeout parameter to specify higher timeout (try to put 360 minutes).

    axdynamx.blogspot.com/.../how-to-synchronize-manually-database.html

  • Suren_G Profile Picture
    Suren_G 252 on at
    RE: Sync error in D365FO

    Hi Sergei,

    I am trying to run from VS. The execution takes more time than usual.

    Thanks!

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at
    RE: Sync error in D365FO

    Hi Suren_G,

    Are you running syncronization from VS or it's a part of LCS deployment?

  • Suren_G Profile Picture
    Suren_G 252 on at
    RE: Sync error in D365FO

    Hi Sergei,

    Thanks for your response! It is a devbox and I do not see any backend active queries running, but still the same issue persist.

    Thanks!

  • Suggested answer
    Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,093 on at
    RE: Sync error in D365FO

    Hi Suren_G,

    Is it devbox or sandbox environment?

    According to the error, it's a timeout and it could happen during synchronization when the SQL statement is running for a long time. I suggest you check from SQL backend active queries first and if you see something similar is running wait until competition and retry the sync step again.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Our Community Code of Conduct has been updated!

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 895

#2
Sohaib Cheema Profile Picture

Sohaib Cheema 811 User Group Leader

#3
André Arnaud de Calavon Profile Picture

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

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans