Error: Data could not be saved. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.

When attempting to add a payment to a constituent using the Add payment form found on the constituent's record, the following error message occurs after clicking the Save button:

Data could not be saved.  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 publish utility.  There were multiple entries in GLPAYMENTMETHODREVENUETYPEMAPPING, so different gift types are trying to map to multiple mappings; there should be only one per PAYMENTMETHODCODE, REVENUETRANSACTIONTYPECODE, REVENUESPLITTYPECODE, APPLICATIONCODE, TRANSACTIONTYPECODE

 These appear to have been added all at once - the audit information seems to be backdated but the timestamp on the record is more recent.

If this issue arises:
Contact Support and reference this article. 

Environment

 2.91.1535 Patch 55

Was this article helpful?