+ Start a Discussion
BylithiumBylithium 

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

Best Answer chosen by Admin (Salesforce Developers) 
BylithiumBylithium

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

SuperfellSuperfell

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.

DevsDevs

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

BylithiumBylithium

I figured it out... the end point has to be from the partner wsdl

I copied it from the wsdl and it worked fine

 

This was selected as the best answer