Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

(3) ShareShare
ReportReport
Posted on by Rudi Hansen 4,020
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
  • Rudi Hansen Profile Picture
    Rudi Hansen 4,020 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 13,264 Super User 2024 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 6,695 Super User 2024 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 6,695 Super User 2024 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,020 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 13,264 Super User 2024 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
  • andreasraithel Profile Picture
    andreasraithel 4,839 Super User 2024 Season 2 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

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 Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans