Skip to content


New Inventory Items

Kelly asked 2 years ago
We are looking to upload new inventory items to save the Warehouse Techs time instead of manually entering each one.
Got everything set up, but when I run the mapping, an error –
Violation of PRIMARY KEY constraint ‘pkIVItem’. Cannot insert duplicate key value is (1254). The statement has been terminated.
What am I missing?  I don’t see an IVItem in the fields to be matched…
Patrick Roth Staff answered 2 years ago
I’m not sure what product the table IVItem belongs to – I don’t have one in my GP installs.  However eConnect doesn’t know about this table either so this suggests that the application likely has a SQL Db trigger on a GP table that you are integrating to.
Or this is the table YOU are integrating to and you are getting a duplicate.
You’d have to look at the table to determine how data is getting into it – again maybe a GP SQL DB trigger – and review to see why you get that duplicate.

If you would like to submit an answer or comment, please sign in to the eOne portal.