Hi
I configured the salesforce adapter on my job server. I tried to create a data store using this adapter instance and gave the user name and pwd too. But i get a message after a while
“Adapter connection failed. could not create a new session. do u want to store the data store anyway?”
pls help…
thanks
rppriya (BOB member since 2009-03-04)
what is the error message that you see in the Adapter trace file ? is request for Metadata reaching the Salesforce Adapter or not ?
to trouble shoot issues with Adapter, enable the trace mode for the adapter, and restart the adapter
can you attach the following log files ?
1 - job server log for the job server managing adapters, this file will be
%LINK_DIR%\log<jobServerName>\server_eventlog.txt
2 - Adapter trace log, this file will be created in %LINK_DIR%\Adapters\log<nameofAdapter>.log
manoj_d (BOB member since 2009-01-02)
Sure. Pls find the attachements
NewPPriya_JS is my job server name.
The salesforce adapter instance that i created was salesforceadapterTest
Let me know pls…
SalesForceAdapterTest_error.txt (36.0 KB)
SalesForceAdapterTest_trace.txt (47.0 KB)
server_eventlog_2009-03-05.txt (102.0 KB)
rppriya (BOB member since 2009-03-04)
from the trace and error log, the problem is happening is with connecting to Salesforce.com, you have not reached the point where the communication with SFDC could start
please try to login to salesforce.com from the Internet Explorer and check if you are able to connect to salesforce or not from the same machine where the job Server managing the Adapter is running
The DI Salesforce Adapter is trying to connect to SFDC and connection request is timing out and its doing a retry for few time after waiting for 5 min before each try and all of the attempts are failing
this looks more of connectivity issue from your network to the salesforce.com
manoj_d (BOB member since 2009-01-02)
rppriya,
Can you tell me how you resolved your connection issue? We are currently having problems accessing the salesforce.com wsdl through our firewall using Data Integrator, and I am getting the same error message. 
Using another program from the same server where I can configure a proxy / port setting, I can access the WSDL metadata, so I think my specific issue involves Data Integrator not using my proxy settings.
leenavarro (BOB member since 2009-01-21)
Salesforce Adapter is a Java application, you can try setting the proxy setting as command line arguments
stop the salesforce adapter instance
add the -Dhttp.proxyHost=[Your proxy server name] -Dhttp.proxyPort=[Your proxy server port] to the Additional Java Launcher Options" it already has following memory options set
-Xms64m Xmx256m
change this to
-Xms64m Xmx256m -Dhttp.proxyHost=[Your proxy server name] -Dhttp.proxyPort=[Your proxy server port]
start the Adapter instace, check if this works
manoj_d (BOB member since 2009-01-02)
Thank you for your reply manoj…
I also found this solution in OSS (1311485), but I am still getting the same error message even when adding the proxy settings as described, and restarting the adapter instance.
leenavarro (BOB member since 2009-01-21)
what is the error message that you are getting ? can you paste the stack trace that you see from error log, you will see the link for error log next to adapter instance in management console or you can get the error log from %LINK_DIR%\Adaterps\log folder
accessing WSDL is not enough to ensure that you are not running into login or network issues while connecting to salesforce, did you try login to salesforce.com from the internet explorer using the login and password
manoj_d (BOB member since 2009-01-02)
The error message is
Cannot access adapter instance configured for Job Server <DI_DEV_JobServer>. Possible Reasons:
This error is different than the error I received before adding the proxy server and port to the adapter instance. I was receiving the same error as rpriya before adding the proxy (“Adapter connection failed. could not create a new session. do u want to store the data store anyway?” )
Yes, I can login to salesforce.com through IE on the server.
If I try to access the WSDL URL directly in IE, I get a “400 get not supported” error message.
Here is what is repeated in the error log over and over:
3/31/09 5:07:47 PM There was a communication error when talking to Salesforce.com: ; nested exception is:
javax.net.ssl.SSLException: Unrecognized SSL message, plaintext connection?
Thank you so much for your help!
leenavarro (BOB member since 2009-01-21)
the problem seems to be with establishing connection to SFDC hence its not able to create the session object
I think for SFDC you need to either pass the security token along with your password to access the URL or you need to add your external IP in the security options in the salesforce.com
what is URL you are trying to access from IE ?
manoj_d (BOB member since 2009-01-02)
This is the salesforce URL I am using:
https://www.salesforce.com/services/Soap/u/14.0
I have also tried logging in with the security token appended to the end of the password, and receive the same result.
Thanks again for the help. I also have an OSS note open to hopefully resolve the issue. When I know the solution, I will be sure to post it.
leenavarro (BOB member since 2009-01-21)
you can’t access salesforce WSDL using the following URL from IE
https://www.salesforce.com/services/Soap/u/14.0
in your salesfroce account there will be link to download the WSDL, download that WSDL and save to disk and open that file from disk or from SoapUI or equivalnet application
what is the version of DI you are using DI 11.7 and 11.5 are certified to work against SFDC Version 7.0
Data Services XI 3.0 is certified to work against SFDC 12.0 version
try accessing the following URL and see if that works
https://www.salesforce.com/services/Soap/u/7.0
manoj_d (BOB member since 2009-01-02)
We have finally corrected this issue by allowing our network to bypass our proxy server when connecting to salesforce.com.
Also, like manoj said, we are also required to use the https://www.salesforce.com/services/Soap/u/12.0 WSDL link because we are using XI 3.0.
Manoj, thank you for your help!
-Lee
leenavarro (BOB member since 2009-01-21)
Manoj ,
We are on DS 4.0 sp2. What URL should we be using inside Datastore to access SFDC ?
Thanks
Mayank
Mayank R (BOB member since 2012-02-05)
you can try this
https://www.salesforce.com/services/Soap/u/16.0
n78882 
(BOB member since 2010-09-17)
Everything worked fine in BODS 12.2 and SFDC Web service end point https://www.salesforce.com/services/Soap/u/16.0. We can login SalesForce.com web application but we have following SFDC adapter error after upgraded to BODS 14.0 and https://www.salesforce.com/services/Soap/u/6.0 (page 13 on sbo401_ds_salesforce_en.pdf):
3/12/12 12:24:04 PM Thread[Thread-10,5,main] Starting the Salesforce.com session
3/12/12 12:24:05 PM Thread[Thread-10,5,main] There was a communication error when talking to Salesforce.com: org.apache.axis2.databinding.ADBException: Unexpected subelement passwordExpired
3/12/12 12:24:05 PM Thread[Thread-10,5,main] Fault-tolerance-login-failed:There was a communication error when talking to Salesforce.com: org.apache.axis2.databinding.ADBException: Unexpected subelement passwordExpired
It would be appreciated if anyone could suggest a solution.
Thanks,
Grace
yghwang 
(BOB member since 2009-01-12)
Deja Vu
I resolved same issue today. Same error message. You are using wrong URL. I am on BODS 4.0 and my issue got resolved when I started using correct URL.
Mayank R (BOB member since 2012-02-05)
Would you please be kind and provide the correct URL that you used?
I have tried all following Web Service End Point in BODS 14.0 but still unable to connect SFDC adapter successfully.
https://www.salesforce.com/services/Soap/u/6.0
https://www.salesforce.com/services/Soap/u/12.0
https://www.salesforce.com/services/Soap/u/16.0
https://www.salesforce.com/services/Soap/u/17.0
https://www.salesforce.com/services/Soap/u/24.0
https://www.salesforce.com/services/Soap/c/24.0
Thanks,
Grace
yghwang (BOB member since 2009-01-12)
Thank you very much! It works!!!
Grace
yghwang (BOB member since 2009-01-12)