tAS400Input Component - Database Table Selecttor Error

Anonymous — Mon, 19 Dec 2016 17:47:37 GMT

Hi,
My tAs400Inut component works fine and can readd the table however if I attempt to use the Database Table Selector dialog I get a DB connection failure. These are the same parameters (without quotes) that is used by the raed component. Can anyone help regarding this ?
Database connection is failed.
java.lang.RuntimeException: java.sql.SQLException: The application requester cannot establish the connection. (Malformed reply from SOCKS server)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1092)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:301)
      at org.talend.designer.core.ui.editor.properties.controllers.DbTableController.checkConnection(DbTableController.java:769)
      at org.talend.designer.core.ui.editor.properties.controllers.DbTableController$6.run(DbTableController.java:558)
      at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
Caused by: java.sql.SQLException: The application requester cannot establish the connection. (Malformed reply from SOCKS server)
      at com.ibm.as400.access.JDError.throwSQLException(JDError.java:561)
      at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3342)
      at com.ibm.as400.access.AS400JDBCDriver.prepareConnection(AS400JDBCDriver.java:1414)
      at com.ibm.as400.access.AS400JDBCDriver.initializeConnection(AS400JDBCDriver.java:1251)
      at com.ibm.as400.access.AS400JDBCDriver.connect(AS400JDBCDriver.java:390)
      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
      ... 6 more
Caused by: java.net.SocketException: Malformed reply from SOCKS server
      at java.net.SocksSocketImpl.readSocksReply(Unknown Source)
      at java.net.SocksSocketImpl.connect(Unknown Source)
      at java.net.Socket.connect(Unknown Source)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      at java.lang.reflect.Method.invoke(Unknown Source)
      at com.ibm.as400.access.PortMapper.getSocketConnection(PortMapper.java:266)
      at com.ibm.as400.access.PortMapper.getServerSocket(PortMapper.java:161)
      at com.ibm.as400.access.AS400ImplRemote.signonConnect(AS400ImplRemote.java:2363)
      at com.ibm.as400.access.AS400ImplRemote.signon(AS400ImplRemote.java:2278)
      at com.ibm.as400.access.AS400.sendSignonRequest(AS400.java:3142)
      at com.ibm.as400.access.AS400.promptSignon(AS400.java:2706)
      at com.ibm.as400.access.AS400.signon(AS400.java:4035)
      at com.ibm.as400.access.AS400.connectService(AS400.java:1184)
      at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:3334)
      ... 11 more

Re: tAS400Input Component - Database Table Selecttor Error

Anonymous — Tue, 20 Dec 2016 07:39:38 GMT

Hi,
It seems your Socks proxy didn't work well. Is your network working well for you?
Please check that your connection is successful while creating it. It should be a connection or a network problem. On which build version you got this issue?

Best regards
Sabrina

Re: tAS400Input Component - Database Table Selecttor Error

Anonymous — Tue, 20 Dec 2016 10:44:01 GMT

HI Xdshi,
As far as I am aware I have loaded the latest version. I am completing a critical POC and really need this to work asap. The version I have is :- TOS_DI-20161026_1219-V6.3.0

Re: tAS400Input Component - Database Table Selecttor Error

Anonymous — Thu, 22 Dec 2016 08:52:50 GMT

Hi,

Is your network working well for you? Could you please confirm it?

Best regards

Sabrina

topic Re: tAS400Input Component - Database Table Selecttor Error in Talend Studio

tAS400Input Component - Database Table Selecttor Error

Re: tAS400Input Component - Database Table Selecttor Error

Re: tAS400Input Component - Database Table Selecttor Error

Re: tAS400Input Component - Database Table Selecttor Error