Having a functioning database is critical to BI performing correctly. If there are database read/write errors, then bad things happen like recordings/alerts go missing.
Many users do not realize this, but the Clips list, Alerts list and Timeline are visual representations of records stored in the database.
Basics
Make sure you followed best practices. FYI, reviewing entire Windows tuning article is always beneficial.
Clips missing
Does BI indicate it is no longer recording? In the filter by date image below, it appears as though BI stopped recording from Jan 4 - Jan 21 (no red dots).
Not sure yet if BI actually stopped recording or the Database is no longer being updated. An easy check is to run Repair/Regenerate (see below) and see if BI can resolve the issue. Another easy check is to open your New folder and see if new recordings are being created by BI. If so, the issue is with writing to the Database. Look for database errors in the logs.
If new recordings are not being created, you probably have a storage issue or recording issue.
Database tools
- record framework_calendar.png (193.84 KiB) Viewed 33460 times
Not sure yet if BI actually stopped recording or the Database is no longer being updated. An easy check is to run Repair/Regenerate (see below) and see if BI can resolve the issue. Another easy check is to open your New folder and see if new recordings are being created by BI. If so, the issue is with writing to the Database. Look for database errors in the logs.
If new recordings are not being created, you probably have a storage issue or recording issue.
If you right click in the Clips list -> Database section, you have access to the database maintenance functions. Help provides details on each function. Repair/regenerate is often used when users notice clips/alerts are missing from the Clips list/Alerts list.
Log files
- database troubleshooting_maintenance functions.png (117.63 KiB) Viewed 33502 times
The logs will tell you if BI is having issues with your Database. In order to know which errors to look for, we are documenting all the Status log errors. The ones concerning the database are in the Database category. Each log error provides details and possible fixes to self-correct.
The Log files article explains how to easily deal with log files using excel.
Camera stats
The Log files article explains how to easily deal with log files using excel.
If particular cameras are missing alerts, the usual issue is lack of key frames. See key frame ratio section for details.
Issue
Clearly describe the issue. If the issue resides with a remote endpoint, confirm whether there is also an issue in the console. If you tried the Database maintenance commands, please share. Anything else you tried.
Storage
Screenshot of Alerts folder settings.
Screenshot of the Status button -> Storage tab
Camera stats
Screenshot of the Status button -> Storage tab
Status button -> Cameras tab -> Export
Logs
What do the logs say? Copy/paste the exact error events from the log file or screenshot the Logs tab.