Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Salesforce Exception on BigData Studio job

Hi there,

 

I have seen a few posts related to the issue I am facing but still not 100% sure of the solution.

 

I am trying to connect to Salesforce and fetch data into a File on my Windows machine.

 

What's working for me:

Salesforce Connection from Metadata is working fine, that is I am able to create the connection successfully and connect.

A simple job using tSalesforceGetServerTimestamp with the above said connection and writing to a file is working, after adding the tSetProxy.

 

What's not working:

A job to use tSalesforceInput to get 1 Opportunity record to a file is not working. I added tSetProxy like the job above, changed the timeout, in case it took longer, nothing works. Error message below:

Exception in component tSalesforceInput_1 (SFDC_Opportunities)
java.lang.RuntimeException: IOException: com.sforce.ws.ConnectionException: Failed to send request to https://test.salesforce.com/services/Soap/u/39.0
at local_project.sfdc_opportunities_0_1.SFDC_Opportunities.tSalesforceInput_1Process(SFDC_Opportunities.java:20146)
at local_project.sfdc_opportunities_0_1.SFDC_Opportunities.runJobInTOS(SFDC_Opportunities.java:26754)
at local_project.sfdc_opportunities_0_1.SFDC_Opportunities.main(SFDC_Opportunities.java:26603)

 

By the way, the output file is updated with the header record but the job fails and no data loads. I applied filter in the Condition to get only 1 record.

 

Please help with pointers.

 

I am using the standalone Talend Open Studio for Big Data (6.4.1).

 

Thanks

Siddartha.

Labels (5)
10 Replies
Anonymous
Not applicable
Author

Awesome. It worked after connecting the tSetProxy on Success to the actual input.