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

[Rajset]

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 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 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

[vikramk]

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.

[Rajset]

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