Run-time error '-2147211486 (80042722)': Cannot insert duplicate key in object 'dbo.GiftAidClaim.Address' when generating an R68 Report (UK Only)

When running a new R68 Report in The Raiser's Edge on version 7.94 users get the following error when including Split Gifts:
Run-time error '-2147211486 (80042722)': [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint ‘PK_GiftAidC_D17A5B1815728C0E’. Cannot insert duplicate key in object ‘dbo.GiftAidClaim.Address’. The duplicate key value is (2753). Native error: 2627. [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. Native error: 3621

Followed by -
Automation error: The callee (server [not server application]) is not available and disappeared; all connections are invalid.  The call may have executed.
Run-time error '-2147418105 (800410007)': Automation error: The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call may have executed.
Error in Shutdown for object 'CReportHelper' Automation error: The callee (server [not server application]) is not available and disappeared; all connections are invalid. The call may have executed.
RE7.exe has stopped working. Windows is checking for a solution to the problem...
 
Download and install the latest version and patch if applicable.

 

Steps to Duplicate

  1. Add a cash gift to a constituent who has an active declaration - eg where the declaration is present on the Declaration Information button on Bio 1 with a start date of 06/04/2000 and Pays Tax Yes, Indicator - Written
  2. Enter Gift Date of this year and 2 sets of split gift information - eg Capital Campaign and Endowment Campaign. Confirm in Config, Business Rules, Gift Options, Activity Options, Gift Aid Rules that neither of these campaigns or the associated funds and appeals on the gift are disqualified for Gift Aid.
  3. Save the gift and confirm that the Tax tab shows "Qualification Method specified on Split Gift Tab. Gift Aid Qualification Status: Qualified for Gift Aid"
  4. In Reports, Gift Aid Report, Generate R68 (New Gift Aid Report) run the report for a date range that includes this gift. Enter unique tax claim number on the General tab and click Preview.
  5. Close the Update Tax Eligibility Control Report and the R68 report should show with this constituent and gift present. Print or close the report preview and when prompted to update tax claim number say yes, and errors occur.
    Screen shots of errors saved in Word document Case 12421744 errors when running R68 in 794.docx saved to \\cly-files\attachments\2015CS\12419522
  6. Need to log out and back into Raiser's Edge when this occurs - gifts have been updated with the tax claim number but the claim does not show in Admin, Submit Gift Aid Claims to HMRC
  7. Occurs in sample database running 7.94.6116.0

Environment

 Raiser's Edge
 7.94
 7.95

Was this article helpful?