This article has been archived. It is offered "as is" and will no longer be updated.
When you try to use the Advanced Find function to add contacts to a marketing list in Microsoft Dynamics CRM 4.0, you receive the following error message:
An error has occurred.
This problem occurs because Microsoft Dynamics CRM 4.0 uses the FetchXml statement when you add contacts to a marketing list. The FetchXml statement is also used to retrieve records in the Advanced Find window. Microsoft Dynamics CRM 4.0 uses this statement to retrieve all entity identifiers (IDs) that are returned from a query. A view is modified to include a column from a related entity. Therefore, Microsoft Dynamics CRM 4.0 tries to add an attribute from the related entity to the ColumnSet property of a queried entity. However, Microsoft Dynamics CRM 4.0 cannot add child attributes to the ColumnSet property of a primary entity.
This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
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:
824684Description of the standard terminology that is used to describe Microsoft software updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards