You need to sign in to do that
Don't have an account?
Data Loader from CMD
This is my process conf file, I am getting an error message when I am trying to run data loader from command prompt. I think it is not able to login to the salesforce,
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean
class="com.salesforce.dataloader.process.ProcessRunner"
singleton="false">
<description>Extracts all current Users.</description>
<property value="csvExportUsers"/>
<property>
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile" value="Y:\salesforce.com\Apex Data Loader 18.0\ExtractLeads\csvExtract.log"/>
<entry key="sfdc.endpoint" value="https://www.test.salesforce.com"/>
<entry key="sfdc.username" value="Replaced"/>
<entry key="sfdc.password" value=" Replaced "/>
<entry key="sfdc.timeoutSecs" value="540"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Lead"/>
<entry key="sfdc.extractionRequestSize" value="500"/>
<entry key="sfdc.extractionSOQL" value="Select ID, LASTNAME, FIRSTNAME, NAME FROM Lead limit 10"/>
<entry key="process.operation" value="extract"/>
<entry key="process.mappingFile" value="Y:\salesforce.com\Apex Data Loader 18.0\ExtractLeads\Extract.sdl"/>
<entry key="process.outputError" value="Y:\salesforce.com\Apex Data Loader 18.0\ExtractLeads\csvError.csv"/>
<entry key="process.outputSuccess" value="Y:\salesforce.com\Apex Data Loader 18.0\ExtractLeads\csvSuccess.csv"/>
<entry key="process.enableExtractSuccessOutput" value="true"/>
<entry key="dataAccess.type" value="csvWrite"/>
<entry key="dataAccess.writeUTF8" value="true"/>
<entry key="dataAccess.name" value="Y:\salesforce.com\Apex Data Loader 18.0\ExtractLeads\extract.csv"/>
<entry key="process.initialLastRunDate" value="2008-08-28T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>
Error Message:
875 [csvExportUsers] INFO com.salesforce.dataloader.process.ProcessRunner - Loa
ding parameters
11359 [csvExportUsers] INFO com.salesforce.dataloader.config.LastRun - Last run
info will be saved in file: Y:\salesforce.com\Apex Data Loader 18.0\ExtractLead
s\csvExportUsers_lastRun.properties
11359 [csvExportUsers] INFO com.salesforce.dataloader.process.ProcessRunner - L
ogging in to: https://www.test.salesforce.com
11390 [csvExportUsers] INFO com.salesforce.dataloader.client.PartnerClient - Be
ginning Partner Salesforce login ....
11453 [csvExportUsers] INFO com.salesforce.dataloader.client.PartnerClient - Sa
lesforce login to https://www.test.salesforce.com/services/Soap/u/18.0 as user xxx@xxx.com
12171 [csvExportUsers] ERROR com.salesforce.dataloader.client.PartnerClient - E
rror while logging in to web service at: https://www.test.salesforce.com/service
s/Soap/u/18.0, error was: Failed to send request to https://www.test.salesforce.
com/services/Soap/u/18.0
com.sforce.ws.ConnectionException: Failed to send request to https://www.test.sa
lesforce.com/services/Soap/u/18.0
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:113)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:37)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:976)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:78)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:167)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:109)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:222)
Caused by: java.net.UnknownHostException: www.test.salesforce.com
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
at java.net.Socket.connect(Socket.java:507)
at sun.net.NetworkClient.doConnect(NetworkClient.java:152)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:365)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:477)
at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:278)
at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:335)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewH
ttpClient(AbstractDelegateHttpsURLConnection.java:176)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConne
ction.java:771)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect
(AbstractDelegateHttpsURLConnection.java:162)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLCo
nnection.java:836)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Htt
psURLConnectionImpl.java:230)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTranspor
t.java:90)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.jav
a:75)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 6 more
12218 [csvExportUsers] ERROR com.salesforce.dataloader.process.ProcessRunner -
Failed to send request to https://www.test.salesforce.com/services/Soap/u/18.0
Exception in thread "main" java.lang.RuntimeException: com.sforce.ws.ConnectionE
xception: Failed to send request to https://www.test.salesforce.com/services/Soa
p/u/18.0
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:145)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:222)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://
www.test.salesforce.com/services/Soap/u/18.0
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:113)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:37)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:976)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:78)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:167)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:109)
... 1 more
Caused by: java.net.UnknownHostException: www.test.salesforce.com
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:177)
at java.net.Socket.connect(Socket.java:507)
at sun.net.NetworkClient.doConnect(NetworkClient.java:152)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:365)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:477)
at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:278)
at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:335)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewH
ttpClient(AbstractDelegateHttpsURLConnection.java:176)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConne
ction.java:771)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect
(AbstractDelegateHttpsURLConnection.java:162)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLCo
nnection.java:836)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Htt
psURLConnectionImpl.java:230)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTranspor
t.java:90)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.jav
a:75)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 6 more
I figured it out... the end point has to be from the partner wsdl
I copied it from the wsdl and it worked fine
All Answers
I'd guess that your network requires you to make outbound connections via a HTTP proxy server, but you haven't configured it to use one.
I am also getting a similiar erroe as soap login failed.
I have tried this with the test developer edition logiun...I shouldnt be getting this error as this is not a company network and sholdnt fail
22688 [csvExportUsers] ERROR com.salesforce.dataloader.client.PartnerClient - E
rror while logging in to web service at: https://www.login.salesforce.com/servic
es/Soap/u/19.0, error was: Failed to send request to https://www.login.salesforc
e.com/services/Soap/u/19.0
com.sforce.ws.ConnectionException: Failed to send request to https://www.login.s
alesforce.com/services/Soap/u/19.0
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:113)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:38)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:1007)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:105)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:182)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:177)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:105)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:229)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.Socket.connect(Socket.java:507)
at sun.net.NetworkClient.doConnect(NetworkClient.java:152)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:365)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:477)
at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:278)
at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:335)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewH
ttpClient(AbstractDelegateHttpsURLConnection.java:176)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConne
ction.java:771)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect
(AbstractDelegateHttpsURLConnection.java:162)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLCo
nnection.java:836)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Htt
psURLConnectionImpl.java:230)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTranspor
t.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.jav
a:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 7 more
22704 [main] FATAL com.salesforce.dataloader.process.ProcessRunner - Unable to
run process csvExportUsers
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send re
quest to https://www.login.salesforce.com/services/Soap/u/19.0
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:139)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:229)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://
www.login.salesforce.com/services/Soap/u/19.0
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:113)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:38)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.ja
va:1007)
at com.salesforce.dataloader.client.PartnerClient.connect(PartnerClient.
java:105)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:182)
at com.salesforce.dataloader.controller.Controller.login(Controller.java
:177)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:105)
... 1 more
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.Socket.connect(Socket.java:507)
at sun.net.NetworkClient.doConnect(NetworkClient.java:152)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:365)
at sun.net.www.http.HttpClient.openServer(HttpClient.java:477)
at sun.net.www.protocol.https.HttpsClient.<init>(HttpsClient.java:278)
at sun.net.www.protocol.https.HttpsClient.New(HttpsClient.java:335)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewH
ttpClient(AbstractDelegateHttpsURLConnection.java:176)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConne
ction.java:771)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect
(AbstractDelegateHttpsURLConnection.java:162)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(HttpURLCo
nnection.java:836)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Htt
psURLConnectionImpl.java:230)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTranspor
t.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.jav
a:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 7 more
I figured it out... the end point has to be from the partner wsdl
I copied it from the wsdl and it worked fine