FAQs‎ > ‎Account Maintenance FAQs‎ > ‎

How do I resolve Q0134 - A unique index was violated. Either a duplicate record was inserted, or a unique attribute was modified. VSSOWN.PK_RVENDCOMM_R_VEND_COMMCOMM_, SQLCODE:1. SQLSTATE:23000 Information A new Headquarters Account record has been created. (A2355)?

Q:  How do I resolve Q0134 - A unique index was violated. Either a duplicate record was inserted, or a unique attribute was modified. VSSOWN.PK_RVENDCOMM_R_VEND_COMMCOMM_, SQLCODE:1. SQLSTATE:23000

Information    A new Headquarters Account record has been created. (A2355)?


A:  You will want to check the commodity codes that you have saved to your account and remove any duplicates to resolve this error.  There are account maintenance job aids that can walk you through the process for adding and deleting commodity codes. To view, these job aids navigate to VSS Account Maintenance Job Aids