Error: Error refreshing list. Details: [System.ApplicationException: Error fetching records (DoSearch()): Invalid procedure call or argument at Blackbaud.Web.Content.Core.Data.RecordSearch.DoSearch() - when loading Constituent Lists

When importing a constituent list that contains a "Gender" filed in the query, users have found that the following error is triggered when loading the list in BBNC. 

Error: 
Error refreshing list. Details: [System.ApplicationException: Error fetching records (DoSearch()): Invalid procedure call or argument at Blackbaud.Web.Content.Core.Data.RecordSearch.DoSearch() at Blackbaud.Web.Content.Core.DataSourceConstituentFetch.StartPagedFetchByQueryID(Int32 QueryID, Int32 RecordsPerPage, IDataSourceFetchFields[] FetchFields, String options, Int32 SystemID) 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()]
We’re currently evaluating this issue for a fix in a future release.
=================================================
Workaround: Export the query from RE then import the names using an imported list into BBNC. 
=================================================
 

Steps to Duplicate

1. From RE, create a Constituent query that includes the Field: "Gender". 
2. Navigate to BBNC and select "Email" then click "Lists". 
3. Create a list.
4. Click "Add Query" and search for the constituent list from step 1. 
5. Refresh the List. 
6. Note that the List Status received the error: 
Error refreshing list. Details: [System.ApplicationException: Error fetching records (DoSearch()): Invalid procedure call or argument at Blackbaud.Web.Content.Core.Data.RecordSearch.DoSearch() at Blackbaud.Web.Content.Core.DataSourceConstituentFetch.StartPagedFetchByQueryID(Int32 QueryID, Int32 RecordsPerPage, IDataSourceFetchFields[] FetchFields, String options, Int32 SystemID) 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()]

Environment

 Blackbaud NetCommunity
 7.1

Was this article helpful?