Purpose

The purpose of this article is to describe a LightSpeed LEVEL error in which unique keys will duplicate and show in LEVEL Last Logs. This issue can cause the "update items failed"/ "Failed to update LightSpeed Level" error when clicking the update items button.

Process

1. Locate the duplicate product code by checking the lastlogs command (or EventLog table) in the Level database (SQL Server → Level DB)
   
2. Locate the specific id from the above error message that causes a duplicate. Copy that ID.
   • Example statement: SQL Error......The duplicate key value is (FRI34389).
     
     
3. Update the product code to a different unique distinct value for that id and
   then update the item.
   • Example statement: update item set code = ‘newproductcode’ where code =‘currentproductcode’ and id = ’productid’
     
     
4. After updating the ID, the manage items page & update item command should work
   again, unless there are additional duplicates.