Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
sms_error_-_key_violation [2019/06/14 16:08]
vsouvannarath 		sms_error_-_key_violation [2019/07/18 12:53] (current)
orichards [Open Database Browser]
Line 1: Line 1:
-======   ======+====== Key Violation ======
  
 Each record in the SMS datbase (and most others) has a //key// field. This field uniquely identifies the record (row of data) and is used by the database to quickly find the record. In SMS tables, the first column in the table (usually ending in "ID") is used as the key field. Each record in the SMS datbase (and most others) has a //key// field. This field uniquely identifies the record (row of data) and is used by the database to quickly find the record. In SMS tables, the first column in the table (usually ending in "ID") is used as the key field.
Line 10: Line 10:
 ==== Open Database Browser ==== ==== Open Database Browser ====
  
-  - Make a backup of the ~\Cyrious\SMS\Data folder.+  - Make a backup of the ~\Cyrious\SMS\Data folder by copying the folder and then renaming it with today's date.
   - Run the [[:dbrebuild|DBRebuild]].   - Run the [[:dbrebuild|DBRebuild]].
   - Run the [[:id_repair|IDRepair]] utility (unless customer has a flag stating otherwise)   - Run the [[:id_repair|IDRepair]] utility (unless customer has a flag stating otherwise)
   - Open the DBBrowser.   - Open the DBBrowser.
 +
  
 ==== Look for Bad Data At the Top of Each Table ==== ==== Look for Bad Data At the Top of Each Table ====
Line 21: Line 22:
       * If a blank ID records turns up with valid information, then an unused ID number should be assigned to the record.       * If a blank ID records turns up with valid information, then an unused ID number should be assigned to the record.
   - Delete any large negative values records at the top of the database (i.e. -117346859).   - Delete any large negative values records at the top of the database (i.e. -117346859).
-  - Renumber any normal size negative number with the psotive value (i.e. -3456 rekey as 3456).+  - Renumber any normal size negative number with the positive value (i.e. -3456 rekey as 3456).
       * If you get a key violation renumbering it (meaning the positive record already exists), delete the negative record.       * If you get a key violation renumbering it (meaning the positive record already exists), delete the negative record.
  
Line 181: Line 182:
  
 **Note:**  You will need to adjust the Table name and ID name **Note:**  You will need to adjust the Table name and ID name
- 
-See Also 
-