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" field 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()]
This is resolved in 7.96 patch 13, released in September - October 2018 and applied to databases in Blackbaud Hosting Services. Patch 13 is not being released to locally hosted databases at this time.
=================================================
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?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.