Common Errors : BOM Processing

  • November 27, 2014 at 3:03 pm #19812
    Russ Kahn

    Cannot insert duplicate key in object ‘dbo.Cores’.

    This can be a result of having the same Purchase Item # on two different IMOS materials.

    Error 547, Message: “The INSERT statement conflicted with the FOREIGN KEY constraint “FK_ItemEdgesImport_ItemsImport”. The conflict occurred in database “inSight”, table “dbo.ItemsImport”.”

    This can be the result of a part referencing either a profile or a surface that does not exist.

  • March 31, 2015 at 11:03 am #25823

    We used to get the second error quite often when we started developing our imos library. I always guessed it happens because of missing profiles or surfaces, but wasn’t quite sure. Thanks for the confirmation!

You must be logged in to reply to this topic.

Share this Post