Products | Versions |
---|---|
Spotfire Statistics Services | All Versions |
Due to known vulnerabilities that have been reported against SSL and earlier versions of Transport Layer Security (TLS), it is recommended to upgrade to TLS 1.2 for secure communication. However after enabling TLS 1.2, it may happen that existing working connections of TIBCO Spotfire Statistics Services (TSSS) to the jobs database may stop working, and instead sees an error like:
The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL)
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'com.insightful.splusserver.SplusStateInitializer#0' defined in class path resource [applicationContext-job-execution.xml]: Invocation of init method failed; nested exception is org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed. ClientConnectionId:7c930e69-ee98-4358-88b4-87e608944d78".)
#Bootstrapped by default #Tue Apr 10 21:15:04 PDT 2018 database.password=3DES{tSrd6Kwp+0OY5clP6/YVMA\=\=} database.url=jdbc\:sqlserver\://11.22.33.44\:60210;DatabaseName\=TSSS-JOBS;sslProtocol=TLSv1.2 database.type=MSSQL database.maxActive=1 database.username=sa jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver database.maxIdle=1Restart the TIBCO Spotfire Statistics Services (TSSS) server services after making the above changes.