topic Re: failing to read context parameters in CSV file used while importing the filedelimited connection in metadata repository? in Talend Studio

failing to read context parameters in CSV file used while importing the filedelimited connection in metadata repository?

Rajset — Sat, 24 Oct 2020 02:53:58 GMT

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

Re: failing to read context parameters in CSV file used while importing the filedelimited connection in metadata repository?

Anonymous — Mon, 26 Oct 2020 03:46:26 GMT

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

Re: failing to read context parameters in CSV file used while importing the filedelimited connection in metadata repository?

Rajset — Tue, 27 Oct 2020 02:28:49 GMT

Thank you Sabrina. I’d say, this mapping is straightforward pulling in SalesFouce source with some transformations loading to Oracle table. When we run, the session gets connected, the source connects fine, but fails with oracle.net.ns.NetException when it tries to access the target. Upon looking closely at the target, the host/port and other details are listed in a CSV file stored in the Talend server (Linux node). We can run the same job from the Linux node fine. This error occurs when we launch the TalendDI UI Client tool from our laptop. We then looked at the properties for the target in the mapping, and they were all set as “context” as defined in csv file on the server. May I request a small favor of you? If its fine with you, would you mind a few quick minutes so we can talk this through ? Let me know what time will be convenient tomorrow, Oct 27th and I can call you.. no problem. I sincerely appreciate your helping me in this regard. Thanks again -rajavel sethupathi

Re: failing to read context parameters in CSV file used while importing the filedelimited connection in metadata repository?

Rajset — Wed, 28 Oct 2020 03:13:40 GMT

Starting job ZPIF_UIP_SF_DWH_LOAD at 21:07 27/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 3435 [statistics] connected Exception in component tSalesforceInput_2 (ZPIF_UIP_SF_DWH_LOAD) java.lang.RuntimeException: IOException: com.sforce.ws.ConnectionException: Check authEndpoint. It must contain '/services/Soap/u/'. authEndpoint specified context.Salesforce_CDE_SRC_endpoint at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.tSalesforceInput_2Process(ZPIF_UIP_SF_DWH_LOAD.java:11526) at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.runJobInTOS(ZPIF_UIP_SF_DWH_LOAD.java:15278) at uip_prod.zpif_uip_sf_dwh_load_0_1.ZPIF_UIP_SF_DWH_LOAD.main(ZPIF_UIP_SF_DWH_LOAD.java:14750) [statistics] disconnected Job ZPIF_UIP_SF_DWH_LOAD ended at 21:07 27/10/2020. [Exit code = 1]

Re: failing to read context parameters in CSV file used while importing the filedelimited connection in metadata repository?

Anonymous — Fri, 30 Oct 2020 09:22:18 GMT

Hello,

We will appreciate it a lot if you could post your current job design screenshots on community.

Best regards

Sabrina