Symptom: 
When transactions are imported from Abila Fundraising Online the following message is returned:
 
Insert Error
The INSERT statement conflicted with the FOREIGNKEY constraint “fk_gift_import_id”.  The conflict occurred in the database “your database name”, table “dbo.import”, column “import_id”
Reference 23000
Cause: 
A possible interruption of the upgrade process caused a duplicate ID to be added to the Receipt table.
Resolution: 
Run the following SQL script on the database to remove the duplicate:
 
delete FROM receipt_setup;
insert into receipt_setup (default_receipt_type, min_receipt_amt)
values (1, 0.00);
 
  1. In FR50 go to File>Backup and run the local backup utility
  2. At the server Start>Programs>Microsoft SQL Server XXXX> SQL Server Management Studio Express
  3. Connect to the FR50 instance
  4. Object Explorer>Databases>database with issue, right click>New Query
  5. In the Query window enter the following script:
 
delete FROM receipt_setup;
insert into receipt_setup (default_receipt_type, min_receipt_amt)
values (1, 0.00);
 
  1. Launch the Sage Fundraising Online import again, the error message should not appear any longer

Required Tags:

Article Type: 
Product Issue
Product Line: 
Abila Fundraising 50
Product Module/Feature: 
Import
Ranking: 
0

No votes yet