topic Re: "Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object" when using update or insert on tDBOutput in Installing and Upgrading

"Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object" when using update or insert on tDBOutput

dan-rosen — Fri, 15 Nov 2024 22:35:54 GMT

I'm receiving the error "Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object" when using update or insert on tDBOutput for a table that needs to retain it's data (so it can't be dropped or truncated, etc.). I don't understand why I would get this error; if the key is duplicate, it should update. For reference, if I use insert, or I use update, they both work properly, but I can't get the combination option to work. Does anyone have any ideas why this would be happening? Thanks!

Re: "Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object" when using update or insert on tDBOutput

Anonymous — Fri, 02 Sep 2022 02:41:26 GMT

Which DB type?

Make sure you have checked the 'key' box of the primary keys' column on schema of tDBOutput when you select 'insert or update' option.

Regards

Shong

Re: "Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object" when using update or insert on tDBOutput

PeggieP — Fri, 02 Sep 2022 11:41:36 GMT

I appreciate the information and advice you have shared. I will try to figure it out for more.