function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Ram-SFRam-SF 

Data Loader from command line issue

I know more blogs are there to solve this issue...Any how i was struck for a day to solve this issue Any1 help for me...

The following error i got 

C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>call process "C:\Program Files\salesforce.com\Apex Data Loader 22.0\conf" process-conf.xml csvInsertAccountProcess
2011-07-16 17:23:57,265 INFO  [main] controller.Controller initLog (Controller.j
ava:367) - The log has been initialized
2011-07-16 17:23:57,281 INFO  [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:78) - Loading process configuration from config file: C:\Program F
iles\salesforce.com\Apex Data Loader 22.0\conf\process-conf.xml
2011-07-16 17:23:57,406 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file
 [C:\Program Files\salesforce.com\Apex Data Loader 22.0\conf\process-conf.xml]
2011-07-16 17:23:57,437 ERROR [main] process.ProcessConfig getProcessInstance (P
rocessConfig.java:71) - Error loading process: process-conf.xml configuration fr
om config file: C:\Program Files\salesforce.com\Apex Data Loader 22.0\conf\proce
ss-conf.xml
org.springframework.beans.factory.BeanDefinitionStoreException: Line 1 in XML do
cument from file [C:\Program Files\salesforce.com\Apex Data Loader 22.0\conf\pro
cess-conf.xml] is invalid; nested exception is org.xml.sax.SAXParseException: Co
ntent is not allowed in prolog.
org.xml.sax.SAXParseException: Content is not allowed in prolog.
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAX
ParseException(ErrorHandlerWrapper.java:236)
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalErro
r(ErrorHandlerWrapper.java:215)
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(
XMLErrorReporter.java:386)
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(
XMLErrorReporter.java:316)
        at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(X
MLScanner.java:1438)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$Prolog
Dispatcher.dispatch(XMLDocumentScannerImpl.java:899)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:834)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:764)
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.
java:148)
        at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.
java:250)
        at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Doc
umentBuilderImpl.java:292)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB
eanDefinitions(XmlBeanDefinitionReader.java:222)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:173)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:148)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:68)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:56)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:79)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:68)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:260)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:246)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:219)
2011-07-16 17:23:57,484 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:211) - Failed to create process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loadin
g process: process-conf.xml configuration from config file: C:\Program Files\sal
esforce.com\Apex Data Loader 22.0\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:72)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:260)
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRu
nner.java:246)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:219)
Caused by: org.springframework.beans.factory.BeanDefinitionStoreException: Line
1 in XML document from file [C:\Program Files\salesforce.com\Apex Data Loader 22
.0\conf\process-conf.xml] is invalid; nested exception is org.xml.sax.SAXParseEx
ception: Content is not allowed in prolog.
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB
eanDefinitions(XmlBeanDefinitionReader.java:229)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:173)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBea
nDefinitions(XmlBeanDefinitionReader.java:148)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:68)
        at org.springframework.beans.factory.xml.XmlBeanFactory.<init>(XmlBeanFa
ctory.java:56)
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(Proces
sConfig.java:79)
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(Pr
ocessConfig.java:68)
        ... 3 more
Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog.
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAX
ParseException(ErrorHandlerWrapper.java:236)
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.fatalErro
r(ErrorHandlerWrapper.java:215)
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(
XMLErrorReporter.java:386)
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(
XMLErrorReporter.java:316)
        at com.sun.org.apache.xerces.internal.impl.XMLScanner.reportFatalError(X
MLScanner.java:1438)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$Prolog
Dispatcher.dispatch(XMLDocumentScannerImpl.java:899)
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImp
l.scanDocument(XMLDocumentFragmentScannerImpl.java:368)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:834)
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(X
ML11Configuration.java:764)
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.
java:148)
        at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.
java:250)
        at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Doc
umentBuilderImpl.java:292)
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadB
eanDefinitions(XmlBeanDefinitionReader.java:222)
        ... 9 more
C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>
Process-conf file
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="csvInsertAccountProcess"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Inserts Accounts from CSV file into Account Standard Object.</description>
        <property name="name" value="csvInsertAccountProcess"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="raamss@devforce.com"/>
	    <entry key="sfdc.password" value="bb384be643f572dc0857fd86d8228d391c816fa573515ac7e9a280e5dac02d68bf87b766d289e023" />
	    <entry key="process.encryptionKeyFile" value="C:\Program Files\salesforce.com\Apex Data Loader 22.0\Config\key.txt" />
                <entry key="sfdc.timeoutSecs" value="540"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Account"/>
                <entry key="process.operation" value="insert"/>
                <entry key="process.mappingFile" value="D:\Raam-Laptop\Project\Andrew\DL\AccountMap.sdl"/>
                <entry key="dataAccess.name" value="D:\Raam-Laptop\Project\Andrew\DL\AccountSchedule.csv" /> 
                <entry key="dataAccess.type" value="csvRead" /> 
            </map>
        </property>
   </bean>
</beans>

 the command i used to generate encrypted password was ....

C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>encrypt.bat -g <mypassword+ST>

encrypeted key 

C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>encrypt.bat -e <mypassword+ST>
I dono how to solve this error? 

Best Answer chosen by Admin (Salesforce Developers) 
Ram-SFRam-SF

Yes I solved like that only

 

XML file header error(font not found like that)

I got this out through XML spy

 

Thanks Srikeerthi

All Answers

srikeerthisrikeerthi

Hi

 

Are you giving the encrypted password in sfdc.password,also please remove the timeoutsecs 

and check it out once.

 

 

Thanks

Ram-SFRam-SF

Srikeerthi : Yes Iam using the Encrypted password, But still I am getting the same error

 

srikeerthisrikeerthi

Yes

 

Here in this command encrypt.bat -g  remove the +(mypassword+ST) and give it as mypasswordST.Then you

paste your encrypted password there.

 

I think this will help you.

 

Thanks

Ram-SFRam-SF

Still I am getting the Java exception...

C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin> encrypt.bat -g passwordSecurityToken

ResultValue1

Store this ResultValue1 in keyToDecryptUserToken.txt file

and I run this command

 

C:\Program Files\salesforce.com\Apex Data Loader 22.0\bin>encrypt.bat -e passwordSecurityToken

ResultValue2

<entry key="sfdc.password" value="ResultValue2" />
 <entry key="process.encryptionKeyFile" value="C:\SFDCDataLoad\Config\keyToDecryptUserToken.txt" />

 

Here the process-conf.xml code

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="csvInsertContact"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>Inserts Accounts from CSV file into Account Standard Object.</description>
        <property name="name" value="csvInsertContact"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="false"/>
                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
                <entry key="sfdc.username" value="raamss@devforce.com"/>
	    <entry key="sfdc.password" value="bb384be643f572dc0857fd86d8228d391c816fa573515ac7e9a280e5dac02d68bf87b766d289e023" />
	    <entry key="process.encryptionKeyFile" value="C:\SFDCDataLoad\Config\keyToDecryptUserToken.txt" />
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="Contact"/>
                <entry key="process.operation" value="insert"/>
                <entry key="process.mappingFile" value="D:\SFDCDataload\SourceData\ContactMap.sdl"/>
                <entry key="dataAccess.name" value="D:\SFDCDataload\SourceData\Contact.csv" /> 
                <entry key="dataAccess.type" value="csvRead" /> 
            </map>
        </property>
   </bean>
</beans>

 

 

 

srikeerthisrikeerthi

I have used the foolowing Conf File

 

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans> 

<bean id="InsertAccount" class="com.salesforce.dataloader.process.ProcessRunner" singleton="false">        <description>Account insert</description>

    <property name="name" value="InsertAccount"/>  

     <property name="configOverrideMap">

                <map>   

            <entry key="sfdc.endpoint" value="https://login.salesforce.com"/> 

                <entry key="sfdc.username" value="Username"/>

                  <entry key="sfdc.password" value="ac691fabfbbd576182e7eaf72edb6e4deb90f12d850a0fd3cd694f8cb6cb4b7c457de6e61960163e"/><entry key="sfdc.timeoutSecs" value="900"/> 

              <entry key="sfdc.loadBatchSize" value="200"/>         

      <entry key="sfdc.externalIdField" value="Id"/>

                 <entry key="sfdc.entity" value="Account"/> 

              <entry key="process.operation" value="insert"/> 

              <entry key="process.mappingFile" value="C:\Program Files\salesforce.com\Apex Data Loader 21.0\conf\accountInsertMap1.sdl"/>

                <entry key="dataAccess.name" value="C:\Program Files\salesforce.com\Apex Data Loader 21.0\conf\Acc1.csv"/>

                <entry key="dataAccess.type" value="csvRead"/> 

              <entry key="process.initialLastRunDate" value="2011-04-09T00:00:00.000-1200"/> 

              <entry key="process.outputError" value="D:\Status\AccountError.csv"/>

               <entry key="process.outputSuccess" value="D:\Status\AccountSuccess.csv"/>           

    <entry key="process.statusOutputDirectory" value="C:\Program Files\salesforce.com\test1" />

</map> 

      </property>

    </bean>

 </beans>

 

 

and executed the flle using process ../conf InsertAccount.


It worked for me and the Success and Error Files were generated.

 

 

Ram-SFRam-SF

Still I am blank....

 

srikeerthisrikeerthi

 

If you had time then Try doing the same in other system(PC) it might work.

 

 

 

Ram-SFRam-SF

Yes I solved like that only

 

XML file header error(font not found like that)

I got this out through XML spy

 

Thanks Srikeerthi

This was selected as the best answer
srikeerthisrikeerthi

 

Hi

 

If your problem is resolved mark it as a solution so that others can benefit from that.

 

 

Thanks