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_-_index_out_of_date [2019/03/28 17:05]
smerritt [Explanation of Error] 		sms_error_-_index_out_of_date [2019/06/13 19:37] (current)
smerritt [Explanation of Error]
Line 1: Line 1:
 ====== SMS Error - Index Out of Date ====== ====== SMS Error - Index Out of Date ======
- 
- 
  
 ===== Error Message ===== ===== Error Message =====
  
- +"Database Index Out of Date" …
- +
-"Database Index Out of Date" ... +
- +
  
 ===== Severity ===== ===== Severity =====
  
 **Moderate**. The chance for data loss is Moderate, but the user is unable to use the database until it is corrected. Occassionally, if the errors are in the Estimate Details or Order Details tables, it is not uncommon to lose line items for the order/estimate that was corrupted. For many users, this error occurs frequently. For others, it almost never occurs. **Moderate**. The chance for data loss is Moderate, but the user is unable to use the database until it is corrected. Occassionally, if the errors are in the Estimate Details or Order Details tables, it is not uncommon to lose line items for the order/estimate that was corrupted. For many users, this error occurs frequently. For others, it almost never occurs.
- 
- 
- 
 ===== Explanation of Error ===== ===== Explanation of Error =====
  
Line 59: Line 50:
 - Open the NewData folder //(If version 8.91 and above make sure the NewData tables are also updated to 8.91. A quick way to update is to rename NewData to 'Data' - meanwhile renaming Data to something else like 'Data' - and running SSLIP and SMS. The tables should update quickly during this process. Just don't forget to rename the folders again!)// - Open the NewData folder //(If version 8.91 and above make sure the NewData tables are also updated to 8.91. A quick way to update is to rename NewData to 'Data' - meanwhile renaming Data to something else like 'Data' - and running SSLIP and SMS. The tables should update quickly during this process. Just don't forget to rename the folders again!)//
  
-////- Sort by Type// //+- Sort by Type
  
-////- Scroll down to the last PX file// //+- Scroll down to the last PX file
  
-////- Copy everything below the last PX file// //+- Copy everything below the last PX file
  
-////- Paste in the Data folder // //+- Paste in the Data folder
  
-////- **Select NO to all** (this replaces only the missing indexes // //+- **Select NO to all** (this replaces only the missing indexes
  
-////- [[:dbrebuild|]] //**Make note of the error logs in these cases and which index(es) are throwing the error. If the Index out of Date error returns after Resolutions 1 and 2 have been performed and the same index (example: CustomerOrderIndexDesc) is at fault then proceed to Resolution 3 which replaces the table entirely:**// // //+- [[:dbrebuild|]] //**Make note of the error logs in these cases and which index(es) are throwing the error. If the Index out of Date error returns after Resolutions 1 and 2 have been performed and the same index (example: CustomerOrderIndexDesc) is at fault then proceed to Resolution 3 which replaces the table entirely:** //
  
-<font 16px/inherit;;inherit;;inherit>**////===== Resolution 3 =====////**</font>+<font 16px/inherit;;inherit;;inherit>**===== Resolution 3 =====**</font>
  
 - Verify the affected table(s) using the Error Logs and, potentially, dbrebuild - Verify the affected table(s) using the Error Logs and, potentially, dbrebuild
Line 85: Line 76:
 - Run a dbrebuild scan on the table(s) to see if it needs to be rebuilt. If so, rebuild it - Launch SSLIP and SMS - confirm that the error no longer appears - Run a dbrebuild scan on the table(s) to see if it needs to be rebuilt. If so, rebuild it - Launch SSLIP and SMS - confirm that the error no longer appears
  
-////''INSERT INTO GESHI_QUOT[[\\server\Cyrious$\SMS\NewData\Order|]] DatabaseGESHI_QUOT SELECT * FROM GESHI_QUOT[[\\server\Cyrious$\SMS\Data\Order|]] DatabaseGESHI_QUOT ''  // //+**<font 16px/inherit;;inherit;;inherit>SQL 1</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Adjustments Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Adjustments Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 2</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Contact Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Contact Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 3</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Customer Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Customer Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 4</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 5</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Details Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Details Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 6</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Estimate Modifiers Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Estimate Modifiers Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 7</font>** 
 + 
 +<code sql> 
 + 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\GL Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\GL Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 8</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 9</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 10</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Details Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Details Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 11</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Modifiers Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Modifiers Database" 
 +</code> 
 + 
 +**<font 16px/inherit;;inherit;;inherit>SQL 12</font>** 
 + 
 +<code sql> 
 +INSERT INTO "\\server\Cyrious$\SMS\NewData\Order Modifiers Database" 
 +SELECT * 
 +FROM "\\server\Cyrious$\SMS\Data\Order Modifiers Database" 
 +</code> 
 +</code>