Errors When Reusing Primary Keys

Problem: Reusing an enterprise information system (EIS) primary key generates an error. If you insert a record that has the same primary key that has been deleted, the Unwired Server fails to retrieve the inserted data.

Explanation: Make sure the EIS does not reuse primary keys. For example, if a record with primary key value 1 is deleted, make sure records inserted do not use 1 as the primary key value.

For a database EIS, you can define the primary key column as auto-increment, so when a new record is inserted, the primary key is always assigned a new value.