Skip to main content

Violation of PRIMARY KEY constraint 'DATAFEEDIMPORTHISTORY_PRIMARYKEY'

This article explains the cause of the error 'Violation of PRIMARY KEY constraint 'DATAFEEDIMPORTHISTORY_PRIMARYKEY'' and how to resolve it.

Written by Cristiana Ghinea

Getting this error message when trying to import data in to Access Charity CRM indicates that the number generator which handles unique IDs for datafeed imports has gotten stuck, and will require the support team to repair.

Below is the full error message:

Violation of PRIMARY KEY constraint 'DATAFEEDIMPORTHISTORY_PRIMARYKEY'. Cannot insert duplicate key in object 'dbo.DATAFEEDIMPORTHISTORY'. The duplicate key value is (Row0)

If you get this error, please reach out to us via the Digital Assistant and provide us with as many details as possible so we can investigate and assist.

Did this answer your question?