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
