[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.
- Stop the Genetec™ Server service.
- In the Security Center installation directory, navigate to \ConfigurationFiles\GeneralSettings.gconfig.
- 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" />
.
- If it is there, modify the
- Save the file and restart the Genetec™ Server service.
- 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.