no_active_index [Support]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======  ======



===== Explanation =====



This error is due to missing ID Sequence Database info



==Resolution==
  - Navigate to Cyrious\SMS\Data folder
  - Sort files by Name
  - Scroll down and ensure all the ID Sequence Database files are there - probably missing the .PX file
  - Navigate to Cyroius\SMS\NewData folder
  - Highlight and copy the missing ID Sequence files 
  - Paste into the Cyrious\SMS\Data folder
  - Test



==Resolution 2==
  - Open DBBrowser on the customer's computer
  - Open DBBrowser on your local computer
  - Compare the Indexes for each table to ensure the customer is not missing some indexes
    - If you do not have SMS installed on your local machine, open a second copy of the DBBrowser
    - Click the Select Alias tab
    - Click the Create Alias button
    - Navigate to NewData or DemoData
    - Click OK
    - Compare the Indexes for each table to ensure the customer is not missing some indexes
  - When you find the table with the missing Indexes make a note of it and continue checking for additional tables with missing Indexes
  - Open the Data folder
  - Navigate to the table with the missing Indexes
  - Rename the files (ex. Order Details Database to Order Details)
  - Copy over the same table from the NewData or DemoData folder
  - Run the following queries



<code sql>
Delete from "Order Details Database"
</code>



<code sql>
Insert into "Order Details Database"
Select * from "Order Details
</code>

**NOTE: Change name of table accordingly**