====== ======
===== 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
Delete from "Order Details Database"
Insert into "Order Details Database"
Select * from "Order Details
**NOTE: Change name of table accordingly**