Table of Contents

Index does not exist

Explanation

Resolution

  1. Open the NewData folder (If customer is running 8.91, rename the Data folder, then change the NewData folder to Data and open Cyrious so it will update the tables. Then shut down Cyrious and the SSLIP. Then rename the Data folder to NewUpdatedData and the original Data folder back to Data)
  2. Find the files for the particular table is missing the index
  3. Copy the files ending in XGn and YGn files for those tables (where n is a number). These are the secondary index files.
  4. Open the Data folder
  5. Paste (Ctrl-V)
  6. Rebuild that table using dbrebuild

Note: You can only rebuild the secondary indexes. If the primary index (PX) file is missing or the above approach doesn't work, you will need to use the next approach.

Resolution 2

  1. Open DBBrowser to look at the Data
  2. Open a second DBBrowser and create a temp alais looking at the NewData folder
  3. Arrange the two applications so that they're side by side
  4. Go through and look at each table to see which one from the live tables is missing the particular index the system was referring to
  5. Once table(s) have been located, close each of the DBBrowsers
  6. Open the Data folder and rename *.db and *.mb files (i.e Order Database.db becomes Order.db) for the table missing the indexes
  7. Deleted the remaining indexes for that table
  8. Go into the NewData folder and copy all table files that would replace the live tables files that had the index errors.
  9. Open DBBrowser
  10. Select SQL tab up top
  11. Select the Advanced tab in the middle of the screen.
  12. Run SQL below to transfer all records from the bad table to the new table.
  13. Open application and test area that was causing problem to see if problem is resolved.
  14. dbrebuild

SQL

INSERT INTO "[New Table]"
SELECT *
FROM "[Old Table]"