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
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);
delete FROM receipt_setup;
insert into receipt_setup (default_receipt_type, min_receipt_amt)
values (1, 0.00);
delete FROM receipt_setup;
insert into receipt_setup (default_receipt_type, min_receipt_amt)
values (1, 0.00);
- In FR50 go to File>Backup and run the local backup utility
- At the server Start>Programs>Microsoft SQL Server XXXX> SQL Server Management Studio Express
- Connect to the FR50 instance
- Object Explorer>Databases>database with issue, right click>New Query
- 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);
- Launch the Sage Fundraising Online import again, the error message should not appear any longer
Article Type
Product Issue
Product Line
Fundraising 50
Product Module/Feature
Import
Ranking