Error: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression - when querying on constituents

When running a query with Constituent\Addressee and Salutation\Primary addressee as output fields, users may receive the error: 

Subquery returned more than 1 value.  This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.
This issue was caused by a data conversion problem.  If you are experiencing a similar issue, review  How to identify data conversion issues in Blackbaud CRM for more information. 

This issue occurs when constituents were converted with multiple Addressee/Salutations marked as Primary Addressee or Primary Salutation.  Each constituent should only have one Primary Addressee and one Primary Salutation. 

Environment

 2.9.1001.107

Was this article helpful?