• Amanda Mentgen
  • NEWBIE
  • 0 Points
  • Member since 2023

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies
Hello,

I am trying to insert test Account data via Data Loader using the Command Prompt. 
Here is what I get back after process.bat is run....

C:\Users\amanda.mentgen\dataloader_v59.0.0\bin>process.bat "C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf" accountInsert
Data Loader requires Java JRE 17 or later. Checking if it is installed...
2023-09-29 09:47:32,013 INFO  [main] process.ProcessRunner getInstance (ProcessRunner.java:288) - Initializing process engine
2023-09-29 09:47:32,013 INFO  [main] process.ProcessRunner getInstance (ProcessRunner.java:303) - process.nameis specified in the command line. Loading DynaBean with id accountInsert from process-conf.xml located in folder C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf
2023-09-29 09:47:32,029 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:106) - Loading process configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
Standard Commons Logging discovery in action with spring-jcl: please remove commons-logging.jar from classpath in order to avoid potential conflicts
2023-09-29 09:47:32,178 ERROR [main] process.ProcessConfig getProcessInstance (ProcessConfig.java:98) - Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 3 in XML document from file [C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml] is invalid
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:402) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:338) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:184) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:220) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:191) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:253) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:128) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:94) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:696) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:113) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:308) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:254) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:101) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83) [dataloader-59.0.0.jar:?]
Caused by: org.xml.sax.SAXParseException: Document root element "pkg:package", must match DOCTYPE root "null".
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:204) ~[?:?]
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:135) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1539) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1806) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:728) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1407) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1292) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3079) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:836) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:605) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:542) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:889) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:825) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:247) ~[?:?]
        at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:342) ~[?:?]
        at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:77) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadDocument(XmlBeanDefinitionReader.java:432) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390) ~[dataloader-59.0.0.jar:?]
        ... 19 more
2023-09-29 09:47:32,195 FATAL [main] process.ProcessRunner logErrorAndExitProcess (ProcessRunner.java:244) - Unable to run process
com.salesforce.dataloader.exception.ProcessInitializationException: Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:99) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.getInstance(ProcessRunner.java:308) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:254) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:101) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83) [dataloader-59.0.0.jar:?]
Caused by: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 3 in XML document from file [C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml] is invalid
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:402) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:338) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:184) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:220) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:191) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:253) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:128) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:94) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:696) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:113) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) ~[dataloader-59.0.0.jar:?]
        ... 4 more
Caused by: org.xml.sax.SAXParseException: Document root element "pkg:package", must match DOCTYPE root "null".
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.createSAXParseException(ErrorHandlerWrapper.java:204) ~[?:?]
        at com.sun.org.apache.xerces.internal.util.ErrorHandlerWrapper.error(ErrorHandlerWrapper.java:135) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:396) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:327) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLErrorReporter.reportError(XMLErrorReporter.java:284) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.rootElementSpecified(XMLDTDValidator.java:1539) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.handleStartElement(XMLDTDValidator.java:1806) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.dtd.XMLDTDValidator.startElement(XMLDTDValidator.java:728) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanStartElement(XMLDocumentFragmentScannerImpl.java:1407) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$ContentDriver.scanRootElementHook(XMLDocumentScannerImpl.java:1292) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl$FragmentContentDriver.next(XMLDocumentFragmentScannerImpl.java:3079) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(XMLDocumentScannerImpl.java:836) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(XMLDocumentScannerImpl.java:605) ~[?:?]
        at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(XMLDocumentFragmentScannerImpl.java:542) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:889) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(XML11Configuration.java:825) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(XMLParser.java:141) ~[?:?]
        at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(DOMParser.java:247) ~[?:?]
        at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(DocumentBuilderImpl.java:342) ~[?:?]
        at org.springframework.beans.factory.xml.DefaultDocumentLoader.loadDocument(DefaultDocumentLoader.java:77) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadDocument(XmlBeanDefinitionReader.java:432) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:390) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:338) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:310) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:184) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:220) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:191) ~[dataloader-59.0.0.jar:?]
        at org.springframework.beans.factory.support.AbstractBeanDefinitionReader.loadBeanDefinitions(AbstractBeanDefinitionReader.java:253) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:128) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractXmlApplicationContext.loadBeanDefinitions(AbstractXmlApplicationContext.java:94) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractRefreshableApplicationContext.refreshBeanFactory(AbstractRefreshableApplicationContext.java:130) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.obtainFreshBeanFactory(AbstractApplicationContext.java:696) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:578) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-59.0.0.jar:?]
        at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getBeanFactory(ProcessConfig.java:113) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessConfig.getProcessInstance(ProcessConfig.java:95) ~[dataloader-59.0.0.jar:?]
        ... 4 more
2023-09-29 09:47:32,195 FATAL [main] process.ProcessRunner logErrorAndExitProcess (ProcessRunner.java:244) - Unable to run process
java.lang.RuntimeException: Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessRunner.logErrorAndExitProcess(ProcessRunner.java:245) ~[dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.ProcessRunner.runBatchMode(ProcessRunner.java:270) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:101) [dataloader-59.0.0.jar:?]
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83) [dataloader-59.0.0.jar:?]
Exception in thread "main" java.lang.RuntimeException: Error loading process: accountInsert configuration from config file: C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\conf\process-conf.xml
        at com.salesforce.dataloader.process.ProcessRunner.logErrorAndExitProcess(ProcessRunner.java:245)
        at com.salesforce.dataloader.process.DataLoaderRunner.runApp(DataLoaderRunner.java:103)
        at com.salesforce.dataloader.process.DataLoaderRunner.main(DataLoaderRunner.java:83)

Here is what I have in the XML file...
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="accountInsert"
class="com.salesforce.dataloader.process.ProcessRunner"
scope="prototype">
<description>accountInsert job gets the account record from the CSV file
and inserts it into Salesforce.</description>
<property name="name" value="accountInsert"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\status\accountInsertSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://ifcjdevdata.lightning.force.com"/>
<entry key="sfdc.username" value="devdata123@ifcjdevdata.org"/>
<!--Password below has been encrypted using key file,
therefore, it will not work without the key setting:
process.encryptionKeyFile.
The password is not a valid encrypted value,
please generate the real value using the encrypt.bat utility -->
<entry key="sfdc.password" value="ea90e3df7f51caaf3cb4e96b6c7c479d1abcd46bd319814ee7e"/>
<entry key="process.encryptionKeyFile"
value="c:\Users\amanda.mentgen\.dataloader\dataLoader.key"/>
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="process.operation" value="insert"/>
<entry key="process.mappingFile"
value="C:\amanda.mentgen\dataloader_v59.0.0\samples\conf\accountInsertMap.sdl"/>
<entry key="dataAccess.name"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\data\insertAccounts.csv"/>
<entry key="process.outputSuccess"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\status\accountInsert_success.csv"/>
<entry key="process.outputError"
value=" C:\Users\amanda.mentgen\dataloader_v59.0.0\samples\status\accountInsert_error.csv"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="process.initialLastRunDate"
value="2023-09-29T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>