Differences

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

Link to this comparison view

sms_error_-_missing_line_items [2019/01/27 11:30]
127.0.0.1 external edit 		sms_error_-_missing_line_items [2019/06/13 18:57] (current)
smerritt
Line 1: Line 1:
 ====== Missing Products in an Order ====== ====== Missing Products in an Order ======
- 
- 
  
 ===== Severity ===== ===== Severity =====
- 
- 
  
 ===== Explanation of Error ===== ===== Explanation of Error =====
- 
- 
  
 ===== Possible Root Cause(s) ===== ===== Possible Root Cause(s) =====
  
 +===== Resolution =====
  
- 
-===== Resolution ===== 
   - Determine the date the order was created or last edited (money change or status change).   - Determine the date the order was created or last edited (money change or status change).
   - If created since the last backup, the customer will have to edit the order and reenter the Products.   - If created since the last backup, the customer will have to edit the order and reenter the Products.
-  - If created or edited before the last backup, [[backup_database]].+  - If created or edited before the last backup, [[:backup_database|]].
   - Create a folder in the SMS folder called TempData   - Create a folder in the SMS folder called TempData
-  - Copy the Order Details Database and Order Modifier Database and indexes from the backup to the TempData folder*** +  - Copy the Order Details Database and Order Modifier Database and indexes from the backup to the TempData folder*** - Open the DBBrowser - Go into the Select Alias tab in the DBBrowser and click the Create Alias button and select the TempData folder. - Check to see if a backup has the missing Line Item(s) (e.g. Filter by OrderID = XXXXX in the Order Details and Order Modifiers tables) - Open the Datbase Browser and run **SQL 1** 
-  - Open the DBBrowser + - Run **SQL 2** for the Modifiers - [[:dbrebuild|]] 
-  - Go into the Select Alias tab in the DBBrowser and click the Create Alias button and select the TempData folder. + - Don't forget to go back into the registry and change the Alias path back to the SMS\Data folder. * Note: The corruption could have occurred before the last backup. Check the Adjustments Database to see when the order was edited last. ===== SQL 1 ===== '' Insert into __GESHI_QUOT__Order Details Database__GESHI_QUOT__  Select * From __GESHI_QUOT__ [[\\ServerName\Cyrious$\SMS\TempData\Order|]] Details Database__GESHI_QUOT__  Where OrderID = XXXX ''  <html><div style="margin-left: 20px;">**Note:** ServerName is the name of the computer and use the correct OrderID </div></html> 
-  - Check to see if a backup has the missing Line Item(s) (e.g. Filter by OrderID = XXXXX in the Order Details and Order Modifiers tables) +      * When using the DBBrowser, the path is located at the bottom of the SQL screen.
-  - Open the Datbase Browser and run **SQL 1** +
-  - Run **SQL 2** for the Modifiers +
-  - [[dbrebuild]] +
-  - Don't forget to go back into the registry and change the Alias path back to the SMS\Data folder. +
-      * Note: The corruption could have occurred before the last backup. Check the Adjustments Database to see when the order was edited last.  +
- +
  
 ===== SQL 1 ===== ===== SQL 1 =====
- 
- 
  
 <code sql> <code sql>
-Insert into "Order Details Database" +INSERT INTO "Order Details Database" 
-Select * From "\\ServerName\Cyrious$\SMS\TempData\Order Details Database" +SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\Order Details Database" 
-Where OrderID = XXXX+WHERE OrderID = XXXX
 </code> </code>
  
- +=====   =====
- +
-<html><div style="margin-left: 20px;"> **Note:** ServerName is the name of the computer and use the correct OrderID </div></html> +
-    * When using the DBBrowser, the path is located at the bottom of the SQL screen. +
- +
  
 ===== SQL 2 ===== ===== SQL 2 =====
- 
- 
  
 <code sql> <code sql>
-Insert into "Order Modifiers Database" +INSERT INTO "Order Modifiers Database" 
-Select * From "\\ServerName\Cyrious$\SMS\TempData\Order Modifiers Database" +SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\ORDER Modifiers Database" 
-Where OrderID = XXXX+WHERE OrderID = XXXX
 </code> </code>
- 
-