java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Rajset — Sat, 16 Nov 2024 01:16:11 GMT

Hi,

Is there a way to

make provision for talend context parameters in CSV file used while importing the filedelimited connection in metadata repository? We have our context parameters set in our RHEL talend server as CSV and while running we get the below message - could be something missing ?

Exception in component connectionStatsLogs ( )

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)

at java.sql.DriverManager.getConnection(Unknown Source)

at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)

at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.connectionStatsLogsProcess( .java:15025)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.preStaLogConProcess( .java:1008)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS( .java:19822)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main( .java:19282)

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)

... 12 more

Caused by: oracle.net.ns.NetException: NL Exception was generated

at oracle.net.nt.ConnOption.getNT(ConnOption.java:139)

at oracle.net.nt.ConnOption.connect(ConnOption.java:173)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510)

... 17 more

Exception in component talendStats_DB ( )

java.lang.NullPointerException

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.talendStats_STATSProcess(ZPIF_UIP_SF_DWH_LOAD.java:15864)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:19834)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:19282)

Exception in component tDBOutput_2 (ZPIF_UIP_SF_DWH_LOAD)

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)

at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:793)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:57)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:747)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:562)

at java.sql.DriverManager.getConnection(Unknown Source)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.tSalesforceInput_2Process(ZPIF_UIP_SF_DWH_LOAD.java:11809)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:19843)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:19282)

Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:571)

at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:548)

at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682)

at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309)

at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1596)

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:588)

... 9 more

Caused by: oracle.net.ns.NetException: NL Exception was generated

at oracle.net.nt.ConnOption.getNT(ConnOption.java:139)

at oracle.net.nt.ConnOption.connect(ConnOption.java:173)

at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:510)

... 14 more

Exception in component talendStats_DB (ZPIF_UIP_SF_DWH_LOAD)

java.lang.NullPointerException

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.talendStats_STATSProcess(ZPIF_UIP_SF_DWH_LOAD.java:15864)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:19869)

at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:19282)

[statistics] disconnected

Anyone encountered this? Would appreciate your help in this regard.

Thank you

-raj Seth

Re: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

vikramk — Tue, 20 Oct 2020 08:04:31 GMT

This looks like there is some network port issues while studio connecting to Db, Please check with your network team for all the ports to be opened or if there is any other issues.

Please let me know if it helps.

Re: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Rajset — Thu, 22 Oct 2020 01:47:44 GMT

Thanks Vikram. The port is enabled between the Talend server and the target database (Oracle). The above issue occurs only when we run the job from the GUI. It doesn't even appear to be reaching the server. Is there a location config in the GUI where we validate the server and port information?

Thank you

topic java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection in Talend Studio

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Re: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

Re: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection