CA Workload Automation DE keeps loosing connection to the database. The following messages are see in the tracelogs
[relationaldatabase] [ERROR] SS.script_runner_179:  Exception: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server returned an incomplete response. The connection has been closed. ClientConnectionId:xxxxxa37-05d6-4f67-b606-xxxxxxxxxxxx". com.microsoft.sqlserver.jdbc.SQLServerException: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption.
The connection issue is due to JDBC driver. For more details refer to this Microsoft link.
Note: The JDBC driver is maintained and provided by the database vendor.
CA Workload Automation DE R12
MS-SQL Database 2016
Upgrade CA Workload Automation DE to R12 SP2 or above.
The R12 SP2 comes with JDBC 4.2 version.
If the the problem persists, then follow Option 2 as suggested by Microsoft in this link.