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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Problem with Data mana...
Finance | Project Operations, Human Resources, ...
Suggested answer

Problem with Data managment Import after updating DataEntityView

(4) ShareShare
ReportReport
Posted on by Rudi Hansen 4,051
I am having a problem with Import after making changes to a Composite Data Entity.
 
The customer has a custom Composite Data Entity that used the Depriciated Data Entity SalesOrderHeaderV2Entity.
So on the Composite Data Entity, I changed the Data Entity SalesOrderHeaderV2Entity to SalesOrderHeaderV3Entity, and I also changed SalesOrderLineV2Entity to SalesOrderLineV3Entity.

I did a build and Sync Database, and also ran "Truncate entity list" and "Refresh entity list"
 
Then I tried importing an xml file that the customer used before, but I got this error:
<?xml version="1.0"?><Errors><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.AddDataFlowComponent(Package _Package)
   at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFPackageControllerCompositeEntity.CreateAndExecutePackage()
   at DMFExecutePackage.PackageCreator.processCompositeEntity()
   at DMFExecutePackage.Program.Main(String[] args)</Description></Error><Error><ErrorCode>-2146233088</ErrorCode><SubComponent>Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper</SubComponent><Description>DMF2060 -    at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package)
   at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.AddDataFlowComponent(Package _Package)</Description></Error><Error><ErrorCode>-1073676279</ErrorCode><SubComponent>Microsoft.SqlServer.DTSPipelineWrap</SubComponent><Description>Exception from HRESULT: 0xC0010009 -    at Microsoft.SqlServer.Dts.Pipeline.Wrapper.IDTSOutputColumnCollection100.get_Item(Object Index)
   at Microsoft.Dynamics.AX.Framework.Tools.DMF.SSISHelper.DMFXmlCompositePackageImport.UpdateSourceProperties(IDTSComponentMetaData100 flatFileSourceComponent, CManagedComponentWrapper srcFlatFileInstance, String name, Package _Package)</Description></Error></Errors>
Please ensure that the schema of the mapping matches that of the staging table and the import file. It is essential to verify that the import file contains the same fields as specified in the mapping for the data entity. If there are any columns set in the mapping that are not present in the import file, you have two options: either provide a value for the column in the import file, or remove the column from the mapping altogether. Additionally, if there is a field present in the mapping that does not exist in the staging table, it should be removed from the mapping to resolve the issue.
'0' 'CustomerSalesOrderCompositeEntity' record(s) inserted in staging
 
I have tried going through all the Mappings on the project and everything seems to be ok, and I also tried to Export the package from production, and go through the files in it making sure that any references to the V2 entities was changed to V3
Perhaps I also have to mention that the package contains an xsl file with transforms, and I also checked that file and everything seems to be fine.

So I am kind of stuck, since the error message mentions that perhaps I am having a problem with the mappings or missing fields, but does not mention witch mappings of field might be the problem.
And I have checked in the mappings that the fields there do exist.

Is there any way of debugging the process to get som actual help to what the problem might be?

 
Categories:
Dynamics 365 Finance
I have the same question (1)
  • Suggested answer
    ssc121 Profile Picture
    ssc121 20 on at
    Problem with Data managment Import after updating DataEntityView
    Hi, 
     
    Probably check the staging table here. You can also skip staging table it not at all required. 
  • Sanny Profile Picture
    Sanny 10 on at
    Problem with Data managment Import after updating DataEntityView
    Hi, I have the same issue. Was there something that solved this issue?
  • Rudi Hansen Profile Picture
    Rudi Hansen 4,051 on at
    Problem with Data managment Import after updating DataEntityView
     
    I have looked at the files in the package, and I not so far been able to find any fields in them that is not in the staging tables.
     
    The CustomerSalesOrderCompositeEntity.xml has no fields in it that does not exist in the staging tables.
     
    I am currently looking through the tranform file, and it also does not look like that one had any problems.
    Resources\CustomerSalesOrderCompositeEntity\{F23A1DD1-D257-4CBD-A971-B66AE5267894}_CustomerSalesOrderCompositeEntityImportTransformV9.xsl
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,603 Super User 2025 Season 2 on at
    Problem with Data managment Import after updating DataEntityView
    Hi,
    According to the latest error message, as Waed mentioned, please check the mapping in the import file. The error could be related to fields that lack values in the staging table, which might be causing the import to fail.
  • Waed Ayyad Profile Picture
    Waed Ayyad 8,776 Super User 2025 Season 2 on at
    Problem with Data managment Import after updating DataEntityView

    Hi, 

    Is your issue resolved? If yes, mark the answers that helped you as verified. 

    Thanks,

    Waed Ayyad

  • Suggested answer
    Waed Ayyad Profile Picture
    Waed Ayyad 8,776 Super User 2025 Season 2 on at
    Problem with Data managment Import after updating DataEntityView
    Hi,
     
    Did you check the mapping in DMF and the Fields on your XML file?
     
    Try to export one Sales order and then compare it with your XML file that you want to import, also you should make sure about number seq fields like sales order number. If you don't set the value of it in the XML, you should change it to auto generated in the Mapping.
     
     

    Thanks,

    Waed Ayyad

    If this helped, please mark it as "Verified" for others facing the same issue

     
     
  • Rudi Hansen Profile Picture
    Rudi Hansen 4,051 on at
    Problem with Data managment Import after updating DataEntityView
    Alireza:
    The DMF Service is running, and the only thing I can find in the page you reference to is a description of the error i get.
    DMF2060 A mapped field isn't present in the import file or staging table. Remove the unused field from the mapping, or include it in the import file. When you customize an entity, you must add fields to both the entity view and its staging table.
     
    And again, that is not really helpful since it just says basically something is wrong, but not what and how to fix it.
    As I said I really need som help on how to get a more detailed description of what fields are the problem, some sort of way to debug the error.
     
    Andreasraithel:
    I have tried but the fields i have in my XML file are all needed and it also looks like they all ether exists in the staging tables, or has transforms to the right fields in the transforms file.
  • Suggested answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 14,603 Super User 2025 Season 2 on at
    Problem with Data managment Import after updating DataEntityView
    Hi,

    The error message you provided is related to the DMF service connection. You need to verify if the service is up and running.

    The other issue is already addressed in Microsoft Learn. You can find more details here:

     Data management error descriptions and known limitations - Finance & Operations | Dynamics 365 | Microsoft Learn
  • Andreas Raithel Profile Picture
    Andreas Raithel 4,961 Moderator on at
    Problem with Data managment Import after updating DataEntityView
    Hy,
    my experience with the SO composite entity is quite the same and time consuming.
    After a long period of try and error I had sucess with the SalesOrderHeaderV3Entity and SalesOrderLineHeaderV2Entity.
    Reduced to a less fields as possible, and I set SalesOrdreNumber, LineNumber and INVENTORYLOTID to Autogenerated in the project.
     
    Hope this helps.
     
     

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

Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

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

#1
Alireza Eshaghzadeh Profile Picture

Alireza Eshaghzadeh 799 Super User 2025 Season 2

#2
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 757 Super User 2025 Season 2

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 751 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans