Missing Products in an Order

Severity

Explanation of Error

Possible Root Cause(s)

Resolution

  1. Determine the date the order was created or last edited (money change or status change).
  2. If created since the last backup, the customer will have to edit the order and reenter the Products.
  3. If created or edited before the last backup, backup_database.
  4. Create a folder in the SMS folder called TempData
  5. 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 - 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 ===== Insert into GESHI_QUOTOrder Details DatabaseGESHI_QUOT Select * From GESHI_QUOT \\ServerName\Cyrious$\SMS\TempData\Order Details DatabaseGESHI_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>
    • When using the DBBrowser, the path is located at the bottom of the SQL screen.

SQL 1

INSERT INTO "Order Details Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\Order Details Database"
WHERE OrderID = XXXX

SQL 2

INSERT INTO "Order Modifiers Database"
SELECT * FROM "\\ServerName\Cyrious$\SMS\TempData\ORDER Modifiers Database"
WHERE OrderID = XXXX
You could leave a comment if you were logged in.