topic Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException in Talend Studio

Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

Anonymous — Sat, 16 Nov 2024 07:20:33 GMT

Hi,

I am getting the error "failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException: Failed to send request to https://********--developer.cs107.my.salesforce.com/services/Soap/u/39.0/00D1q0000008dFF" frequently in middle of the job.

Can you please help me to over come this. Because importing nearly 300000 records from this job. I increased Time out count also.

Thanks,

sujith

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

Anonymous — Fri, 09 Nov 2018 07:12:55 GMT

Hello,

Are you try to connect to a production or a sandbox environment? Does this error arrives immediately or do you have to wait for some seconds before?

Best regards

Sabrina

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

Anonymous — Fri, 09 Nov 2018 07:31:56 GMT

HI,

It is for sandbox. It is not happen immediately. Some times it is giving after 600 records and some times it is giving after 100000 records like that. It is giving in any stage but job is not completing successfully.

If my job having limited records like below 100000 it's working fine and job completed successfully..

Please help me to sort this issue.

Thanks,

sujith

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

TRF — Fri, 09 Nov 2018 07:56:08 GMT

1rst of all, if you have a large number of records to upload to salesforce, you should really consider to use tSalesforceOutBulkExec instead of tSalesforceOutput component.

Regarding the error you encounter, I think the problem could due to a network error.

Are you able to change your network connection for a test?

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

Anonymous — Fri, 09 Nov 2018 08:08:08 GMT

I tried to use tSalesforceOutBulkExec but it is requiring CSV file.I am directly integrating data from SQL to salesforce.
If it is the network problem how can I able to complete my remaining jobs.I completed jobs for the tables having records below 100000 .

Can u guide me how can I use tSalesforceOutBulkExec with out specifying the CSV File.

Thanks,
Sujith

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

TRF — Fri, 09 Nov 2018 08:15:07 GMT

You need to specify a file for the tSalesforceOutputBulkExec but you don't have to construct the file by yourself.

In fact you don't have to change anything to your process except the component itself and the type of salesforce connection if you decide to use a tSalesforceConnection component (select "Bulk Connection" on the "Advanced settings" tab of the component).

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

Anonymous — Fri, 09 Nov 2018 08:27:20 GMT

Thank you TRF.

Let me try this and let you know.

Thanks,

sujith

Re: Getting failed to release the resource in tSalesforceOutput_1 :com.sforce.ws.ConnectionException

Anonymous — Mon, 12 Nov 2018 13:24:57 GMT

Thank you TRF. It's worked for me.