The INSERT statement conflicted with the FOREIGN KEY constraint

Error: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint “FK__Item__order__3AE27131”. The conflict occurred in database “pmall”, table “dbo.ItemSaved”, column ‘id’.

Here’s my table:

  • Need help with the Merge statement
  • SQL Server: “a connection was successfully established with server…existing connection was forcibly closed by the remote host.”
  • SQL query for two values of one row based off same table column
  • Migrate to Amazon SQL Server RDS
  • Select records with multiple row criteria in sql server
  • SQL server stub for java
  • ItemSavedUnits

    • id
    • ItemID (is set in this table a FK to
    • …etc.

    Here’s my insert statement:

    insert into ItemSavedUnits (ItemID, name, Price)
    select ItemID, name,Price
    from ItemUnits where ItemID = 92439 

    I don’t really understand why if I a FK constraint on ItemSavedUnits.ItemID that is related to Item.ItemID and ItemUnits has no constraints at all why I’m getting a problem inserting into ItemSavedUnits. The ItemID I’m tryign to insert does exist in the Item table.

    3 Solutions collect form web for “The INSERT statement conflicted with the FOREIGN KEY constraint”

    Are you absolutely sure that ItemId 92439 exists in the Item table, and not just in ItemUnits?


    Is your select statement returning null?

    It looks like you need a row in ItemUnits with that ID first – what does the SELECT statement part of your insert return? No rows?

    Also, is there a trigger on the ItemSavedUnits table that could be causing problems?

    Your foreign key constraint violation doesn’t appear to deal with the ItemSavedUnits table – the violation exception is being thrown by the constraint on the ItemSaved table, not the ItemSavedUnits table. Is there a trigger on ItemSavedUnits that’s trying to insert into ItemSaved?

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.