Description At times it may be necessary to drop (delete) and create the smartvuedb database. WARNING VIDEO LOSS is expected, and except for rare occasions this should only be performed on newly deployed NVRs. Product Cloudvue Gateway Prerequisite Solution Issue the following commands from terminal ** WARNING ** WILL RESULT IN VIDEO LOSS <code>sudo service… Continue reading Dropping and Creating the smartvuedb Database
Tag: Database
Artificial Intelligence Object Classification Event Triggers Filling OS Drive
Description We have found that event links based on triggers from AI Object Classification events flood the eventPI database resulting in the OS drive being filled in a short amount of time. Periodic unexpected crashes, system reboots and increased memory usage have resulted. This happens when the amount of AI metadata captured in the eventPI… Continue reading Artificial Intelligence Object Classification Event Triggers Filling OS Drive
Cloudvue Gateway Camera Already Exists
Description When attempting to add a camera to the Cloudvue Gateway an error message appears “Camera Already Exists”. Typically, this happens when the local database is out of sync with the cloud database. Removing the camera from the local database then re-adding triggers a new sync which resolve the issue. Below are instructions for removing… Continue reading Cloudvue Gateway Camera Already Exists
Invalid column error after updating Enterprise Manager using MSSQL database from 21.12 or lower to 22.06 or higher
Description If you are using mssql database with EM and updating from 21.12 or lower to 22.06 you will get the crying stickman when trying to log into the web gui. When checking the webservice logs you will get invalid column errors such as.. ][ODBC Driver 17 for SQL Server][SQL Server]Invalid column name ‘lastSaveOrUpdate’. (207)… Continue reading Invalid column error after updating Enterprise Manager using MSSQL database from 21.12 or lower to 22.06 or higher
Search for Serial Data unexpectedly fails to return results
Description When set to record, exacqVision Server stores serial data in a database called pospi.db Default locations are: After verifying that serial data is configured correctly and data is being received if searches fail to return results for serial events check the exacqVision Server logs for entries similar to the following. These messages are indicating… Continue reading Search for Serial Data unexpectedly fails to return results