Hi,

I'm getting an error when adding users to a marketing list. Below is the error I get when I run a trace. The users just get an error message saying an error has occured.

The error seems to appear when I'm using Advanced Find to add the members and then choose "Add all the members returned by the query". If I instad choose "Add selected members" where I have selected all members, then it works fine.

The Saved View finds contacts based on some PArent Account picklist values. I have narrowed it down to happen when I have selected one specific value from that picklist. This value returns 64 contact records, but when I run the query in SQL and look at the returned values I can't see what should be different for any of those. There doesn't seems to be any dublets or anything.

This is the error from the Trace file:

[2010-07-05 23:21:13.8] Process: w3wp |Organization:f328b8e3-433a-4e03-b1ff-f10125564c26 |Thread: 1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ListAddPage.ConfigureForm
>ListAddPage.ConfigureForm There was an error while trying to execute the list members addition code.
Error Message: Exception has been thrown by the target of an invocation.
Stack Trace:
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

.....

Microsoft.Crm.Application.Platform.List.AddMembersByFetchXml(String listId, String fetchXml)
at Microsoft.Crm.Application.Pages.MA.ListsDlgs.ListAddPage.ConfigureForm()
[2010-07-05 23:21:13.8] Process: w3wp |Organization:f328b8e3-433a-4e03-b1ff-f10125564c26 |Thread: 1 |Category: Application |User: 00000000-0000-0000-0000-000000000000 |Level: Error | ErrorInformation.LogError
>MSCRM Error Report:
--------------------------------------------------------------------------------------------------------
Error: Exception of type 'System.Web.HttpUnhandledException' was thrown.

Error Message: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Error Details: Exception of type 'System.Web.HttpUnhandledException' was thrown.

Source File: Not available

Line Number: Not available

Request URL: http://Myservername.com:5555/Orgname/MA/Lists/ListQualificationdlg/dlg_List_add.aspx?itemObjectId={BB556C06-FE83-DF11-823C-005056A42DD2}&iObjType=2&itemObjectTypeCode=4300&iTotal=1&savedQueryId={B60059B9-2E88-DF11-823C-005056A42DD2}&savedQueryType=4230&isDirty=false&sInvokeType=lqAdd&iOption=2&iViewType=1039

Stack Trace Info: [SqlException: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.]
....

After some investigation, I found that it's caused by two specific contacts who is linked to a company that is shared with two Teams. If the user is member of both of these Teams, he get the error, but if I remove him from one of the Teams it works ok.
It seems like the error has been introduced with RollUp 11.