You need to sign in to do that
Don't have an account?
MTBRider
Dataloader and command line interface issues
I have a client that I implemented nightly batch load process for years ago using the dataloader command line interface. It has worked every night for 7 years without an issue. They now need to upgrade the server it is running on and at the same time want to upgrade dataloader. They installed dataloader 34.0 and I cannot get it to connect to salesforce and I am starting to think there is a bug in dataloader 34.
Here is the error:
The error is java.net.UnknownHostException: C
Here is the relevent bean in the process-conf.xml file:
The reason that I think there is a bug in DL 34 is because I also have DL 30.0.0 installed on my machine and when I change this line in the process.bat file:
to this:
and keep everything else the same, I don't get the java.net.UnknownHostException: C error.
Can anyone shed any light onto this?
Thanks
Here is the error:
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process "C:\Program Files (x86)\salesforce.com\Data Loader" tempCont 2015-06-23 11:19:54,373 INFO [main] controller.Controller initLog (Controller.java:389) - Using built-in logging configuration \salesforce.com\Data Loader\bin\log-conf.xml 2015-06-23 11:19:54,373 INFO [main] controller.Controller initLog (Controller.java:391) - The log has been initialized 2015-06-23 11:19:54,373 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configurat )\salesforce.com\Data Loader\process-conf.xml 2015-06-23 11:19:54,443 INFO [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) - ort.FileSystemXmlApplicationContext@13bd574: startup date [Tue Jun 23 11:19:54 PDT 2015]; root of context hierarchy 2015-06-23 11:19:54,474 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loadi /Program Files (x86)/salesforce.com/Data Loader/process-conf.xml] 2015-06-23 11:19:59,029 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: \Program Files (x86)\salesforce.com\Data Loader\process-conf.xml org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from URL [file://C:/Program Fi s-conf.xml]; nested exception is java.net.UnknownHostException: C at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext. at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext. at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableAppl at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.jav at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436) at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:140) at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:84) at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:105) at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93) at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287) at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273) at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246) Caused by: java.net.UnknownHostException: C at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.net.NetworkClient.doConnect(Unknown Source) at sun.net.NetworkClient.openServer(Unknown Source) at sun.net.ftp.FtpClient.openServer(Unknown Source) at sun.net.ftp.FtpClient.openServer(Unknown Source) at sun.net.www.protocol.ftp.FtpURLConnection.connect(Unknown Source) at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(Unknown Source) at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:125) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328) ... 17 more 2015-06-23 11:19:59,045 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Failed to create process com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: tempCont configuration from config f Data Loader\process-conf.xml at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97) at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:287) at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:273) at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:246) Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from URL [file://C: ader/process-conf.xml]; nested exception is java.net.UnknownHostException: C at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:341) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:302) at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionRea at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext. at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext. at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableAppl at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.jav at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:436) at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:140) at org.springframework.context.support.FileSystemXmlApplicationContext.(FileSystemXmlApplicationContext.java:84) at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:105) at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93) ... 3 more Caused by: java.net.UnknownHostException: C at java.net.PlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at sun.net.NetworkClient.doConnect(Unknown Source) at sun.net.NetworkClient.openServer(Unknown Source) at sun.net.ftp.FtpClient.openServer(Unknown Source) at sun.net.ftp.FtpClient.openServer(Unknown Source) at sun.net.www.protocol.ftp.FtpURLConnection.connect(Unknown Source) at sun.net.www.protocol.ftp.FtpURLConnection.getInputStream(Unknown Source) at org.springframework.core.io.UrlResource.getInputStream(UrlResource.java:125) at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:328) ... 17 more
The error is java.net.UnknownHostException: C
Here is the relevent bean in the process-conf.xml file:
Test upsert
The reason that I think there is a bug in DL 34 is because I also have DL 30.0.0 installed on my machine and when I change this line in the process.bat file:
..\Java\bin\java.exe -cp ..\dataloader-34.0-uber.jar -Dsalesforce.config.dir=%1 com.salesforce.dataloader.process.ProcessRunner %PROCESS_OPTION%
to this:
..\Java\bin\java.exe -cp ..\dataloader-30.0.0-uber.jar -Dsalesforce.config.dir=%1 com.salesforce.dataloader.process.ProcessRunner %PROCESS_OPTION%
and keep everything else the same, I don't get the java.net.UnknownHostException: C error.
Can anyone shed any light onto this?
Thanks
process "C:\Program Files (x86)\salesforce.com\Data Loader" tempCont
...try:
process "\\localhost\C$\Program Files (x86)\salesforce.com\Data Loader" tempCont
That fixed it for me after a few hours of head scratching! Seems to be a bug, as the documentation clearly instructed me to enter it as you did.
All Answers
process "C:\Program Files (x86)\salesforce.com\Data Loader" tempCont
...try:
process "\\localhost\C$\Program Files (x86)\salesforce.com\Data Loader" tempCont
That fixed it for me after a few hours of head scratching! Seems to be a bug, as the documentation clearly instructed me to enter it as you did.
Is process.bat outdated? Though it works after changing the pathes
Thanks