Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you merge accounts or contacts in Microsoft Dynamics CRM 3.0: "A record with these values already exists. A duplicate record cannot be created"

Error message when you merge accounts or contacts in Microsoft Dynamics CRM 3.0: "A record with these values already exists. A duplicate record cannot be created"

View products that this article applies to.

Symptoms

When you merge accounts or contacts in Microsoft Dynamics CRM 3.0, you receive the following error message:
A record with these values already exists. A duplicate record cannot be created. Select one or more unique values and try again.
This problem occurs if the following conditions are true:
  • One of the accounts or contacts contains one or more addresses in the More Addresses section of the record.
  • The value in the AddressNumber 2 field for the account or contact was deleted.

↑ Back to the top

Resolution

This problem is fixed in Microsoft Dynamics CRM 3.0 Update Rollup 2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
927751 Update Rollup 2 is available for Microsoft Dynamics CRM 3.0

↑ Back to the top

More information

To verify that the value in the AddressNumber 2 field was deleted, follow these steps:
  1. Open SQL Query Analyzer on the server that is running Microsoft SQL Server and that stores the Microsoft Dynamics CRM databases.
  2. Run the following query against the OrganizationName_MSCRM database.
    select * from customeraddressbase where parentid='<AccountID>'
    Notes
    • The OrganizationName placeholder represents the organization name.
    • The <AccountID> placeholder represents the account or contact identifier of the master record that you try to merge.
  3. View the results of the query.

    Note If the value in the AddressNumber 2 field was deleted, the value in the AddressNumber column is not 2.

↑ Back to the top

References

For more information about the terminology that is used to describe Microsoft software updates, click the following article numbers to view the articles in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

↑ Back to the top

Keywords: KB928958, kbmbsmigrate, kbqfe, kbhotfixserver, kberrmsg

↑ Back to the top

Article Info
Article ID : 928958
Revision : 4
Created on : 7/17/2007
Published on : 7/17/2007
Exists online : False
Views : 340