Introduction In some Environments it may seem logical to deploy a second Enterprise Manager server for user and NVR management. Although alternate configurations can be deployed, it is discouraged and currently unsupported to connect an ExacqVision NVR to more than one instance of Enterprise Manager simultaneously – this will create ownership, database, and management conflicts. … Continue reading Connecting an NVR to more than one Enterprise Manager server
Tag: Database
Enterprise Manager Installation Fails Due to Residual PostgreSQL Components on Windows Systems
Description On Windows systems, the Enterprise Manager (EM) installer may fail even on fresh installations when orphaned remnants of previous PostgreSQL components remain. Problem The Enterprise Manager installer will detect remnant/orphaned files, often from previous installation attempts, and proceed with attempting Postgres updates instead of Postgres new installation/DB, eventually likely resulting in the following error… Continue reading Enterprise Manager Installation Fails Due to Residual PostgreSQL Components on Windows Systems
Updating Database Credentials or Webservice Port in Exacq Enterprise Manager
Description Warning: Level 2 Document – Please do not distribute. If you need to update the database username, database password, or webservice port settings for Exacq Enterprise Manager (EM), follow the steps below. NOTE: These instructions apply to both Windows and Linux installations. Product ExacqVision Enterprise Manager Steps to change values: 1. Open a… Continue reading Updating Database Credentials or Webservice Port in Exacq Enterprise Manager
Dropping and Creating the smartvuedb Database
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
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