Error: 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

The functions available in Mail allow the option to include a query of constituents.  When including a query of constituents in Phonathon Forms, users may see Error: 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 statement has been terminated. Native error 3621.
 

This can occur when including a query that targets constituents in a specific Class Of, and the included constituents have duplicate Education relationships on their records.


 

Download and run the DeDup Phones plug-in.

OR
 

  1. Include the affected query in a Constituent Export with the following output:
    • Constituent Information > Name
    • Relationships > Education > School Name and Class of
      • Note: export two or more relationships so duplicates can be seen
  2. Export to Excel and review the file to find constituents with duplicate Education relationships
  3. Open the affected constituents and delete one of the duplicate Education relationships
  4. Include the query in Phonathon forms; the forms should generate successfully
OR

Remove all Class of fields from the Phonathon form

Environment

 7.91.5056, Patch 23

Was this article helpful?