Stale records

During the final update, the original values in the temporary table for the set are compared to the current values in the database table. If the values do not match, the extraction record is considered a stale record.

A stale record occurs when these conditions are met:

• A value on a record in the database table is changed by another user or through another process
• The final update on a record that contains that value was not performed.

Stale records cannot be processed in SA Mass Maintenance Administration. You cannot reset the error status for stale records. You must create another set to extract the most current values for record from the database table. Optionally, change the value in the menu function.

To avoid stale records, perform the final update shortly after you create the set.