Error: Run-time error -2147211486(80042722). General ODBC Error. [Microsoft][ODBC SQL Server Driver][SQL Server]. Subquery returned more than one value. This is not permitted when subquery follows =, !=, <, >, <=, >=

Users may receive the following area in various areas in The Raiser's Edge:

Error:
Run-time  error -2147211486(80042722). General ODBC Error. [Microsoft][ODBC SQL Server Driver][SQL Server]. Subquery returned more than one value. This is not permitted when subquery follows =, !=, <, >, <=, >= or when the subquery is used as an expression. Native error: 512

This may occur when performing the following tasks:

  • Running Query / Export
  • Opening a Record
  • Previewing or printing Labels / Phonathon forms
  • Running Quick Letters
  • Running Donor Acknowledgement Letters
  • Importing

Note : Before you proceed with the following instructions, back up the database. If your organization integrates multiple Blackbaud products, refer to the Additional Requirements section of the backup article.

Try each of the following steps in order until the issue is resolved:

    • Download and run the Membership Sequence plug-in  (only if the Membership module is unlocked)
    • Download and run the Duplicate Spouse Delete plug-in
    • Download and run the Constituent Codes Sequence plug-in: Download FixConstitCodeSeq761.zip
    • Download and run the Duplicate Primary Business Utility plug-in
    • Download and run the Education Sequence plug-in attached to this article (only if the Alumni module is unlocked)
    • Download and run the De-Duplicate Phones plug-in (For databases on version 7.93 and below)
      • In exports in 7.93 and below, the error can be caused by the Address.Phone Number field
    • Perform database maintenance: How to perform or run SQL Server database maintenance
    • Recreate the affected record:
      • If a mailing, export, query, or import, recreate the affected parameter. If a query is included in the affected export or mailing, recreate the query as well. 
      • If a constituent, create a new blank constituent record and merge the affected record into it. 
    NOTE: If Blackbaud hosts your RE database, the plugin you need to resolve this error may be installed.  Check this article for plugins that are already installed when hosted by Blackbaud.
    Education Sequence Utility

    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.