How to drop Deskzilla indexes

From ALM Works Knowledge Base

Starting from Deskzilla 1.2, it's now possible to drop indexes right from the application by using menu "Tools" - "Drop Indexes". Anyway, it's a good idea to restart application after that.

Reason: Clean corrupt indices from the system. Corrupt indices may result in inconsistent data presented in the application, such as queries that return incorrect result.

Result: Deskzilla will recreate required indices from scratch, "forgetting" possible data corruption.

Procedure:

• Shut down Deskzilla if it is running.
• Start Deskzilla with drop.index option.

On Windows:

   deskzilla.exe -J-Ddrop.index=true

Elsewhere:

   java -Ddrop.index=true -jar deskzilla.jar

• When Deskzilla starts, check if the problem (that was the reason to drop indices) is gone.
• If the problem is still there, contact Deskzilla Support.

Alternative Procedure: As an alternative, to the above procedure, you can just remove all "bi.*" files in "workspace\db" directory under Deskzilla home page. Be careful not to remove "universe.db" file, which contains data. The removal should be done when Deskzilla is not running.

What's next: This procedure should be applied for fixing data consistency problems. If for some reason you're having these problems constantly, you may always start Deskzilla with this option turned on. The cost of clearing indices is time that Deskzilla needs to rebuild them.