Repair or Restore?

The message "Repair or Restore the database" happens when the program notices upon start-up that the previous time it started that it did not start successfully. In practice this can be caused by

  1. The database is actually corrupt. This is actually very rare. It's common for users to read the error message quickly and misinterpret ""appears to be corrupted" as a definitive diagnosis.
  2. The database is stored on a network server and that location is no longer accessible.
  3. The program is confused. This is the most common cause.

Here are steps recommended to fix it.

This probably won't help because statistically speaking most computers are running just fine but it couldn't hurt. Of the several steps listed on the General Maintenance page, rebooting all computers involved especially the server is the most important.

Step 1 - Determine Database

The key to working on this problem is determining the database file your installation of HICSOAP is configured to automatically open when it starts.

Step 2 - Verify Network Locations

Regarding possible cause #2, sometimes a customer moves the database to a network drive and it works fine. But then at some point the network location or drive letter becomes unavailable. This might be the case for you. Double check that where the database is stored is accessible using Windows Explorer (not Internet Explorer). And verify that the file actually exists. If the file exists at the expected location, then you should verify you can have read/write access by saving a file to the folder using Notepad or some other program.

Step 3 - Repair

  1. Update all workstations to the same (ideally latest) version.
  2. Close HICSOAP on all workstations and reboot those computers.
  3. Start the program from one of the workstations.
  4. It may prompt with REPAIR/RESTORE again. In which case, choose REPAIR.

It may then simply work but if it doesn't...

Step 4 - Just Say No

  1. Start the program from one of the workstations.
  2. It may prompt with REPAIR/RESTORE again. In which case, choose NO.

It may then simply work but if it doesn't...

Step 5 - Use existing database

It should ask if you want to create a new, blank database or restore from a backup or open an existing database. Click to open an existing database and choose your existing database.

It may then simply work but if it doesn't...

Step 6 - Use blank database

  1. Close the program.
  2. Rename the database file. For example, if in Step 1 you determined your database file was z:\HicDatabase.hdf you could rename it to z:\HicDatabaseProblem.hdf.
  3. Then start HICSOAP and when prompted to REPAIR/RESTORE, choose NO. Then when prompted to create a new database, please do so.
  4. Close and open the program a couple times to verify that it's working with a new/blank database.
  5. Close the program.
  6. Rename the new, blank database to blank.hdf.
  7. Rename the original database (from step #2) back to its original name. So that when HICSOAP is started it will open this database.

It may then simply work but if it doesn't...

Step 7 - Restore from backup

Repeat the steps so that the database with your data is renamed and it's working with a new, blank database. Then restore from a backup, MAIN MENU -> DATABASE -> RESTORE.

If this doesn't fix it then you could try restoring from an older backup. Or you could try uninstalling and re-installing the program.

Specific Causes

Since this error message can be caused by so many different things, I thought it would be helpful to share some specific causes.

  1. After a server crashed and was re-built the file permissions on the HicDatabase.hdf file were not set properly. So my client did not have read/write access to the database. I diagnosed this by trying to rename the database file and I was not able to.