Product: ImportOmatic
Description: This solution describes how to resolve the error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TABLEENTRIES_1". The conflict occurred in database "re7", table "dbo.CODETABLES", column 'CODETABLESID'. Native error:547 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. Native error:3621
Environment: All
Version: All
Answer:
This error will occur when the appeal is not properly mapped in the profile. For example, if the Value Type is left blank.
Map the appeal, and the import will process successfully.
Please refer to the ImportOmatic User Guide for additional information.
Description: This solution describes how to resolve the error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "FK_TABLEENTRIES_1". The conflict occurred in database "re7", table "dbo.CODETABLES", column 'CODETABLESID'. Native error:547 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated. Native error:3621
Environment: All
Version: All
Answer:
This error will occur when the appeal is not properly mapped in the profile. For example, if the Value Type is left blank.
Map the appeal, and the import will process successfully.
Please refer to the ImportOmatic User Guide for additional information.