Error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >=, when refreshing email list

When refreshing email list we receive the following error message:

Error refreshing list. Details: [System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Runtime.InteropServices.COMException: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. Native error:512 [Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared. Native error:16945 at Blackbaud.RE7Service.MasterService.HandleRequest(Object oRequest, IRequestHandler oHandler, Boolean bUsesQuex) at Blackbaud.RE7Service.MasterService.GetPagedConstitData(GetPagedConstitDataArgs args) --- End of inner exception stack trace --- at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Blackbaud.Web.Content.Core.RE7Service.MasterService.GetPagedConstitData(GetPagedConstitDataArgs args) at Blackbaud.Web.Content.Core.Data.RecordSearch.GetPublicConstitResultsPage(Int32 pageNumber, Int32& numberFetched, Boolean recursive) at Blackbaud.Web.Content.Core.Data.RecordSearch.GetResultsPage(Int32 pageNumber, Int32& numberFetched, Boolean recursive, Boolean bypassPrivacy, Boolean bypassCache) at Blackbaud.Web.Content.Core.DataSourceConstituentFetch.GetResultsPage(Int32 PageNumber, Int32& NumberRecordsFetched) at Blackbaud.Web.Content.Core.EmailList.RefreshQuery(DataTable dtData, BBQueryType oQuery) at Blackbaud.Web.Content.Core.EmailList.RefreshListQueryBased() at Blackbaud.Web.Content.Core.EmailList.RefreshList()]
This can be resolved by following the steps in The Raiser's Edge and Blackbaud NetCommunity Knowledgebase solution detailing the ODBC error.

Environment

 6.45.2034 Patch 0

Was this article helpful?