"System.Data.SqlClient.SqlException: Subquery returned more than 1 value" error message when you try to use the Advanced Find option to add members to a marketing list in Microsoft Dynamics CRM 4.0

SYMPTOMS
When you try to use the Advanced Find option to add members to a marketing list in Microsoft Dynamics CRM 4.0, you receive the following error message:
System.Data.SqlClient.SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
This problem occurs if the following conditions are true:
  • The number of the members that you try to add is larger than the number of members that the view page can display.
  • The members are shared with the user who creates the marketing list.
  • Your sharing rights differ from the sharing rights of the user who creates the marketing list.
RESOLUTION
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


Note This problem was originally fixed in Update Rollup 13 for Microsoft Dynamics CRM 4.0.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2267499 Update Rollup 13 for Microsoft Dynamics CRM 4.0 is available
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about Microsoft Business Solutions CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards
Properties

Article ID: 2306930 - Last Review: 09/23/2010 17:17:00 - Revision: 1.0

Microsoft Dynamics CRM 4.0

  • kbqfe kbfix kbexpertiseinter kbmbsmigrate kbsurveynew kberrmsg KB2306930
Feedback