LockedCorrupt database

Author
ajw099
New Member
  • Total Posts : 2
  • Reward points: 0
  • Joined: 2015/07/23 15:03:28
  • Status: offline
2015/07/23 15:06:07 (permalink)

Corrupt database

Ever since I installed some windows updates today I've been getting the (attached) error.

The program functions properly, but the errors are a bit annoying. Does anyone have any insight into this?

Attached Image(s)

#1

2 Replies Related Threads

    IPSentrySupport
    Support Guy
    • Total Posts : 2079
    • Reward points: 0
    • Joined: 2006/05/16 21:55:52
    • Status: offline
    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.

    ---
    IPSentry Support
    RGE, Inc.
    http://www.ipsentry.com
    http://forum.ipsentry.com

    IPSentry® is a Registered Trademark of RGE, Inc.
    #2
    ajw099
    New Member
    • Total Posts : 2
    • Reward points: 0
    • Joined: 2015/07/23 15:03:28
    • Status: offline
    RE: Corrupt database 2015/07/24 20:50:38 (permalink)
    The compact command worked. Thank you!
    #3
    Jump to:
    © 2024 APG vNext Commercial Version 5.5