You need to sign in to do that
Don't have an account?
Ram-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?
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
Hi
Are you giving the encrypted password in sfdc.password,also please remove the timeoutsecs
and check it out once.
Thanks
Srikeerthi : Yes Iam using the Encrypted password, But still I am getting the same error
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
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
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.
Still I am blank....
If you had time then Try doing the same in other system(PC) it might work.
Yes I solved like that only
XML file header error(font not found like that)
I got this out through XML spy
Thanks Srikeerthi
Hi
If your problem is resolved mark it as a solution so that others can benefit from that.
Thanks