RE: Corrupt database
2015/07/23 19:17:36
(permalink)
That error can occur if the graphing detail database has exceeded the 2GB limit (by default it is an access database if you did not upsize to SQL server).
Check the Detail Graphing Statistics retention period you have defined in system options. We have found that approximately 29 million data samples can be held in the MS Access database, so if you have many entries being monitor and are logging detail stats on all of them and have your retention period set to a very long time, you will need to reduce the retention period.
Next, perform a compact database from the Tools menu option.
If the error persists, it is possible that the database was corrupted. It may be repairable with MS Access directly or you can restore from a system backup.
The final option is to remove IPGData.MDB and have the system re-create the database and start logging from that point.