• sfcomdeveloper
  • NEWBIE
  • 0 Points
  • Member since 2011

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

 

I am a newbie, This is the command I m executing

 

c:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\bin>process.bat "C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf" csvAccountExtractProcess

 

Not sure how to resolve this error and the error I m getting is 

 

2011-06-28 00:47:41,686 INFO  [main] controller.Controller initLog (Controller.java:367) - The log has been initialized2011-06-28 00:47:41,691 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\process-conf.xml2011-06-28 00:47:41,735 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\process-conf.xml]2011-06-28 00:47:41,761 INFO  [main] core.CollectionFactory <clinit> (CollectionFactory.java:66) - JDK 1.4+ collections available2011-06-28 00:47:41,770 INFO  [main] core.CollectionFactory <clinit> (CollectionFactory.java:71) - Commons Collections 3.x available2011-06-28 00:47:41,825 INFO  [csvAccountExtract] controller.Controller initConfig (Controller.java:328) - The controller config has been initialized2011-06-28 00:47:41,829 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:90) - Initializing process engine2011-06-28 00:47:41,830 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:93) - Loading parameters2011-06-28 00:47:42,762 INFO  [csvAccountExtract] config.LastRun load (LastRun.java:101) - Last run info will be saved in file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\csvAccountExtract_lastRun.properties2011-06-28 00:47:42,774 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:101) - Logging in to: https://login.salesforce.com2011-06-28 00:47:42,783 INFO  [csvAccountExtract] client.PartnerClient login (PartnerClient.java:448) - Beginning Partner Salesforce login ....2011-06-28 00:47:42,803 INFO  [csvAccountExtract] client.PartnerClient loginInternal (PartnerClient.java:488) - Salesforce login to https://login.salesforce.com/services/Soap/u/22.0 as user xxx@hotmail.com2011-06-28 00:47:43,530 INFO  [csvAccountExtract] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\OutputFiles\extract.csv of type: csvWrite2011-06-28 00:47:43,564 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:106) - Checking the data access object connection2011-06-28 00:47:43,569 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:111) - Setting field types2011-06-28 00:47:44,464 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:115) - Setting object reference types2011-06-28 00:47:45,310 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:119) - Creating Map2011-06-28 00:47:45,350 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:211) - Unable to run process csvAccountExtractjava.lang.RuntimeException: java.lang.IllegalArgumentException: Cannot parse empty string        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:136)        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:74)        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:226)Caused by: java.lang.IllegalArgumentException: Cannot parse empty string        at com.salesforce.dataloader.mapping.SOQLInfo.getTrimmed(SOQLInfo.java:162)        at com.salesforce.dataloader.mapping.SOQLInfo.access$000(SOQLInfo.java:38)        at com.salesforce.dataloader.mapping.SOQLInfo$SOQLFieldInfo.<init>(SOQLInfo.java:52)        at com.salesforce.dataloader.mapping.SOQLInfo$SOQLFieldInfo.<init>(SOQLInfo.java:72)        at com.salesforce.dataloader.mapping.SOQLMapper.putPropertyEntry(SOQLMapper.java:98)        at com.salesforce.dataloader.mapping.Mapper.putPropertyFileMappings(Mapper.java:129)        at com.salesforce.dataloader.mapping.Mapper.putPropertyFileMappings(Mapper.java:124)        at com.salesforce.dataloader.mapping.Mapper.<init>(Mapper.java:76)        at com.salesforce.dataloader.mapping.SOQLMapper.<init>(SOQLMapper.java:57)        at com.salesforce.dataloader.controller.Controller.createMapper(Controller.java:179)        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)        ... 2 more

 

Process-conf.xml is 

 

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>    <bean id="csvAccountExtractProcess"          class="com.salesforce.dataloader.process.ProcessRunner"          singleton="false">      <description>csvAccountExtract job gets account info from salesforce and saves info into a CSV file."</description>        <property name="name" value="csvAccountExtract"/>        <property name="configOverrideMap">            <map>                <entry key="sfdc.debugMessages" value="false"/>                <entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log"/>                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>                <entry key="sfdc.username" value="xxx@abc.com"/>               <!-- 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 encrypt.bat utility -->                <entry key="sfdc.password" value="f9ffa659b6f79c1993e42d748778"/><entry key="process.encryptionKeyFile" value="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\sforcekey.key"/>                <entry key="sfdc.timeoutSecs" value="600"/>                <entry key="sfdc.loadBatchSize" value="200"/>                <entry key="sfdc.entity" value="Account"/>                <entry key="sfdc.extractionRequestSize" value="500"/>                <entry key="sfdc.extractionSOQL" value="Select Id, Name, Type, ParentId, Phone, AccountNumber, Website, Sic, AnnualRevenue, NumberOfEmployees, TickerSymbol, Oracle_Id__c FROM Account"/>                <entry key="process.operation" value="extract"/>                <entry key="process.mappingFile" value="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\samples\conf\accountExtractMap.sdl"/>                <entry key="dataAccess.type" value="csvWrite"/>                <entry key="dataAccess.name" value="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\OutputFiles\extract.csv"/>            </map>        </property>    </bean></beans>

 

Any help will be greatly appreciated.

 

I am a newbie, This is the command I m executing

 

c:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\bin>process.bat "C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf" csvAccountExtractProcess

 

Not sure how to resolve this error and the error I m getting is 

 

2011-06-28 00:47:41,686 INFO  [main] controller.Controller initLog (Controller.java:367) - The log has been initialized2011-06-28 00:47:41,691 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:78) - Loading process configuration from config file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\process-conf.xml2011-06-28 00:47:41,735 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:163) - Loading XML bean definitions from file [C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\process-conf.xml]2011-06-28 00:47:41,761 INFO  [main] core.CollectionFactory <clinit> (CollectionFactory.java:66) - JDK 1.4+ collections available2011-06-28 00:47:41,770 INFO  [main] core.CollectionFactory <clinit> (CollectionFactory.java:71) - Commons Collections 3.x available2011-06-28 00:47:41,825 INFO  [csvAccountExtract] controller.Controller initConfig (Controller.java:328) - The controller config has been initialized2011-06-28 00:47:41,829 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:90) - Initializing process engine2011-06-28 00:47:41,830 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:93) - Loading parameters2011-06-28 00:47:42,762 INFO  [csvAccountExtract] config.LastRun load (LastRun.java:101) - Last run info will be saved in file: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\csvAccountExtract_lastRun.properties2011-06-28 00:47:42,774 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:101) - Logging in to: https://login.salesforce.com2011-06-28 00:47:42,783 INFO  [csvAccountExtract] client.PartnerClient login (PartnerClient.java:448) - Beginning Partner Salesforce login ....2011-06-28 00:47:42,803 INFO  [csvAccountExtract] client.PartnerClient loginInternal (PartnerClient.java:488) - Salesforce login to https://login.salesforce.com/services/Soap/u/22.0 as user xxx@hotmail.com2011-06-28 00:47:43,530 INFO  [csvAccountExtract] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\OutputFiles\extract.csv of type: csvWrite2011-06-28 00:47:43,564 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:106) - Checking the data access object connection2011-06-28 00:47:43,569 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:111) - Setting field types2011-06-28 00:47:44,464 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:115) - Setting object reference types2011-06-28 00:47:45,310 INFO  [csvAccountExtract] process.ProcessRunner run (ProcessRunner.java:119) - Creating Map2011-06-28 00:47:45,350 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:211) - Unable to run process csvAccountExtractjava.lang.RuntimeException: java.lang.IllegalArgumentException: Cannot parse empty string        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:136)        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:74)        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:226)Caused by: java.lang.IllegalArgumentException: Cannot parse empty string        at com.salesforce.dataloader.mapping.SOQLInfo.getTrimmed(SOQLInfo.java:162)        at com.salesforce.dataloader.mapping.SOQLInfo.access$000(SOQLInfo.java:38)        at com.salesforce.dataloader.mapping.SOQLInfo$SOQLFieldInfo.<init>(SOQLInfo.java:52)        at com.salesforce.dataloader.mapping.SOQLInfo$SOQLFieldInfo.<init>(SOQLInfo.java:72)        at com.salesforce.dataloader.mapping.SOQLMapper.putPropertyEntry(SOQLMapper.java:98)        at com.salesforce.dataloader.mapping.Mapper.putPropertyFileMappings(Mapper.java:129)        at com.salesforce.dataloader.mapping.Mapper.putPropertyFileMappings(Mapper.java:124)        at com.salesforce.dataloader.mapping.Mapper.<init>(Mapper.java:76)        at com.salesforce.dataloader.mapping.SOQLMapper.<init>(SOQLMapper.java:57)        at com.salesforce.dataloader.controller.Controller.createMapper(Controller.java:179)        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)        ... 2 more

 

Process-conf.xml is 

 

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans>    <bean id="csvAccountExtractProcess"          class="com.salesforce.dataloader.process.ProcessRunner"          singleton="false">      <description>csvAccountExtract job gets account info from salesforce and saves info into a CSV file."</description>        <property name="name" value="csvAccountExtract"/>        <property name="configOverrideMap">            <map>                <entry key="sfdc.debugMessages" value="false"/>                <entry key="sfdc.debugMessagesFile" value="c:\dataloader\samples\status\sfdcSoapTrace.log"/>                <entry key="sfdc.endpoint" value="https://login.salesforce.com"/>                <entry key="sfdc.username" value="xxx@abc.com"/>               <!-- 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 encrypt.bat utility -->                <entry key="sfdc.password" value="f9ffa659b6f79c1993e42d748778"/><entry key="process.encryptionKeyFile" value="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\conf\sforcekey.key"/>                <entry key="sfdc.timeoutSecs" value="600"/>                <entry key="sfdc.loadBatchSize" value="200"/>                <entry key="sfdc.entity" value="Account"/>                <entry key="sfdc.extractionRequestSize" value="500"/>                <entry key="sfdc.extractionSOQL" value="Select Id, Name, Type, ParentId, Phone, AccountNumber, Website, Sic, AnnualRevenue, NumberOfEmployees, TickerSymbol, Oracle_Id__c FROM Account"/>                <entry key="process.operation" value="extract"/>                <entry key="process.mappingFile" value="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\samples\conf\accountExtractMap.sdl"/>                <entry key="dataAccess.type" value="csvWrite"/>                <entry key="dataAccess.name" value="C:\Program Files (x86)\salesforce.com\Apex Data Loader 22.0\OutputFiles\extract.csv"/>            </map>        </property>    </bean></beans>

 

Any help will be greatly appreciated.