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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Entity Store sync: exc...
Microsoft Dynamics AX (Archived)

Entity Store sync: exception in createAndExecuteExportPackageToExtDB()

(0) ShareShare
ReportReport
Posted on by Community Member

A little help if you can please … We have published several tables, for example, this one ..

 

Application module (General ledger), Staging table (DMFMainAccountEntity), this was published successfully to a DSN type = System DSN, DSN Location = SQL with the correct connection string etc.

 

Next > Data import export framework > Entity Store > Manage refresh schedule

Create a new Configuration group / entities / schedule and run in batch

 

This partially worked .. Having looked at the Execution history from the processing group, the staging details are fine. 2621 records created with the staging status of ended ..

There is a secondary job ID that hasn't run .. Looking into the batch history log we get this ..

'2621' 'Main account' record(s) inserted in staging

Method 'Microsoft.Dynamics.AX.Framework.Tools.DMF.ServiceProxy.DMFServiceReference.DMFEntityDBHelper.set_DMFEntityName' not found.

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 20

   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 81

   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 37

   at Dynamics.Ax.Application.DMFExtDBSynchronizer.withStagingIncrementalPush(String _dmfSyncGroupName, Boolean _isRunningInBatch, Int64 _batchId, Int64 _origSyncGroupExecutionLogId, Boolean _isGlobal, DMFEntityDbGroupEntity _enitityDBGroupEntity) in DMFExtDBSynchronizer.withStagingIncrementalPush.xpp:line 275

   at Dynamics.Ax.Application.DMFExtDBSynchronizer.synchronize(Object[] _arg) in DMFExtDBSynchronizer.synchronize.xpp:line 62

   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)

Any advise would be appreciated from me and our team

Kind regards

Martin

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Entity Store push has a couple of problems.

    Comment out the ssisPkgHelper.set_DMFEntityName line in AOT\Classes\DMFExtDBAxToExtDBExporter.createAndExecuteExportPackageToExtDB, generate Full CIL and restart the AOS instances.

    There are some other problems as well, have been planning to write a blog article on Entity store for a long time - maybe it is becoming due now :)

  • Community Member Profile Picture
    Community Member on at

    Hi Vilmos, and thanks for the reply.

    We have done as advised and now we do not get any error messages ... however, we still have the initial issue whereby zero records have been published.

    The warnings are:

    '2621' 'Main account' record(s) inserted in staging

    0 record(s) inserted,'0' record(s) updated to entity Main account

    Can you offer any more help on this please?

    Kind regards

    Martin

  • Community Member Profile Picture
    Community Member on at

    Pause on this .. it might be user error, lol.... Back in a bit as I need to repeat this

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    Thank you .. this did help with the initial problem,

  • RahulGupta1985 Profile Picture
    RahulGupta1985 10 on at

    Hi Martin, are you able to run the Manage refresh schedule by batch job. When I am trying to do same, I am landing into same error as you mentioned earlier on this conversation. When I run manually (without batch job) data entity perfectly works, it inserts data into staging and entity store both but when I am setting same entity group for batch job then this is inserting only staging and saying "0" record inserted to entity store. Your help on this issue will be greatly appreciated.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans