Version 10.1.2.1
important
Release date: April 17, 2020
This patch addresses the issue where a malfunctioning database connection could cause all Business Processes to freeze for up to two hours. After the freeze, everything resumed working normally.
The root cause of the issue was that the Quartz connection to the database got stuck at one of the possible levels: TCP socket (networking), connection to the database (MS SQL), or a lock for commit (queries).
To address the issue, two Control Tower properties were added to configure the database connection for the Quartz Job Scheduling library:
- The
ct.quartz.datasource.property.lockTimeoutproperty sets the number of milliseconds to wait before a timeout occurs on acquiring a database lock. - The
ct.quartz.datasource.property.socketTimeoutproperty sets the number of milliseconds to wait before a timeout occurs on a socket read. For more information, refer to the SocketTimeout documentation.
Before this patch, the default timeout settings were set at 0 (infinite). Now, both properties are set by default at 60000 milliseconds (60 seconds) in the workfusion.properties file.
note
For update information, refer to the Upgrade from 10.1.2 to 10.1.2.1 guide.
This patch supports a rollback to the previous v10.1.2 release.