How to repair a damaged Derby database?

Very often problems with the Derby database are due to disk damage, or lack of free space. Before repairing the database, check the hard drive.

To repair the database, you need to:

  1. Run the recovery.bat file (it is located in the aSISt home directory),
  2. Answer YES to the question: “Do you want to perform the derby repair process?”,
  3. Indicate the last backup (for example: asist_backup_5.11_2015-01-15_11-30-32.zip). To repair the database, use a backup that was made from the same application installation.

When the database repair process is complete, an informational message will appear that the database repair is done.

If the damage to the database is too severe, it is not possible to repair it.