Product:TIBCO Spotfire Analyst
Versions:7.11.x and above
Summary:
Fail to create a new TIBCO Data Virtualization connector connection with error "Connection Failed"
Details:
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()
===================================
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
Versions:7.11.x and above
Summary:
Fail to create a new TIBCO Data Virtualization connector connection with error "Connection Failed"
Details:
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()
===================================
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
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.