After upgrading from Strategy 2019 Update 1 to Strategy 2019 Update 2, it takes much longer to start the Intelligence Server.
In 2019 Update 1, it took one minute to load three projects. In 2019 Update 2, it takes eight minutes to load the same three projects from the same metadata. However, when the timezone settings are changed, the server loads quickly again.
During the Intelligence Server startup, the database connection cache is expired at the moment it was created. In this instance, the server is incorrectly using the coordinated universal time to calculate the database connection cache expiration time but using the local time to check whether the database connection is expired or not.
This issue can be reproduced if the timezone is set to UTC + 10:00 / UTC + 11:00 / UTC + 12:00.
This issue has been fixed in Strategy 2019 Update 3. To take advantage of the fix, upgrade to the latest version of Strategy.
For an immediate solution, you can modify the timezone of the Intelligence Server operating system to UTC-5 (EST).
There is no need to change the timezone on the client machine since Strategy supports different timezones between the Intelligence Server and clients.
