EM experiencing High resources and data roll off banner.
Product
Enterprise Manager 23.03 Windows 10
Steps to Reproduce
Log into EM and if you see a Red Roll Off Banner.
Check system resources for high CPU and Memory.
Check Data Roll off logs for the following error.
psycopg2.errors.ForeignKeyViolation: update or delete on table "organization_enterpriseuser" violates foreign key constraint "auditlogger_auditlog_user_id_fbf03342_fk_organizat" on table "auditlogger_auditlog"
DETAIL: Key (id)=(2) is still referenced from table "auditlogger_auditlog"
Expected Results
We should not see high Resources and Data Roll Off Banner.
Actual Results
High Memory, CPU, and Red Banner Data Roll Off.
Solution
Update to exacqVisionEnterpriseManager_23.06.101.0_x64.exe or official EM release 23.06.
Enhancement – Integration of WiseAI analytics from Hanwha
Enhancement – Enhanced camera discovery for new Illustra Flex Dual Sensor camera (AESW-5541)
Enhancement – Server installer no longer checks Illustrapi or Illustraflexpi for install by default
Enhancement – Changed the reported name to “Illustra Multisensor”
Enhancement – Added legacy tag to Illustrapi and Illustraflexpi
Enhancement – Added support for Axis “Optics Control” autofocus (AESW-2649)
Enhancement – Added support for Bosch “RuleEngine” analytics (AESW-1326)
ExacqVision Client
Bug Fix – wxWidgets version upgrade New installs, not upgrades, automatically select dark or light theme based on the OS theme and prevent user changes (AESW-5146)
Enhancement – Copy selected camera information when adding a new camera If camera is highlighted in IP Cameras List on the Add Cameras page when the New button is clicked, the Device Type field will automatically populate with the same as that which was highlighted saving time from selecting from Device Type list. (AESW-5855)
ExacqVision Web Service
Bug Fix – Updated nvrg version to fix group type retrieval, fixes issue with group items (AESW-3340)
Bug Fix – Updated nvrg version to fix a soft trigger bottleneck, fixes issue where triggers from web or mobile client resulted in status flickering between ‘Alarm’ and ‘Normal’ in Desktop Client. (AESW-3816)
ExacqVision Enterprise Manager
Bug Fix – Improved logging for DynamicDNS files for Integrator Service Portal (AESW-5897)
Themes were added in ExacqVision Client version 8.04, permitting the Desktop Client to be customized to an operator’s preference.
With the release of ExacqVision Client 19.03, new client installs defaulted to the Light theme in place of the Classic theme.
Problem
Updating to ExacqVision Client 23.06 has changed my Client theme.
I cannot change my Client theme / The theme selector is greyed out.
Explanation
With updates made to the underlying ExacqVision Client code, on Windows systems the Client now respects the color options selected for the operating system.
Windows 10/11
Under ‘Settings’ > ‘Personalization’ or right-clicking the Desktop and selecting ‘Personalize’, navigate to the ‘Colors’ menu.
From this menu, the top-most drop down, labeled ‘Choose your color,’ offers Light, Dark, or Custom options.
If ‘Light’ is selected the Client will open with the Light theme chosen. Navigating to the ‘Client’ node on left-side configuration tree will allow the user to select from Light, Dark, or Classic themes for the ExacqVision Client. <br><br>
If ‘Dark, is selected, the Client will open with the Dark theme automatically chosen. However, the theme selector on the Client Settings page will be “greyed out,” preventing user changes. <br>
<br><br>
If ‘Custom’ is selected, some further options appear below. There is a section labeled ‘Choose your default app mode’.<br> <br><br>
If ‘Light’ is selected the Client will open with the Light theme chosen. Navigating to the ‘Client’ node on left-side configuration tree will allow the user to select from Light, Dark, or Classic themes for the ExacqVision Client. <br><br>
If ‘Dark is selected, the Client will open with the Dark theme automatically chosen. However, the theme selector on the Client Settings page will be “greyed out,” preventing user changes.
These Color selections are user-based, meaning that two user accounts on the same system may have different Color settings their Windows environment. Each choice will affect how that logged in account views the ExacqVision Client.
Google Chrome is the recommended browser for Cloudvue and Cloudvue Manager. Other browsers may cause issues or limit some features within the program. If you are having issues with other browsers, you should see if the issue persist when using Chrome.
If you are having issues with Google Chrome, you should run the Cloudvue program using Chrome’s incognito mode to rule out installed extensions or cache related issues.
If a cache related issues, you should clear your “Cookies and site data”.
At times it may be necessary to remove video devices from customer accounts. The following steps outline how to safely remove inactive devices.
Product
C2C
Cloudvue Gateway
Solution
Note: Ideally the following steps should be performed by the integrator. Support can do all the steps as well but should avoid removing subscriptions (see below)
Access the customer’s account in Cloudvue Manager
Expand Video Devices and select the desired device
Expand Subscriptions and uncheck the subscription and save. (If it says checkout this should be done by the partner staff that originally created the subscription for correct prorations to be applied)
Expand Users and Remove all users from the device
For Cloudvue Gateways expand Cameras and remove all cameras from the device
Edit the Device and set the Partner and Account to Inactive (this removes the device from their manager portal and requires help from support )
With Artificial Intelligence being used more often users may notice a spike in the analytic metadata being processed and stored. Here are our recommendations to manage this increase.
Update exacqVision Server/Client Software
Ensure you are running the latest version of both exacqVision Server and Client software.
Search “updating” in the exacqVision Client User Manual, available Here for information on updating.
Adjust Camera Settings
Access Analytics from the camera’s configuration GUI page
Only those analytic types required by the customer should be enabled
The goal is to keep this setting as minimal as possible, while still achieving the customers goals.
These settings decide when older items should be removed or “Purged” from the Database (eventPI), the lower the value, the less storage needed.
It is recommended to set this value as low as possible and adjust based on available storage when data is processing
Customer retention requirements must also be considered.
Disable Analytics
Each camera is different, but if the user does not have enough storage for 24 hours of analytics, or if analytics are not needed, currently the best option is to disable the analytics completely.
Within the exacqVision Client software, go to Configuration → Server → Configure System → Add IP Cameras → Camera Recording → Analytics Camera → Analytics tab – Uncheck “Record analytic data”
<br><br>
<br><br>
