Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / BPErrorEDTNotMigrated
Finance forum
Suggested answer

BPErrorEDTNotMigrated

(0) ShareShare
ReportReport
Posted on by CU04051814-0
Hi,

I got this BP warning below in my entity staging table:

BPErrorEDTNotMigrated: The relation under the extended data type (EDT) 'XYZ' must be migrated to table relation. Consider using EDT relation migration tool.   
 
1. Is it enough to just create a new relation?-- as the BP warning disappears once i add it
2. As In some places, i read that we need to add the relation, in addition to mark /ignore EDT relation/ on the staging table field as true, is this needed?
3.  And some said, we need to add the relation, in addition to filling /source EDT/ on the relation itself, is this needed?
4. when copying the relation from the actual table to the entity staging table, do i need to remove the /onDelete/ property and the index property?
5. on the relation, there is a property, called /EDT Relation/ do i need to change this one to true or false? 
 
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 295,383 Super User 2025 Season 1 on at
    BPErrorEDTNotMigrated
    Hi,
     
    When replying the first time, I didn't check the details in Visual Studio. For the relations on staging tables, you can set a property named validate. With this property you can manage if you allow non-existing values in staging tables. When copying to the target, the values, like a valid customer account number should be verified. I don't know where or when the IgnoreEDT on field level is used. I never looked at that detail myself.
     
    3. Thanks for the clarification. You can have a look at the CustTable as an example where it is filled for the Currency relation, but not for CustDirectDebitMandate. I haven't checked it recently, but from what I remember, the EDT relation migration tool did manage the property value.
     
    4. I missed a part of your question, I noticed now. For foreign key relations, you should not remove the index value.
     
    5. See my reply to question 3. As far as I remember this property was managed by the migration tool for review purposes only. The value itself doesn't have any impact on the functionality.
     
    6. As there are thousands of data entities, I don't know the answer. You can have a look at e.g. the next blog to learn more about the cardinality: Table cardinality explained – DynamicsFox
     
     
     
     
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 295,383 Super User 2025 Season 1 on at
    BPErrorEDTNotMigrated
    Hi,
     
    I will try to help you but also need clarification on one question. Note that Microsoft changed table relations from EDT to tables. The current existing EDT relations are all legacy.
     
    1) Yes, adding the relation on the table instead of the EDT will solve the BP error. 
    2) On staging tables, it would be recommended to allow for all values. In that case, the details will load in the staging table and the copy to target process will then check for valid values. You can then correct the data in the staging table and it is easier for troubleshooting. If you don't allow incorrect values, loading the data in the staging table will be blocked.
    3) Can you explain this question with e.g. an example/screenshot?
    4) Yes. It does not make sense to have delete actions on the staging table as there is a separate cleanup job for data management history.
    5) The value No is recommended.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans