Apex Code Development You need to sign in to do that
Don't have an account?
JR1204 Data loader using command line- password issue
Hi Folks,
I'm trying to run an insert using Data loader with command line interface. Below is my command:
C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\Salesforce.com" accountInsert
Below is the output:
2013-08-22 12:45:14,402 INFO [main] controller.Controller initLog (Controller.java:382) - Reading log-conf.xml in C:\Program Files\salesforce.com\Data Loader\bin\log-conf.xml
2013-08-22 12:45:15,651 INFO [main] controller.Controller initLog (Controller.java:391) - The log has been initialized
2013-08-22 12:45:15,687 INFO [main] process.ProcessConfig getBeanFactory (ProcessConfig.java:103) - Loading process configuration from config file: C:\program files\salesforce.com\process-conf.xml
2013-08-22 12:45:16,506 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file [C:\program files\salesforce.com\process-conf.xml]
2013-08-22 12:45:16,708 INFO [accountInsert] controller.Controller initConfig (Controller.java:327) - config dir created at C:\program files\salesforce.com
2013-08-22 12:45:17,117 INFO [accountInsert] controller.Controller initConfig (Controller.java:355) - The controller config has been initialized
2013-08-22 12:45:17,150 INFO [accountInsert] process.ProcessRunner run (ProcessRunner.java:116) - Initializing process engine
2013-08-22 12:45:17,150 INFO [accountInsert] process.ProcessRunner run (ProcessRunner.java:119) - Loading parameters
2013-08-22 12:45:19,342 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)
2013-08-22 12:45:19,344 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
I first need to figure out the sfdc.password error. I am encrypting with encrypt.bat, and it is a concatenated value of my salesforce password + salesforce security token. I am under the impression this is how it should be encrypted.
Any advice would be greatly appreciated!
Thanks,
Hi,
Locate process-conf.xml file in the Data Loder installation folder & comment out the line
<!--entry key="process.encryptionKeyFile" value="C:\key.txt"/-->
Also, dont forget to add security token to ur password. i.e.password followed by security token
Thanks for the reply. I commented out the line mentioned above, but am still getting the same error. As far as password encryption: I have encrypted (my password + security token). So it is a long string of encrypted characters. Is this correct? Or should I only encrypt the password, and then append the security token on the end?
Would it help if I posted my .xml code?
<!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\salesforce.com\Data Loader\samples\status\accountmastersoaptrace.log"/>
<entry key="sfdc.endpoint" value="https://test.salesforce.com"/>
<entry key="sfdc.username" value="xxxxx@xxxxx.com.sandbox"/>
<!--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="f2576c72b3d339abef4ae130114ed54cc636f4cea7275e1193f71e59a8003744f6fa882622aa20c7"/>
<!--entry key="process.encryptionKeyFile"
value="C:\Program Files\salesforce.com\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\salesforce.com\accountInsertMap.sdl"/>
<entry key="dataAccess.name"
value="C:\Program Files\salesforce.com\AccountInsert.csv"/>
<entry key="process.outputSuccess"
value="c:\Program Files\salesforce.com\accountInsert_success.csv"/>
<entry key="process.outputError"
value="c:\Program Files\salesforce.com\accountInsert_error.csv"/>
<entry key="dataAccess.type" value="csvRead"/>
<entry key="process.initialLastRunDate"
value="2005-12-01T00:00:00.000-0800"/>
</map>
</property>
</bean>
</beans>
Thanks again,
Has anybody solved this issue? I getting the same error...