function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Jim MacAulayJim MacAulay 

Data Loader Error - error loading process

Hi,

I am trying to run Data Loader from command line. I'm using the sample files to try and dump out contents of the Account table.

Unfortunately I am getting an error - it looks like a parsing error but the XML is valid !?!?

I invoke the Dataloader with: 

process ../config csvAccountExtractProcess

and get the following error (I've attached my process-conf.xml too)

Any help or pointers would be welcome as I'm out of ideas !

2015-06-24 13:02:46,000 INFO  [main] controller.Controller initLog (Controller.java:389) - Using built-in logging configuration, no log-conf.xml in C:\Program Files (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2015-06-24 13:02:46,000 INFO  [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2015-06-24 13:02:46,015 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Data Loader\bin\..\config\process-conf.xml
2015-06-24 13:02:46,062 INFO  [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@13adc56: startup date [Wed Jun 24 13:02:46 BST 2015]; root of context hierarchy
2015-06-24 13:02:46,093 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from URL [file://C:/Program Files (x86)/salesforce.com/Data Loader/bin/../config/process-conf.xml]
2015-06-24 13:02:50,697 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: csvAccountExtractProcess configuration from config file: C:\Program Files (x86)\salesforce.com\Data Loader\bin\..\config\process-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: IOException parsing XML document from URL [file://C:/Program Files (x86)/salesforce.com/Data Loader/bin/../config/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(AbstractBeanDefinitionReader.java:174)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
    at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
    at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
    at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
    at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
    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-24 13:02:50,697 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: csvAccountExtractProcess configuration from config file: C:\Program Files (x86)\salesforce.com\Data Loader\bin\..\config\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:/Program Files (x86)/salesforce.com/Data Loader/bin/../config/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(AbstractBeanDefinitionReader.java:174)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:209)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:180)
    at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:243)
    at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:127)
    at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:93)
    at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:131)
    at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:522)
    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


Process-conf.xml :


              class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
      csvAccountExtract job gets account info from salesforce and saves info into a CSV file."
       
       
           
               
               
               
               
               
               
               
               
               
               
               
               
               
               
               
           
       
   

Amit Chaudhary 8Amit Chaudhary 8
Hi Please follow below point i hope that will help u

STEP 1:- Try to use Data loader 32. not 24
STEP 2:- XML issue is related with CSV file and .SDL file mapping. Please try to fix the mapping.
If possible then try with 2-3 column first then add other column.
NOTE:- Remove all extra column from CSV files.

Please let us know if this will help you

 
Jim MacAulayJim MacAulay
Hi, I am using Data loader 34 not 24 or 32. Why do you think it is a CSV issue? The error says XML parse error? Anyway, I have stripped back the SDL file and altered the select statement in the process-conf.xml to correspond - but it made not difference - same error.
gajawada vaishnavigajawada vaishnavi
C:\Users\OmSaiRam\dataloader\v48.0.0\bin>process.bat C:\Users\OmSaiRam\dataloader\v48.0.0\bin process-conf.xml
2020-06-05 15:58:24,592 INFO  [main] controller.Controller initLog (Controller.java:475) - Using built-in logging configuration, no log-conf.xml in C:\Users\OmSaiRam\dataloader\v48.0.0\bin\configs\log-conf.xml
2020-06-05 15:58:24,616 INFO  [main] controller.Controller initLog (Controller.java:477) - The log has been initialized
2020-06-05 15:58:24,624 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:104) - Loading process configuration from config file: C:\Users\OmSaiRam\dataloader\v48.0.0\bin\process-conf.xml
2020-06-05 15:58:24,749 INFO  [main] support.AbstractApplicationContext prepareRefresh (AbstractApplicationContext.java:495) - Refreshing org.springframework.context.support.FileSystemXmlApplicationContext@158da8e: startup date [Fri Jun 05 15:58:24 IST 2020]; root of context hierarchy
2020-06-05 15:58:24,821 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [C:\Users\OmSaiRam\dataloader\v48.0.0\bin\process-conf.xml]
2020-06-05 15:58:24,893 INFO  [main] support.DefaultListableBeanFactory preInstantiateSingletons (DefaultListableBeanFactory.java:557) - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@101952da: defining beans [accountInsert]; root of factory hierarchy
2020-06-05 15:58:24,893 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:96) - Error loading process: process-conf.xml configuration from config file: C:\Users\OmSaiRam\dataloader\v48.0.0\bin\process-conf.xml
org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'process-conf.xml' is defined
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:529)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1095)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:277)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1093)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:300)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:286)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:259)
2020-06-05 15:58:24,901 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:251) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: process-conf.xml configuration from config file: C:\Users\OmSaiRam\dataloader\v48.0.0\bin\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:97)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:300)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:286)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:259)
Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'process-conf.xml' is defined
        at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:529)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1095)
        at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:277)
        at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
        at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1093)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:93)
        ... 3 more
gajawada vaishnavigajawada vaishnavi
I am trying to insert records in salesforce....I am getting this error...can some expert help me?