[KBA-79127] ALPR Manager role in warning state after upgrading to Security Center 5.11.0.0 - Security Center 5.11.0.0

Applies to
Security Center 5.11.0.0
Last updated
2022-09-16
Internal reference number
3244313 3244316 3244727 3244750
Content type
KB articles
Language
English
Product
Security Center
Version
5.11

[KBA-79127] ALPR Manager role in warning state after upgrading to Security Center 5.11.0.0

After upgrading to Security Center 5.11.0.0, the ALPR Manager role is in a warning state.

Applies to

Security Center 5.11.0.0

Cause

This issue happens when the database schema upgrade script cannot complete in the allotted time and eventually times out.

Because of the structure and the size of the ALPR database, the schema upgrade takes longer than the default upgrade timeout of 20 minutes.

Workaround

Increase the upgrade timeout parameter on servers running the ALPR Manager role.

  1. Stop the Genetec™ Server service.
  2. In the Security Center installation directory, navigate to \ConfigurationFiles\GeneralSettings.gconfig.
  3. In Notepad running in administrator mode, search for sqlUpgradeItem.

    Do one of the following:

    • If it is there, modify the SqlCommandTimeout value to 7200 (2 hours) or more.
    • If it is not there, add this line: <sqlUpgradeItem SqlCommandTimeout ="7200" />.
  4. Save the file and restart the Genetec™ Server service.
  5. The ALPR Manager should be able to complete the schema upgrade.

    The schema upgrade might take several hours for large databases.

Status

This issue will be resolved in Security Center 5.11.1.0.