Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Rajset
Contributor
Contributor
‎2020-10-23 10:53 PM

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

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

187 Views
0 Likes
4 Replies
Anonymous
Not applicable
‎2020-10-25 11:46 PM

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

187 Views
0 Likes
Rajset
Contributor
Contributor
‎2020-10-26 10:28 PM
Author

In response to Anonymous
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
187 Views
0 Likes
Rajset
Contributor
Contributor
‎2020-10-27 11:13 PM
Author

In response to Anonymous
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]
187 Views
0 Likes
Anonymous
Not applicable
‎2020-10-30 05:22 AM

In response to Rajset

Hello,

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

Best regards

Sabrina

187 Views
0 Likes