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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[TRF]

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?

[Anonymous]

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

[TRF · Accepted solution]

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

[Anonymous]

Thank you TRF. 

Let me try this and let you know.

Thanks,

sujith

[Anonymous]

Thank you TRF. It's worked for me.