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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Deleting PowerMailChimp solution: A relationship exists that relates to this Attribute and delete cascade is restricted

(0) ShareShare
ReportReport
Posted on by

Hi, 

I'm trying to delete PowerMailChimp solution but I get this error: 

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Cannot delete Attribute with id 56d0dec2-0061-e511-80e0-3863bb347ba8 because a Relationship with id e7a8ac27-fc65-4a43-9f6d-1bc6645f7749 exists that relates to this Attribute and delete cascade is restrictedDetail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ErrorCode>-2147188477</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>Cannot delete Attribute with id 56d0dec2-0061-e511-80e0-3863bb347ba8 because a Relationship with id e7a8ac27-fc65-4a43-9f6d-1bc6645f7749 exists that relates to this Attribute and delete cascade is restricted</Message>
<Timestamp>2016-02-15T11:03:02.0313031Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>

I searched through all the attributes of all entities in my CRM using a C# application and it turned out that this attribute is : po_po_mailchimpcampaign_listId. There is an N:N relationship "po_po_mailchimpcampaign_list" between PowerMailChimp Blast (mailchimpcampaign) entity and MarketingList (list) entity. But this relationship Id is different from the relationship id mentioned in the error above. 

I tried to lookup dependencies for this relationship and the only dependency I could find that prevent deleting that relationship was that of the Main Form of Mail Chimp Blast entity, this form contains an Associated List View of MarketingList. I cannot remove the Associate View from the Form as the form is not customizable. 

I looked up all the relationships in all my CRM entities and none of the relationships had this Id in the error. I contacted PowerObjects support and they said that it's a CRM error.

How can I fix this issue ? Could that attribute be used some where else and be causing the problem ? 

Would greatly appreciate your help. 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    alf Profile Picture
    17,915 on at

    HI,

    Yeah - The crm solution system can sometimes have small hiccups. What version of crm are you using?  If CRM Online you can open a ticket with Microsoft. We have had clients were Microsoft had to run a sql update script to get rid of the phantom dependencies.

    The good news is that in crm 2016 we have a lot more granular control and there is a good chances most of the small solution issues we have seen are a thing of the past.......

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans