Fail to create a new TIBCO Data Virtualization connector connection with error "Connection Failed"
Article ID: KB0075616
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | 7.11.x and above |
| TIBCO Data Virtualization | All versions |
Description
When trying to create a new TIBCO Data Virtualization Connector connection receive the below error:
Below error returned in the Analyst/client "Spotfire.Dxp.SupportDiagnostics.log" file:
==================================
DEBUG Spotfire.Dxp.Data.Adapters.Composite.CompositeAdapterConnection [(null)] - Failed to connect.
Composite.Data.Common.SQLException: Connection failed ---> System.IO.IOException: Exception occurred while executing request 'handshake 3 3': Socket closed on server[ADO.NET-1906507] ---> System.IO.IOException: Socket closed on server
at Composite.Data.CompositeClient.ReplySelectThread.Run()
===================================
Below error returned in the Analyst/client "Spotfire.Dxp.SupportDiagnostics.log" file:
==================================
DEBUG Spotfire.Dxp.Data.Adapters.Composite.CompositeAdapterConnection [(null)] - Failed to connect.
Composite.Data.Common.SQLException: Connection failed ---> System.IO.IOException: Exception occurred while executing request 'handshake 3 3': Socket closed on server[ADO.NET-1906507] ---> System.IO.IOException: Socket closed on server
at Composite.Data.CompositeClient.ReplySelectThread.Run()
===================================
Issue/Introduction
Fail to create a new TIBCO Data Virtualization connector connection with error "Connection Failed"
Environment
All Supported OS
Resolution
The above error is generally returned when the port number used is incorrect.
To verify the port number>Logon to TDV studio and navigate to Administration>Configuration>Server> Web Services Interface>Communications>HTTP> Port (on Server Restart) or Port (Current)
For e.g in the below example for the ADO.NET it will be 9400+1 i.e 9401
To verify the port number>Logon to TDV studio and navigate to Administration>Configuration>Server> Web Services Interface>Communications>HTTP> Port (on Server Restart) or Port (Current)
For e.g in the below example for the ADO.NET it will be 9400+1 i.e 9401
You may also receive this error if the TDV ADO.NET connector used is of older version. You can get the appropriate version of the drivers from the https://edelivery.tibco.com/ e.g. you can download TIB_tdv_drivers_8.2.0_all.zip for the TDV 8.2.0 ADO.NET driver.
Additional Information
Feedback
Yes
No
Powered by
