Salesforce Developer Community

Chatter

Feed
0

Best Answers
0

Likes Received
0

Likes Given
2

Questions
3

Replies

Command line dataloader error Failed to send request to https://test.salesforce.com/services/Soap/u/44.0

I am trying to execute command line dataloader from our server, where as there are no proxys setting setuped in our server.
In process-conf.xml i have included below lines as blank as our server doesn't hold any settings.

<entry key="sfdc.proxyUsername" value="" />
<entry key="sfdc.proxyPassword" value="" />
<entry key="sfdc.proxyHost" value="" />
<entry key="sfdc.proxyPort" value="" /> -->

Error while calling web service operation: login, error was
: Failed to send request to https://test.salesforce.com/services/Soap/u/44.0
com.sforce.ws.ConnectionException: Failed to send request to https://test.salesf
orce.com/services/Soap/u/44.0

Caused by: org.apache.http.conn.HttpHostConnectException: Connect to test.salesf
orce.com:443 [test.salesforce.com/85.222.129.39, test.salesforce.com/85.222.128.
167, test.salesforce.com/85.222.129.167] failed: Connection timed out: connect
at org.apache.http.impl.conn.DefaultHttpClientConnectionOperator.connect
(DefaultHttpClientConnectionOperator.java:158)

The encrypted Key and encrypted Password was correct as i could able to extract the file on my local PC where as when i tried to implement the same in our server, i am getting above error.
As i said at server level nothing proxy was setuped and same was checked with IT team.

Please suggest any inputs how to proceed further.

//Siva

Siva@63
February 21, 2019
Like
0

0 replies

How to append year-Month-Date-Time in a windows batch script

Used below line to get the file format as C:\DataLoaderCL\Account_%time:~0,2%%time:~3,2%%time:~6,2%_%date:~-10,2%%date:~-7,2%%date:~-4,4%.csv
Output of the file : Account_130420_02152019.csv
Now i want to achieve the file format as : Account-2019-Feb-12-173306 The format should be Year-Mon-DD-Time
Please give suggestions to achieve above output

Thanks in Advance

Siva@63
February 15, 2019
Like
0

1 replies

Command line dataloader error Failed to send request to https://test.salesforce.com/services/Soap/u/44.0

Siva@63
February 21, 2019
Like
0

4 replies

Data Loader - Salesforce Error calling web service operation: describeSObject - failed to send request

Can someone help me with this error?

Apex Data Loader - Export to Salesforce failed.
We are using Apex Data Loader 24.0.0 and cliq_process. Using Apex Data Loader & Cliq_process, we are exporting the data into Salesforce custom object. The process was working fine until yesterday. We are getting the following error:

2016-05-10 11:30:49,081 INFO [main] controller.Controller initLog (Controller.java:404) - The log has been initialized
2016-05-10 11:30:49,088 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\Program Files\salesforce.com\Data Loader\cliq_process\CIFWHDG\config\process-conf.xml
2016-05-10 11:30:49,161 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [C:\Program Files\salesforce.com\Data Loader\cliq_process\CIFWHDG\config\process-conf.xml]
2016-05-10 11:30:49,238 INFO [CIFWHDG] controller.Controller initConfig (Controller.java:365) - The controller config has been initialized
2016-05-10 11:30:49,240 INFO [CIFWHDG] process.ProcessRunner run (ProcessRunner.java:116) - Initializing process engine
2016-05-10 11:30:49,244 INFO [CIFWHDG] process.ProcessRunner run (ProcessRunner.java:119) - Loading parameters
2016-05-10 11:30:50,565 INFO [CIFWHDG] config.LastRun load (LastRun.java:96) - Last run info will be saved in file: C:\Program Files\salesforce.com\Data Loader\cliq_process\CIFWHDG\log\CIFWHDG_lastRun.properties
2016-05-10 11:30:50,581 INFO [CIFWHDG] process.ProcessRunner run (ProcessRunner.java:127) - Logging in to: https://login.salesforce.com/services/Soap/u/24.0
2016-05-10 11:30:50,587 INFO [CIFWHDG] client.PartnerClient login (PartnerClient.java:478) - Beginning Partner Salesforce login ....
2016-05-10 11:30:50,608 INFO [CIFWHDG] client.PartnerClient loginInternal (PartnerClient.java:519) - Salesforce login to https://login.salesforce.com/services/Soap/u/24.0/services/Soap/u/24.0 as user data.integration@f-s-b.com
2016-05-10 11:30:51,064 INFO [CIFWHDG] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: H:\AS400flr\SForce\CIFWHDG.csv of type: csvRead
2016-05-10 11:30:51,069 INFO [CIFWHDG] process.ProcessRunner run (ProcessRunner.java:132) - Checking the data access object connection
2016-05-10 11:30:51,075 INFO [CIFWHDG] process.ProcessRunner run (ProcessRunner.java:137) - Setting field types
2016-05-10 11:30:51,115 ERROR [CIFWHDG] client.PartnerClient runOperation (PartnerClient.java:332) - Error while calling web service operation: describeSObject, error was: Failed to send request to https://na12.salesforce.com/services/Soap/u/24.0/00DU0000000Xwe5
com.sforce.ws.ConnectionException: Failed to send request to https://na12.salesforce.com/services/Soap/u/24.0/00DU0000000Xwe5
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:120)
at com.sforce.soap.partner.PartnerConnection.describeSObject(PartnerConnection.java:1115)
at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:185)
at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:177)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:328)
at com.salesforce.dataloader.client.PartnerClient.describeSObject(PartnerClient.java:723)
at com.salesforce.dataloader.client.PartnerClient.setFieldTypes(PartnerClient.java:676)
at com.salesforce.dataloader.controller.Controller.setFieldTypes(Controller.java:133)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:138)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.sforce.ws.transport.JdkHttpTransport.connectRaw(JdkHttpTransport.java:133)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:92)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:88)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94)
... 10 more
Caused by: java.io.EOFException: SSL peer shut down incorrectly
at com.sun.net.ssl.internal.ssl.InputRecord.read(Unknown Source)
... 23 more
2016-05-10 11:30:51,125 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process CIFWHDG
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send request to https://na12.salesforce.com/services/Soap/u/24.0/00DU0000000Xwe5
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://na12.salesforce.com/services/Soap/u/24.0/00DU0000000Xwe5
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:120)
at com.sforce.soap.partner.PartnerConnection.describeSObject(PartnerConnection.java:1115)
at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:185)
at com.salesforce.dataloader.client.PartnerClient$10.run(PartnerClient.java:177)
at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:328)
at com.salesforce.dataloader.client.PartnerClient.describeSObject(PartnerClient.java:723)
at com.salesforce.dataloader.client.PartnerClient.setFieldTypes(PartnerClient.java:676)
at com.salesforce.dataloader.controller.Controller.setFieldTypes(Controller.java:133)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:138)
... 2 more
Caused by: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.readRecord(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.performInitialHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.startHandshake(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.afterConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.sforce.ws.transport.JdkHttpTransport.connectRaw(JdkHttpTransport.java:133)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connectLocal(JdkHttpTransport.java:92)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:88)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:94)
... 10 more
Caused by: java.io.EOFException: SSL peer shut down incorrectly
at com.sun.net.ssl.internal.ssl.InputRecord.read(Unknown Source)
... 23 more

Dana Sons
May 10, 2016
Like
1

5 replies

Error while logging in to web service at: https://login.salesforce.com/services/Soap/u/30.0, error was: Failed to send request to https://login.salesforce.com/services/Soap/u/30.0

Hi all,
Im inserting data from dataloader through command line
ive followed following steps
1.erypt -g test
2.encrypt -e mypass+security token "Path of my key.txt"
3.write process.xml as below

process-confg.xml
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="accountInsert"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description> uploads them to salesforce using 'upsert'.</description>
        <property name="name" value="accountMasterProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="C:\Users\a579510\Desktop\dl\samples\status\accountMasterSoapTrace.log"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="priya.burghate@atos.net"/>
                
                <entry key="sfdc.password" value="f128334f5306b5d53ea345ba07b816f8557994a62dcdc346fdf664bb2c35836c1d13f1fb4a37933f"/>
                <entry key="process.encryptionKeyFile" value="C:\Users\a579510\Desktop\dl\samples\conf\sample.txt"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.externalIdField" value="Oracle_Id__c"/>
                <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="upsert"/>
                <entry key="process.mappingFile" value="C:\Users\a579510\Desktop\dl\samples\conf\accountInsertMap.sdl"/>
                <entry key="dataAccess.name" value="C:\Users\a579510\Desktop\dl\samples\data\accountData1.csv"/>
    <entry key="process.outputError" value="C:\Users\a579510\Desktop\dl\samples\status\error.csv"/>
    <entry key="processOutputSuccess" value="C:\Users\a579510\Desktop\dl\samples\status\success.csv"/>
                <entry key="dataAccess.type" value="csvRead"/>
                <entry key="process.initialLastRunDate" value="2005-12-01T00:00:00.000-0800"/>
            </map>
        </property>
    </bean>
</beans>

but gives an error
Error while logging in to web service at: https://login.salesforce.com/services/Soap/u/30.0, error was: Failed to send request to https://login.salesforce.com/services/Soap/u/30.0com.sforce.ws.ConnectionException: Failed to send request to https://login.salesforce.com/services/Soap/u/30.0

pl z add your valuable suggetions......

priya burghate
September 24, 2014
Like
0