How to resolve "unable to open the data source" issue being observed after updating SSL certificates on TIBCO Data Virtualization server?

How to resolve "unable to open the data source" issue being observed after updating SSL certificates on TIBCO Data Virtualization server?

book

Article ID: KB0071759

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization 8.4.X, 8.5.X, 8.6.X

Description

After replacing the default SSL certificate with a new certificate and then disabling HTTP, you might be able to connect to Studio using the Encrypt button, and can open introspected views/tables and execute them successfully.
However, any attempt to open a data source (even the sample ds_orders data source) results in an error dialog popping up with the following message: java.io.IOException:

An exception occurred while executing a request: "handshake 1 1".  Cause: "Remote localhost/127.0.0.1:9703 has prematurely closed the connection. Last received message is 'null'.[jdbc-1908515]".[jdbc-1906507]

User-added image
 
In this article, we will discuss how to resolve this issue.

Environment

Windows

Resolution

Follow the below steps to resolve this issue:
  • Verify that TDV the Keystore alias and the Keystore are configured correctly with the required certificate entries present in them.
  •  Check  studio.bat to ensure that it is pointing to the correct truststore as shown below:
    •     set TRUSTSTORE_FILE=D:/TIBCO/Security Certificates/cis_server_truststore.jks 
  • Connect to the TDV Web Manager using the TDV server HTTPS URL, and verify that the browser displayed the new certificate. If the trusstore is missing the cert then export the 3 certificates in the certificate chain as 3 separate files, using the browser's Export option. Next, import each of the 3 files into the truststore used by Studio.
  • Check if the target data source's truststore contains the new certificate located at  <TDV_INSTALL>\apps\jdbc\cis_jdbc_truststore.jks (refer to the below image ). If the certificate entry is not present here then import the certs and restart the server to resolve the issue.
User-added image
 

Issue/Introduction

How to resolve "unable to open the data source" issue being observed after certificate change on TIBCO Data Virtualization server.

Additional Information

How-to-create-a-new-self-signed-SSL-certificate-and-configure-TIBCO-Data-Virtualization-to-use-the-certificate