• Devs
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

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