
I have a situation which I'd like to get some advice with to make sure I'm going down the correct path for resolution.
I have a custom entity with multiple lookups to the same parent record; similar to the way you can have many lookups to Contacts; one is Customer, one is another role, etc. Everything was fine with this until I attempted to import it into another environment. At that time I got this error:
I googled this and found references indicating this is a problem with the same lookup being used in the destination environment. One recommendation was to change the relationship type from 1:N to N:1. I'm not even sure how I would do that. The relationship type was automatic when adding a new attribute as a lookup to the parent.
Before I even try to figure that out, I'd like to confirm what is actually going on. Does anyone have experience with this?
Thank you!
*This post is locked for comments
I have the same question (0)I solved this issue. As I analyzed the problem I realized I had the same lookup attribute in both environments but with different relationship names -- exactly as the error mentioned. How did this happen one might ask, if all development is done in one environment? I am consistent to a fault in naming of components. At one point I created LookupA with RelationshipA in DEV and migrated it to QA. I then decided LookupA wasn't needed so deleted it from DEV. It never got deleted from QA. I then later decided it WAS needed (fickle, yes) and created it again with the same exact name (two months later I might add ;-)) but a different relationship name, so in INT I had LookupA with RelationshipB. In QA I had LookupA with RelationshipA. When we tried to migrate Dynamics caught it.
Sometimes just the exercise of typing out the question on this forum helps trigger methodical thinking. ;-)