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
You could leave a comment if you were logged in.