Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Entity Store DMF2028 & DMF2028

(0) ShareShare
ReportReport
Posted on by 5

Hi,

We've got a problem with Entity Store in our client's instance. Synchronization sometimes works fine sometimes fails (no rule). When it fails, depending on the entity, we get DMF2020 or DMF2028 error with error stack:

Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type 'Microsoft.Dynamics.Ax.Xpp.ErrorException' was thrown.
at Dynamics.Ax.Application.DMFExtDBAxToExtDBExporter.handleException(Object _errorCode, Object ex) in DMFExtDBAxToExtDBExporter.handleException.xpp:line 21
at Dynamics.Ax.Application.DMFExtDBAxToExtDBExporter.createAndExecuteExportPackageToExtDB(DMFEntityDbGroupEntity _entityDbGroupEntity, String _eid, String _dmfSourceName, Object[] _queryData, String _syncTable, DMFRefreshType _syncType, NoYes _skipStaging, Boolean _isLastSync, Boolean , Boolean , Boolean , Boolean ) in DMFExtDBAxToExtDBExporter.createAndExecuteExportPackageToExtDB.xpp:line 101
at Dynamics.Ax.Application.DMFExtDBAxToExtDBExporter.createAndExecuteExportPackageToExtDB(DMFEntityDbGroupEntity _entityDbGroupEntity, String _eid, String _dmfSourceName, Object[] _queryData, String _syncTable, DMFRefreshType _syncType, NoYes _skipStaging, Boolean _isLastSync)
at Dynamics.Ax.Application.DMFExtDBAxToExtDBExporter.Run() in DMFExtDBAxToExtDBExporter.run.xpp:line 45
at Dynamics.Ax.Application.DMFExtDBSynchronizer.withOutStagingFullPush(String _dmfSyncGroupName, Boolean _isRunningInBatch, Int64 _batchId, Int64 _origSyncGroupExecutionLogId, Boolean _isGlobal, DMFEntityDbGroupEntity _enitityDBGroupEntity) in DMFExtDBSynchronizer.withOutStagingFullPush.xpp:line 55
at Dynamics.Ax.Application.DMFExtDBSynchronizer.synchronize(Object[] _arg) in DMFExtDBSynchronizer.synchronize.xpp:line 55
at Dynamics.Ax.Application.DMFExtDBSynchronizer.Run() in DMFExtDBSynchronizer.run.xpp:line 21
at Dynamics.Ax.Application.BatchRun.runJobStaticCode(Int64 batchId) in BatchRun.runJobStaticCode.xpp:line 54
at Dynamics.Ax.Application.BatchRun.runJobStatic(Int64 batchId) in BatchRun.runJobStatic.xpp:line 13
at BatchRun::runJobStatic(Object[] )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at BatchIL.taskThreadEntry(Object threadArg)

Instances:

Ax2012 CU12

SQL Server 12.0.4213.0

We already commented out the Line with entity name (in 2018):

 //ssisPkgHelper.set_DMFEntityName(_entityDbGroupEntity.EntityName);

During the process staging step is skipped, runned as full push.

Any ideas what can we do to fix that?

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,711 Super User 2024 Season 2 on at
    RE: Entity Store DMF2028 & DMF2028

    Hi Integris IT,

    CU12 is not the latest version. If the suggestion from Todd is not working, you can test the latest available kernel and application files and see if that solves the issue.

  • ToddB Profile Picture
    ToddB on at
    RE: Entity Store DMF2028 & DMF2028

    Hi Integris,

    The errors are:

    FailedToTruncateTheRecords = "DMF2020";

    FailedToGetTargetRowCount = "DMF2028";

    If you are still seeing issues you would want to take a trace and/or restart SSIS in order to help narrow down the issue and determine if it may be specific to one server.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans