Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
tarting job ZPIF_UIP_SF_DWH_LOAD at 20:48 23/10/2020.
Null value will be used for context parameter Salesforce_CDE_SRC_proxy_port: For input string: ""
Null value will be used for context parameter Salesforce_CDE_SRC_oauth2JwtFlow_expirationTime: For input string: ""
Null value will be used for context parameter Salesforce_CDE_SRC_oauth_callbackPort: For input string: ""
[statistics] connecting to socket on port 3924
[statistics] connected
****************** connectivity established!! ******************
**************** the below parameters are in CSV file which gets read correctly in the job *********** but at run-time it fails!!
Exception in component Implicit_Context_Regex (ZPIF_UIP_SF_DWH_LOAD)
java.io.FileNotFoundException: \u01\cde_talend_sync_jobs\CDE_Connection.csv (The system cannot find the file specified)
at java.io.FileInputStream.open0(Native Method)
at java.io.FileInputStream.open(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at java.io.FileInputStream.<init>(Unknown Source)
at org.talend.fileprocess.TOSDelimitedReader.<init>(TOSDelimitedReader.java:88)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.Implicit_Context_RegexProcess(ZPIF_UIP_SF_DWH_LOAD.java:1252)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:20772)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:20247)
Exception in component connectionStatsLogs (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 routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.connectionStatsLogsProcess(ZPIF_UIP_SF_DWH_LOAD.java:15990)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.preStaLogConProcess(ZPIF_UIP_SF_DWH_LOAD.java:1008)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:20787)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:20247)
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 (ZPIF_UIP_SF_DWH_LOAD)
java.lang.NullPointerException
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.talendStats_STATSProcess(ZPIF_UIP_SF_DWH_LOAD.java:16829)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:20799)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:20247)
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 talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.tSalesforceInput_2Process(ZPIF_UIP_SF_DWH_LOAD.java:11805)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:20808)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:20247)
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 talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.talendStats_STATSProcess(ZPIF_UIP_SF_DWH_LOAD.java:16829)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:20834)
at talend_0731.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:20247)
[statistics] disconnected
Job ZPIF_UIP_SF_DWH_LOAD ended at 20:48 23/10/2020. [Exit code = 1]
Any help would highly be appreciated.
Thank you
Hello,
We are supposing that you are using tContextLoad to load the those context parameters in your job, where null values are loaded as context values.
Please check the input source of your context and correct them beforehand.
In addition to this you can check the box "Disable Errors", "Disable Warnings" in the tContextLoad.
Best regards
Sabrina
Hello,
We will appreciate it a lot if you could post your current job design screenshots on community.
Best regards
Sabrina