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
AlSawtoothAlSawtooth 

Dataloader Command Line - java.lang.String

I've looked through a lot of questions on this error and none of the solutions I've seen (-e v -g, move config to another folder, etc) seem to be working for me. Any suggestions are greatly appreciated!

Here is my process-conf.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"
singleton="false">
<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="true"/>
<entry key="sfdc.debugMessagesFile"
value="C:\Program Files (x86)\salesforce.com\Data Loader\samples\data\debugMessagesFile"/>
<entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
<entry key="sfdc.username" value="masked@masked.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 the encrypt.bat utility -->
<entry key="sfdc.password" value="a288a76104221ee474bd48aa44aa49da1a11645e2ca9c62bd8eeda86c143e5f2d3f9389b890741a3"/>
<!--the password above was created through encrypt.bat -e PasswordSecurityToken plus a path the the Key file-->
<entry key="process.encryptionKeyFile"
value="C:\Program Files (x86)\salesforce.com\Data Loader\key.txt"/>
<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:\Program Files (x86)\salesforce.com\Data Loader\samples\testaccountmatch.sdl"/>
<entry key="dataAccess.name"
value="C:\Program Files (x86)\salesforce.com\Data Loader\samples\data\Test Account Insert.csv"/>
<entry key="process.outputSuccess"
value="c:\Program Files (x86)\salesforce.com\Data Loader\samples\data\outputSuccess.csv"/>
<entry key="process.outputError"
value="c:\Program Files (x86)\salesforce.com\Data Loader\samples\data\outputError.csv"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="process.initialLastRunDate"
value="2005-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>

Here's my command line error:
c:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "c:\Program Files (x86)\salesforce.com\Data Loader\samples" accountInsert
2015-01-06 09:27:28,326 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-01-06 09:27:28,326 INFO  [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2015-01-06 09:27:28,326 INFO  [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: c:\Program Files (x86)\salesforce.com\Data Loader\samples\process-conf.xml
2015-01-06 09:27:28,419 INFO  [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [c:\Program Files (x86)\salesforce.com\Data Loader\samples\process-conf.xml]
2015-01-06 09:27:28,466 INFO  [accountInsert] controller.Controller initConfig (Controller.java:327) - config dir created at c:\Program Files (x86)\salesforce.com\Data Loader\samples
2015-01-06 09:27:28,466 INFO  [accountInsert] controller.Controller initConfig (Controller.java:338) - config file created at c:\Program Files (x86)\salesforce.com\Data Loader\samples\config.properties
2015-01-06 09:27:28,482 INFO  [accountInsert] controller.Controller initConfig (Controller.java:355) - The controller config has been initialized
2015-01-06 09:27:28,482 INFO  [accountInsert] process.ProcessRunner run (ProcessRunner.java:116) - Initializing process engine
2015-01-06 09:27:28,482 INFO  [accountInsert] process.ProcessRunner run (ProcessRunner.java:119) - Loading parameters
2015-01-06 09:27:28,934 ERROR [accountInsert] config.Config decryptProperty (Config.java:692) - Error loading parameter: sfdc.password of type: java.lang.String

javax.crypto.BadPaddingException: Given final block not properly padded
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA13*..)
        at javax.crypto.Cipher.doFinal(DashoA13*..)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:210)
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:686)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:638)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:664)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
2015-01-06 09:27:28,934 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process accountInsert
java.lang.RuntimeException: com.salesforce.dataloader.exception.ParameterLoadException: Error loading parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.salesforce.dataloader.exception.ParameterLoadException: Error loading parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:693)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:638)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:664)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
        ... 2 more
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA13*..)
        at javax.crypto.Cipher.doFinal(DashoA13*..)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:210)
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:686)

javax.crypto.BadPaddingException: Given final block not properly padded
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA13*..)
        at javax.crypto.Cipher.doFinal(DashoA13*..)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:210)
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:686)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:638)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:664)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
2015-01-06 09:27:28,934 FATAL [main] process.ProcessRunner topLevelError (ProcessRunner.java:238) - Unable to run process accountInsert
java.lang.RuntimeException: com.salesforce.dataloader.exception.ParameterLoadException: Error loading parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:162)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100)
        at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253)
Caused by: com.salesforce.dataloader.exception.ParameterLoadException: Error loading parameter: sfdc.password of type: java.lang.String
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:693)
        at com.salesforce.dataloader.config.Config.postLoad(Config.java:638)
        at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:664)
        at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
        ... 2 more
Caused by: javax.crypto.BadPaddingException: Given final block not properly padded
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.SunJCE_f.b(DashoA13*..)
        at com.sun.crypto.provider.DESCipher.engineDoFinal(DashoA13*..)
        at javax.crypto.Cipher.doFinal(DashoA13*..)
        at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:210)
        at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:686)
        ... 5 more
Ender_Ender_
It looks like an error in the set password in the process config.  Did you generate the key using encrypt.bat?
Gaurav_Gaurav_
Hi , Did you find any solution for the error above?