License Server will not start due to a slow SQL query for unreleased licenses
Issue date | August 6, 2019 | |
Observed behavior | License Server will not start when a large amount of data exists in the LicenseUsageEvents table in the VHT_RPT database. | |
Products and versions affected | Virtual Hold Callback version 8.10.0-8.11.3 | |
Components affected |
| |
Applications affected | QueueManager | |
Severity | Major | |
Root cause | There is no index on the LicenseUsageEvents table in VHT Callback® version 8.11.3 and below, and License Server queries this table during startup. When a large number of records are present in the table, the resulting delay in query responses can cause License Server to reach its five-second timeout and fail to start. | |
Resolution | Upgrade to Callback version 8.12.0 or later | |
Expected availability | VHT Callbackversion 8.12.0 | |
Workarounds | Execute the following SQL script on the VHT_RPT database. The script creates an index on the LicenseUsageEvents table to increase the efficiency of queries executed on this table.
| |
Defects related to this issue | 167325992 | License Server unable to start after server patching due to the size of the LicenseUsageEvents table. |