Error: "Uniqueness of index CODE is violated" is shown when an action requesting access code is performed.

PROBLEM

Error: "Uniqueness of index CODE is violated" is shown when an action requesting access code is performed.

ENVIRONMENT

Shireburn Inventory Management System

SOLUTION

Perform a re-index and try again

CAUSE

This normally happens if the user has created something before with the same code, deleted it, and recreated it again. A re-index would pack and refreshes the data.

• Related Articles

• Error: "Primary key column was not found in the excel sheet" when trying to re-import items from Excel

  ERROR Error: "Primary key column was not found in the excel sheet" when trying to re-import items from Excel when you are trying to re-import items that you have amended from Excel. ENVIRONMENT SIMS SOLUTION Follow the procedure below: Re-export the ...

• Error 7017 | Corrupt indexing error upon logging in to SFM

  Problem An SupplierSadsTable: Error 7017: Corrupt .ADI, .CDX, or .IDX index error pops up upon logging in to SFM. Environment SFM Solution A re-indexing would need to be carried out. Before proceeding with the re-indexing, it is important that all ...

• Error: "This action cannot be completed because the other program is busy" is showing up when trying to export replenishment to Excel from SPOS

  PROBLEM Error: "This action cannot be completed because the other program is busy" window is coming up when trying to export the replenishment on Excel on SPOS. The windows will freeze and a message box in the left top corner comes with a message ...

• Configuring Access Level permissions for user groups

  Permissions for access levels are configured in the Groups & Permissions page. Here you can control whether a user group can view transactions or have permission to post and do other actions in your nominal, sales, or purchases ledgers. First, you ...

• Error: "File is in use. [,Tranpost.dbf] 227 openssltable" when creating an invoice

  Problem Error: "File is in use. [,Tranpost.dbf] 227 openssltable" when creating an invoice.   Environment SIMS All supported environments Solution Delete the tranpost folder located in the TEMP folder. Full path below: C:\Program Files ...