Database errors "sqlite_exec failed with 11 (database disk image is malformed)"

fodil1 8
Viewed 0

HI,

I got an email showing an error in the database and I don't know how to acces to the sqlite server.

Any ideas?

System Error Detected: Database error

sqlite_exec failed with 11 (database disk image is malformed ExtErr=11) for SQL=[begin;SELECT Date, Value FROM StatData WHERE StatID=46 ORDER BY Date DESC LIMIT 1;;

end;]. Will re-open.

Ver 5.6.0 (Build 163)

sqlite-exec malformed database
2 Answers

Hi fodil1,

If you look in your service log file you will find this error message. in a entry before this message you will see the name of the database file that is malformed. Once you find the name you will need to stop the service and then delete that file. Once you start the service back up and monitors start to record data the service will recreate that file. Unfortunately, the data in that file is corrupt and you can't save it.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

Quinn2713

Hi,

The technical support give me that solution and It worked.

  1. Stop the PA Server Monitor service
  2. Delete the C:Program FilesPA Server MonitorDatabasesPingResponse.db file
  3. Start the PA Server Monitor service

thank you,

fodil18
Related