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

Article Id: 111644

Status: Published

Updated On: 28-08-2018 06:50

Products:

DSERIES- SERVER , CA 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.

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.

Environment:

CA Workload Automation DE R12
MS-SQL Database 2016

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.