Error: CK_RECURRINGGIFTINSTALLMENTPAYMENT_BALANCE_VALID

The loading of a large number of Recurring Gifts, which hits a constraint and throws an error.The error is CK_RECURRINGGIFTINSTALLMENTPAYMENT_BALANCE_VALID.When a small amount of these gifts are loaded, there are no errors. If 30 users try this at the same time then the errors appear, sometimes crashing the server. The error/constraint indicates negative or 0 amounts, which doesn't appear to be in the data. The function is taking a lot of resources and its placing a lot of records in CTE(memory) .
We’re currently evaluating this issue for a fix in a future service pack. 

Steps to Duplicate

  1. Populate 87 million entries into RECURRINGGIFTINSTALLMENT and RECURRINGGIFTINSTALLMENTPAYMENT table for different constituents and recurring gifts

  2. Open 20 "add a payment" screens and choose application type of recurring gift and create a payment to recurring gifts.

  3. Submit at the same time.

Environment

 Blackbaud CRM
 4.0
 4.0.157

Was this article helpful?