Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ConstituentATTRIBUTES_3". The conflict occurred in database "RE7", table "dbo.AttributeTypes", col :

Product: ImportOmatic

Description: Line 1: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ConstituentATTRIBUTES_3". The conflict occurred in database "RE7", table "dbo.AttributeTypes", column 'ATTRIBUTETYPESID'.
Native error:547
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.
Native error:3621
[Object: 'CRecord', PK: '', Import ID: '', Desc: ''] -->BBREAPI.CRecordClass.Save()-->#=qKoMvBUYVZ2j$d9ZsNInLvy6Jy_cOjgciR9QP7QX5ENc=.#=qg7ylJgKY6wgvpYPxYUiRlA==()
Environment: All
Versions: All

Answer:

The value in the data file that is mapped to Attribute Type no longer exists in RE. In the case above, it is the Attribute Type inConstituent Attribute group #3, or the third attribute that is mapped.

How can we help you today?

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ConstituentATTRIBUTES_3". The conflict occurred in database "RE7", table "dbo.AttributeTypes", col Print

How can we help you today?

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_ConstituentATTRIBUTES_3". The conflict occurred in database "RE7", table "dbo.AttributeTypes", col Print

Related Articles