Smithsonian National Museum of Natural History logo

Osteoware: Standardized Skeletal Documentation Software

Osteoware: Standardized Skeletal Documentation Software

Error - Will not save postcranial info

All other aspects (age/sex, inventory, etc.) of this entry will save properly, but when we try to save the postcranial metrics, this message pops up:

PC Query: Error 7057: The record update failed. The key value produced from this record was not unique, and an index for the current table was the UNIQUE property. The key value supplied for PCAdultmetrics: PRIMARY is not unique.

We have tried deleting the entire individual and creating a new individual and just starting fresh, but this keeps happening with the postcranials. This has not happened before with the other individual records.

DUDARC's picture
Submitted by DUDARC on

Hello emrvande,

Are you trying to enter adult or subadult PC metric data?  Entering data into a Catkey record with a 'Individual Letter' suffix, or perhaps the commingled Tracking system?  These details may not be relevant, but the more you can describe the better I can assess possible problems.

In general, that type of error message is indicating that there is a problem with the 'unique identifier' or 'primary key' of the record you have assigned and are trying to save data to. A 'unique identifier' or 'primary key' are database terms for data fields that must be, well, unique in order for the database to maintain integrity. 

Perhaps another record you have entered has the same Catkey number in that table, or even another table (PC Metrics is divided into adult and subadult tables).  Also be aware that some Osteoware database tables have a combination 'primary key' composed of either Catkey/Individual or Catkey/Tracking number.

If you haven't already downloaded and installed Advantage Data Architect (ADA), then please do so.  Instructions are in the Osteoware install manual. Please read this section. Link ADA to your tables, and open the relevant PC Metrics table (either subadult or adult).

If I had to guess, I suspect that somebody tried to enter data under that catalog number earlier, tried to delete it, but the record is lingering in the table.  Complete records cannot easily be wiped from the Osteoware GUI, only through ADA, which is the database manager.

While it may be inconvenient, we have found that it is important to maintain database management functions, such as deleting entire records, with a select number of individuals using ADA.  Thus potential loss of data cannot be inadvertently accomplished through the GUI alone by a casual data entry person.

Let us know if this is the case, or if you need further help.