locked
Errorcode 0x80044150 :Cannot insert duplicate key row in object: Importing Solution Failed after Upgrade to 2011 RRS feed

  • Question

  • Hi All,

    Scenario: I upgraded our Production DB from CRM 4.0 to CRM 2011. I am trying to import Dev Solution to CRM 2011 Production, the following error is occuring.

    "Failure: account: A SQL Server error occurred. Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions or contact your organization's Microsoft Dynamics CRM Administrator. Finally, you can contact Microsoft Support."

    Log Error:

    <entity LocalizedName="Account"
    OriginalName="Account"
    Description="Person or business to which the salesperson tries to sell a product or service. The company billed in business transactions.
    " id="Account" processed="true">
    <result result="failure" errorcode="0x80044150"
    errortext="Cannot insert duplicate key row in object 'MetadataSchema.AttributeLookupValue' with unique index 'NDX_AttrLookupValAttrIdEntityIdCompState'. The duplicate key value is (3343d9f8-8b3b-45de-881f-4501a34e29de, 8, 0, fd140aae-4df4-11dd-bd17-0019b9312238, Jan  1 1900 12:00AM).&#xD;&#xA;The statement has been terminated." datetime="15:51:00.46" datetimeticks="634830618604685149" /></entity>

    -------------------------------------------------

    <entity LocalizedName="Contact" OriginalName="Contact" Description="Person with whom a business unit has a relationship. For example, a customer, a supplier, or a colleague. " id="Contact" processed="true"><result result="failure" errorcode="0x80044150" errortext="Cannot insert duplicate key row in object 'MetadataSchema.AttributeLookupValue' with unique index 'NDX_AttrLookupValAttrIdEntityIdCompState'. The duplicate key value is (6c720ad6-f488-4b2f-8a71-7204c6ae40f4, 8, 0, fd140aae-4df4-11dd-bd17-0019b9312238, Jan  1 1900 12:00AM).&#xD;&#xA;The statement has been terminated." datetime="13:07:48.10" datetimeticks="634834840681022147" /></entity>

    -------------------------------------------------------

    So what I did is 'I commented OwnerId (which is causing error) in both Account and Contact Entity in the Dev Solution XML and the Importing solution is successfull.

    But I would like to know whether it is supported method or not?

    Does it effect anything on the Production DB?

    Another Method: Can anyone please let me know in which (Production DB or Solution) duplication occurs. If yes, Do I need to remove the duplicates in the DB?

    Thanks in Advance.

    RVB


    Rudravarma Batta

    Wednesday, September 19, 2012 12:52 PM