SAP Data Services Designer - error in salesforce adaptar datasotore

[antonio_priede]

I have created a datastore using the salesforce adapter instance created in my jobserver but connection to Salesforce fails with the following message in the adapter instance.

Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Connection reset.

in the datastore definition I have used my salesforce account and password and also tried with the password plus the security token (all together) but still fails. My installed version is 14.2.11

I would appreciate your suggestions to solve this issue.

Thanks

[former_member598107 · Accepted solution]

Antonio,

Please refer 2637302 - Unable to connect Salesforce API of www.salesforce.com - SAP Data Services 4.2

Cause: Salesforce made an API announcement that the endpoint www.salesforce.com will be retired starting April 20, 2018 and login.salesforce.com should be used instead.

Solution: Replace the 'Web service end point' of https://www.salesforce.com/services/Soap/u/21.0 in the datastore with https://login.salesforce.com/services/Soap/u/21.0 .

This should work

Regards

Arun Sasi

[antonio_priede · Accepted solution]

Hi Arun,

You help me out a couple of months ago when my SFDC datastore was failing to connect. At that time you suggested me to replace the 'Web service end point' with https://login.salesforce.com/services/Soap/u/21.0 and it worked perfectly.

However, I'm now configuring a similar adapter on another box. I'm using the same configuration but i'm getting the following error message:

Any suggestion will be very appreciated.

Regards,

Antonio

[antonio_priede · Accepted solution]

Hi Arun, please disregard my previous comment, it's my bad, I had created the instance with the wrong Adapter, not the SFDC one. It is working now. Thank you again and my apologies for the misunderstanding

Regards,

Antonio

[former_member598107]

abhinavsk92

Are you reading large volume of data from SFDC tables? If yes,tTry reading limited amount of data.

Can you please check the value of parameter AdapterDataExchangeTimeout in DSConfig.txt on the SAP Data services job server. Try increasing the value and check if it works

Regards

Arun Sasi

[former_member680505]

Hi Arun, Antonio

I changed the web services endpoint to "https://test.salesforce.com/services/Soap/u/21.0" and also tried the "https://login.salesforce.com/services/Soap/u/21.0" connecting to salesforce sandbox clone server, but still receiving this error:

can you help diagnose what could be the possible solution? Any help would be appreciated!

Error from Data Servies Management Console:

Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Read timed out (local port 60321 to address XX.XX.XX.XX(DS HOST name), remote port 443 to address 13.110.11.16 (dcl7-ncg0-iad3.cs22-ia2.my.salesforce.com))
Retry : 1. Waiting 5 mins before trying to login to Salesforce.com again.


There was a communication error when talking to Salesforce.com: Read timed out (local port 11819 to address XX.XX.XX.XX (DS HOST name), remote port 443 to address 13.108.249.130 (dcl4-ord.login.salesforce.com))


Fault-tolerance-login-failed : There was a communication error when talking to Salesforce.com: Read timed out (local port 11819 to address XX.XX.XX.XX(DS HOST name), remote port 443 to address 13.108.249.130 (dcl4-ord.login.salesforce.com))
Retry : 1. Waiting 5 mins before trying to login to Salesforce.com again.

[antonio_priede]

Thank you very much Arun. It worked perfectly

Regards

Antonio Priede

[former_member598107]

Excellent!!

[antonio_priede]

Than you Arun.

My Adapter instance is running and as soon as I try to communicate by settingthe data source I see the following error in the instance log:

The data source configuration is as follow. When provide user and password I get the error in data services:

Thanks

[former_member598107]

Can you please attach the screenshot of the error message. The below SAP note says that the endpoint URL is not updated correctly in the SFDC datastore.

Refer SAP note

2602312 - Unable to Communicate Salesforce.com - Data Services

Regards

Arun Sasi