CA WA DE loses connection to MS-SQL with Exception: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
book
Article ID: 111644
calendar_today
Updated On:
Products
DSERIES- SERVERCA Workload Automation DE - System Agent (dSeries)
Issue/Introduction
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.
Environment
CA Workload Automation DE R12 MS-SQL Database 2016
Cause
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.
Resolution
Upgrade CA Workload Automation DE to R12 SP2 or above. The R12 SP2 comes with JDBC 4.2 version.
Additional Information
If the the problem persists, then follow Option 2 as suggested by Microsoft in this link.