7059 Unique index creation error

Advantage Error Guide

Problem: An index with the UNIQUE property was not able to be created because data in the table produced non-unique key values.

Solution: Make sure that the table data used to create the unique index is unique. When the record(s) was found that would cause a non-unique key to be place in the index, an error was logged in the Advantage error log (ADS_ERR.ADT or ADS_ERR_.DBF). That error log entry will indicate the record number, the tag name, and the index name associated with the non-unique index value. Use the Advantage error log to determine which records are in violation of the uniqueness property.