Hi
Since a couple of weeks I encounter an error after restoring ADD and the tables.
7057 Record update failed, The key value produced from this record was not unique, and the index for the current table has the UNIQUE property.
The field thats causing the problem is an autoinc, it happens on different tables, not always the same after restoring. Some tables have less then 10.000 records, other more then 3000000.
I create a full backup with
adsbackup -x \\server\share\my.add \\server\sharekopie
and then restore
adsbackup -r -x ....
I could not find a way to fix this problem, neither reindex, pack, deleting the ADI file, nothing helps,
Except deleting the last couple of records. It seems the last autoinc stored in the header is lower then the one last inserted.
Anyone an idea what causes this trouble?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.