1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. “Cannot get new unique key value” – BACKTRACK Error Message

“Cannot get new unique key value” – BACKTRACK Error Message

Summary

This article explains the BACKTRACK error message “Cannot get new unique key value” and details how to fix the underlying problem that caused it to appear.

Explanation

As a relational database, BACKTRACK routinely updates, add, and remotes records from the various tables that comprise the database structure.  Each table requires a field or combination of fields that uniquely identifies the record.  Without a unique value (aka Key field), relational databases like BACKTRACK cannot manipulate data withing the tables and therefore cannot function.

With this error, BACKTRACK seems to fail to insert a new record into a database table. The error message indicates that the BACKTRACK is not able to assign a unique value for the record key field.  Therefore, when it tries to insert the new record, the insert fails.

Solution

Two areas to check:

Verify Item Auto Assign Value is Correct

If using “Automatic” to assign Item Number, make sure that the next value BACKTRACK will assign is unique. Check the “Current Item ID” value in the Advanced Edit feature of the Maintain Application section. It should show a value unique to all other Item ID values currently in the database. Main Menu \ Database Maintenance \ Administration Functions \ Maintain Application \ Edit \ Advanced Edit

Check for Duplicate Values in Database

This can tricky so we recommend working with your EBI Technical Support Coach. Essentially you need to use a database tool (e.g. SQL Management Studio) to verify that the Item table does not have any duplicate values in the key field (Item # field).

Additional Comments

Software Found On:
Windows, BACKTRACK 2012 R2

Updated on August 6, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support