The DELETE statement conflicted with the REFERENCE constraint “auditlogger_auditlog_user_id_fbf03342_fk_organization_enterpriseuser_id”. The conflict occurred in database “NA”, table “dbo.auditlogger_auditlog Description when the Datarolloff service is failing to start you may see this error or a similar error in the datarolloff log file. There is a foreign key constraint that is failing to delete which in turns stops… Continue reading The DELETE statement conflicted with the REFERENCE constraint “auditlogger_auditlog_user_id_fbf03342_fk_organization_enterpriseuser_id”. The conflict occurred in database “NA”, table “dbo.auditlogger_auditlog
Category: exacqVision Enterprise
Starting ElasticSearch service with a service account
Description In some production environments, service accounts are used to run Enterprise Manager services. In order for the ElasticSearch to run it creates a tmp directory from the account it was installed under, this can cause the service to not run if you try starting the service as a different user. there are two ways… Continue reading Starting ElasticSearch service with a service account
Corrupted Failover group causing EM to drop servers
Issue When running EM version 22.09 or lower if you see your servers constantly connecting and then disconnecting, please check the EM logs specifically the importer log you should find something similar to this log.. [02/Dec/2022 09:52:52] WARNING [MainProcess:6016,Thread-1:8532,importer.py:292] FailoverProcess died unexpectedly[02/Dec/2022 09:52:52] INFO [MainProcess:6016,Thread-1:8532,importer.py:575] Shutting down brain.[02/Dec/2022 09:52:52] INFO [MainProcess:6016,Thread-1:8532,importer.py:444] Cleaning up importer resources[02/Dec/2022… Continue reading Corrupted Failover group causing EM to drop servers
EM Editing the Group ROOT Synchronization Conflict Resolution Option
Knowledge Base Article Template Description EM does not allow for the Root Group to select the option of Synchronization Conflict Resolution for Automatically Resolve Conflicts and remove Unauthorized Users as seen below. Note: That even on a New Group- that the Group Name Needs to be provided and the Synchronization Conflict Resolution is able to… Continue reading EM Editing the Group ROOT Synchronization Conflict Resolution Option
2022-12 September Quarterly Release Training
ExacqVision Server Bug Fix – Fixed issue preventing archiving of analog video to Cloud Drive Bug Fix – Motion Detection not working on Holis cameras Bug Fix – Corrected issue setting NTP server for illustra3pi and illustramultipi camera plugins Bug Fix – Fixed issue with missing frames from PTZ cameras causing image tearing in recorded… Continue reading 2022-12 September Quarterly Release Training
Unexpected Results When Updating Groups or Users in exacqVision Enterprise Manager
Description Customer was getting odd results when trying to edit the name of either a group or username in EM. Product exacqVision Enterprise Manager 21.06exacqVision Enterprise Manager 22.09 Steps to Reproduce From the EM dashboard access either Users or GroupsSelect an existing user or group Click the pencil icon to edit Change the name of… Continue reading Unexpected Results When Updating Groups or Users in exacqVision Enterprise Manager
Using NT authentication when connecting to MSSQL database
ExacqVision currently doesn’t support NT authentication when validating credentials to a MSSQL database (Enterprise Manager), we require to use SQL server authentication. A feature enhancement ticket has been submitted for NT authentication.
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
The failover is not working on the EM, and the protected server is stuck on Failed over however, the spare server is still on standby mode.
Issue The failover is not working on the EM, and the protected server is stuck on Failed over however, the spare server is still on standby mode. When checking the EM logs, it shows. Solution This issue has been fixed on Exacq EM version 22.09.2.0 or newer.
Enterprise Manager’s “Root” group has special privileges
DescriptionIf any user is a part of the “root” group in Enterprise Manager this grants that specific user special admin privileges regardless of what type of user OR user role that they are in. In example.. If a user is tied to a user role where they cant seen specific cameras on a server but… Continue reading Enterprise Manager’s “Root” group has special privileges