Resolving the error "database file appears corrupt ()"
Who is this article for?
Users who encounter the error when signing in to the desktop client.
No special permissions are required to resolve the issue.
If the application fails to start and displays a database checksum error, the local settings database file has likely become corrupted. This article explains how to fix the issue by deleting the corrupted file so the application can rebuild it automatically.
Issue
When you start the desktop application, you get this error message:
message: database file appears corrupt ()
bad checksum
checksum error on database page x
source: FirebirdSql.Data.FirebirdClient
target: Void Connect()This is caused by corruption to the local Firebird database file, which contains information about settings (e.g. contents of dropdown lists and other rarely-changing data).
Audit data is not affected.
Solution
Delete the local database file, vision.fdb.
This is at: %localappdata%\Vision\[instance]\LocalData
When you next launch the application, it will recreate the file.
If you see the error The action can't be completed because the file is open in Pentana.Tng.UI.Smart then the application is still running in the background.
Go to Task Manager, locate the process called Vision.exe (on the Details tab), and End task. Then try deleting the file again.