This error is due to missing ID Sequence Database info

Resolution
  1. Navigate to Cyrious\SMS\Data folder
  2. Sort files by Name
  3. Scroll down and ensure all the ID Sequence Database files are there - probably missing the .PX file
  4. Navigate to Cyroius\SMS\NewData folder
  5. Highlight and copy the missing ID Sequence files
  6. Paste into the Cyrious\SMS\Data folder
  7. Test
Resolution 2
  1. Open DBBrowser on the customer's computer
  2. Open DBBrowser on your local computer
  3. Compare the Indexes for each table to ensure the customer is not missing some indexes
    1. If you do not have SMS installed on your local machine, open a second copy of the DBBrowser
    2. Click the Select Alias tab
    3. Click the Create Alias button
    4. Navigate to NewData or DemoData
    5. Click OK
    6. Compare the Indexes for each table to ensure the customer is not missing some indexes
  4. When you find the table with the missing Indexes make a note of it and continue checking for additional tables with missing Indexes
  5. Open the Data folder
  6. Navigate to the table with the missing Indexes
  7. Rename the files (ex. Order Details Database to Order Details)
  8. Copy over the same table from the NewData or DemoData folder
  9. 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.