You need to sign in to do that
Don't have an account?

Error in Data Loader for bulk data
Hi
This is my process conf file, i have similar beans for 3 more objects in same process conf file. works fine if the data count is less, tested for 100 in each file. i am geting the error if i try to insert bulk ammount(25,000) of data to more than one object at same time in my windows system.
I am having individual bat files to call each bean, and master bat file to call all the individual bat files.
the filrst insert process getting completed successfully for any number of data (17k,20k r 25k), but the in second insert call gatiing the error as
My InsertImportprocessStatus.bat, insert all the data but getting the below error when calling InsertList.bat
ERROR [insertList] client.PartnerClient login (PartnerClient.java:1030) - Error while logging in to web service at: https://test.salesforce.com/services/Soap/u/19.0, error was: Failed to send request to https://test.salesforce.com/services/Soap/u/19.0
com.sforce.ws.ConnectionException: Failed to send request to https://test.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.java:998)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.java: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.java:130)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:258)
Caused by: java.net.UnknownHostException: test.salesforce.com
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(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.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 7 more
2014-05-23 16:27:40,890 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:239) - Unable to run process insertAccountList
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send request to https://test.salesforce.com/services/Soap/u/19.0
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:164)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:258)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://test.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.java:998)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.java: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.java:130)
... 1 more
Caused by: java.net.UnknownHostException: test.salesforce.com
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(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.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 7 more
How to solve this issue
This is my process conf file, i have similar beans for 3 more objects in same process conf file. works fine if the data count is less, tested for 100 in each file. i am geting the error if i try to insert bulk ammount(25,000) of data to more than one object at same time in my windows system.
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <beans> <bean id="insertprocessStatus" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false"> <description>Extract Staging Data.</description> <!--property name="ftpService" ref="ftpUpload"/--> <property name="name" value="insertprocessStatus"/> <property name="configOverrideMap"> <map> <entry key="sfdc.debugMessages" value="false"/> <entry key="sfdc.debugMessagesFile" value="../status/accountMasterSoapTrace.log"/> <entry key="sfdc.endpoint" value="https://test.salesforce.com"/> <entry key="sfdc.username" value="mayil@sfdc.com"/> <entry key="sfdc.password" value="066de8ada127a859f22236802ceab6cd36a20dcca57a11eacba26ec41ac9adb21de4eebc047ac11f"/> <entry key="process.encryptionKeyFile" value="key.txt"/> <entry key="sfdc.timeoutSecs" value="600"/> <entry key="sfdc.loadBatchSize" value="200"/> <entry key="sfdc.entity" value="DataImportprocess__c"/> <entry key="process.operation" value="insert"/> <entry key="process.mappingFile" value="../map/DataImportprocessStatusmapper.sdl"/> <entry key="process.outputError" value="../extras/errorDataImportprocessStatus.csv"/> <entry key="process.outputSuccess" value="../extras/successDataImportprocessStatus.csv"/> <entry key="dataAccess.name" value="../InputCSV/DataImportProcessStatus.csv" /> <entry key="dataAccess.type" value="csvRead"/> <entry key="process.initialLastRunDate" value="2014-03-06T00:00:00.000-0800"/> <entry key="process.enableLastRunOutput" value="true" /> <entry key="process.lastRunOutputDirectory" value="../conf/"/> </map> </property> </bean>
I am having individual bat files to call each bean, and master bat file to call all the individual bat files.
the filrst insert process getting completed successfully for any number of data (17k,20k r 25k), but the in second insert call gatiing the error as
::In Master bat file call InsertImportprocessStatus.bat echo Inserting the CustomerCodeUsage records in Pre-Staging call InsertList.bat
In InsertImportprocessStatus.bat file java -cp ../lib/EnhencedDataloader.jar -Dsalesforce.config.dir="../conf" com.salesforce.dataloader.process.ProcessRunnerprocess.name=insertImportprocessStatus
My InsertImportprocessStatus.bat, insert all the data but getting the below error when calling InsertList.bat
ERROR [insertList] client.PartnerClient login (PartnerClient.java:1030) - Error while logging in to web service at: https://test.salesforce.com/services/Soap/u/19.0, error was: Failed to send request to https://test.salesforce.com/services/Soap/u/19.0
com.sforce.ws.ConnectionException: Failed to send request to https://test.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.java:998)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.java: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.java:130)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:258)
Caused by: java.net.UnknownHostException: test.salesforce.com
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(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.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 7 more
2014-05-23 16:27:40,890 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:239) - Unable to run process insertAccountList
java.lang.RuntimeException: com.sforce.ws.ConnectionException: Failed to send request to https://test.salesforce.com/services/Soap/u/19.0
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:164)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:258)
Caused by: com.sforce.ws.ConnectionException: Failed to send request to https://test.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.java:998)
at com.salesforce.dataloader.client.PartnerClient.login(PartnerClient.java: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.java:130)
... 1 more
Caused by: java.net.UnknownHostException: test.salesforce.com
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.security.ssl.SSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.<init>(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(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.connectLocal(JdkHttpTransport.java:97)
at com.sforce.ws.transport.JdkHttpTransport.connect(JdkHttpTransport.java:82)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:99)
... 7 more
How to solve this issue