Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server] The insert statement conflicted with the foreign key constraint "FK_CONSTIT_ADDRESS_2 when downloading transactions in Online Express

When downloading transactions for existing constituent with phone numbers/emails, users may receive the following errors: 

Error: Unable to update constituent for the following reason: A duplicate phone number and phone type exists. Remove the duplicate to save the record. 
Would you like to update the constituent manually? Selecting 'No' will rollback updates and continue. 

If user clicks Yes to update the record manually, another series of errors will appear when attempting to Save the constituent record in The Raise'r Edge and is unable to save the constituent record or process the transaction successfully from Online Express.

Error: Object variable or With block variable not set.

Error: Undefined RE Error.

Error: General ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The insert statement conflicted with the foreign key constraint "FK_CONSTIT_ADDRESS_2".  The conflict occurred in database "RE7_[database name]" table dbo.ADDRESS column "ID".  Native error:547. 
[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated.
Native error:3621.
Run the Regenerate Import IDs plugin

When running the Regenerate Import IDs plugin, you must select specific tables to regenerate the Import IDs.  For this specific error, please choose the following:

CONSTIT_ADDRESS
TRIBUTE
TRIBUTE_ACKNOWLEDGEE

Depending on the type of transaction that generates the error, there may be additional Tables that need to be selected related to Membership or Events.

Steps to Duplicate

1. Go to Online Express from the RE navigation bar
2. Under the Donation section, click Download Transactions
3. Highlight the record to process by marking the checkbox for a constituent record and click Bulk Processing
4. On the Processing tab, click Process Now
5. Error: Unable to update constituent for the following reason: A duplicate phone number and phone type exists. Remove the duplicate to save the record. 
Would you like to update the constituent manually? Selecting 'No' will rollback updates and continue. 
6. If user clicks Yes, constituent record opens to edit the phones
7. Mnaually delete the duplicate phone type, and click Save and Close
8. Error: Object variable or With block variable not set
9. Click OK. 
10. Click Save again, Error: Undefined RE Error appears
11. Click OK. 
12. Edit the phone number to remove dashes, but keep spaces (Ex. change the phone number from 123-333-4444 to 123 333 4444
13. Click Save and Close for the record, the following error will occur: 

Error: General ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The insert statement conflicted with the foreign key constraint "FK_CONSTIT_ADDRESS_2".  The conflict occurred in database "RE7_[database name]" table dbo.ADDRESS column "ID".  Native error:547. 
[Microsoft][ODBC SQL Server Driver][SQL Server] The statement has been terminated.
Native error:3621.

14. Click OK - the record will not save and the error will continue until user forces quits RE

Was this article helpful?