Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Suggested answer

Importing a solution error

Posted on by

Hi,

I'm trying to import a solution and getting the following error on item type 'Dependencies Calculation':

Cannot insert duplicate key row in object 'dbo.DependencyBase' with unique index 'ndx_UniqueDependencyNodes'. The duplicate key value is (add52354-c1db-49fc-b0c7-67729a502437, ca357157-0696-4b68-a307-011621437c8d). The statement has been terminated.

Is someone familiar with this error?

Thanks

  • Suggested answer
    yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: Importing a solution error

    Hi Jason,

    This post worked for me. https://community.dynamics.com/crm/f/117/t/207666

    You need to remove the part in red below from your customization.xml file.

    You might have more than one section like this in your customization.xml file, but you need to find the one that is related to the entity or attribute that is causing the error.

         <CustomControlDefaultConfigs>

            <CustomControlDefaultConfig>

              <PrimaryEntityTypeCode>10073</PrimaryEntityTypeCode>

     <CustomControlDefaultConfigId>{bd771d8c-2cd6-e511-80d4-00155d0e4417}</CustomControlDefaultConfigId>

                 <ControlDescriptionXML>

                  <controlDescriptions />

              </ControlDescriptionXML>

              <IntroducedVersion>1.0</IntroducedVersion>

            </CustomControlDefaultConfig>

          </CustomControlDefaultConfigs>

  • RE: Importing a solution error

    Was anyone able to find a solution to this?

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing a solution error

    Microsoft support solved it for me but it took them about a month.

  • Suggested answer
    Yuri Porto Profile Picture
    Yuri Porto on at
    RE: Importing a solution error

    I have news.

    We tried to reimplant the solution without success. After much research, the architect of our team found a post in Turkish that contains the solution to the problem.
    The following link: https://yazbunu.wordpress.com/2013/05/10/dependencybase-index-hatasi/

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing a solution error

    I deleted and reuploaded a backup of the "broken" solution. This did the trick for me.

    But I also got an email from Microsoft this morning that they had problems with my instance of dynamics 365 yesterday when the error occurred

  • Yuri Porto Profile Picture
    Yuri Porto on at
    RE: Importing a solution error

    Hi Guys, 

    I'm having a problem, someone has already been able to get around this situation???

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Importing a solution error

    Any update on this one?

  • yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: Importing a solution error

    I'm facing the same issue.

    We are using CRM 2016.

    The reference key values are not present in the customization.xml file, so I can't remove them.

    Still searching!

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: Importing a solution error

    Hi may I ask what version of CRM your on? The cause is likely to be related to a lookup or Subgrid referencing a non-existing view in your Target CRM. You can try removing the reference from the solution Or Try removing all SubGrids from the form giving the error?

    Best Wishes, Raz

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,995 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,610 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans