xTuple.com xTupleU Blog & News Customer Support

PL/pgSQL error: duplicate key value violates unique constraint "addr_addr_number_key"

While editing customer contacts we are seeing the following errors logged to stdout on the server:

ERROR: duplicate key value violates unique constraint "addr_addr_number_key" CONTEXT: SQL statement "UPDATE addr SET addr_number = $1 , addr_line1 = $2 , addr_line2 = $3 , addr_line3 = $4 , addr_city = $5 , addr_state = $6 , addr_postalcode = $7 , addr_country = $8 , addr_active = $9 , addr_notes = $10 WHERE addr_id = $11 " PL/pgSQL function "saveaddr" line 133 at SQL statement STATEMENT: SELECT saveAddr(11,'183','','123 ABC ST','','Some Town','AZ','12345','United States',TRUE,'','CHANGEALL') AS result;

And there is a pop-up on the client as showing in the attached screenshot.

The changes being made to the contacts appear to be getting saved properly to the database, but I need to know if this is something to be concerned about, and if so how to fix?

This is with verison 3.7.4 of XTuple ERP (open source)

Thanks!


Bill Arlofski
Reverse Polarity, LLC
http://www.revpol.com/

Probably  you have entered duplicate values in a unique keyed value.