I am facing issue on commandline data loader when i run my script.how to achieve this ?
C:\Program Files (x86)\salesforce.com\Data Loader\bin>process.bat "D:\test1" Inv
oiceUpsert
2016-03-31 13:08:48,286 INFO [main] controller.Controller initLog (Controller.j
ava:389) - Using built-in logging configuration, no log-conf.xml in C:\Program F
iles (x86)\salesforce.com\Data Loader\bin\log-conf.xml
2016-03-31 13:08:48,298 INFO [main] controller.Controller initLog (Controller.j
ava:391) - The log has been initialized
2016-03-31 13:08:48,304 INFO [main] process.ProcessConfig getBeanFactory (Proce
ssConfig.java:103) - Loading process configuration from config file: D:\test1\pr
ocess-conf.xml
2016-03-31 13:08:48,501 INFO [main] xml.XmlBeanDefinitionReader loadBeanDefinit
ions (XmlBeanDefinitionReader.java:315) - Loading XML bean definitions from file
[D:\test1\process-conf.xml]
2016-03-31 13:08:48,635 INFO [InvoiceUpsert] controller.Controller initConfig (
Controller.java:327) - config dir created at D:\test1
2016-03-31 13:08:48,654 INFO [InvoiceUpsert] controller.Controller initConfig (
Controller.java:355) - The controller config has been initialized
2016-03-31 13:08:48,656 INFO [InvoiceUpsert] process.ProcessRunner run (Process
Runner.java:116) - Initializing process engine
2016-03-31 13:08:48,658 INFO [InvoiceUpsert] process.ProcessRunner run (Process
Runner.java:119) - Loading parameters
2016-03-31 13:08:49,679 ERROR [InvoiceUpsert] config.Config decryptProperty (Con
fig.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(Encry
ptionUtil.java:210)
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
86)
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.jav
a:120)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
2016-03-31 13:08:49,692 FATAL [main] process.ProcessRunner topLevelError (Proces
sRunner.java:238) - Unable to run process InvoiceUpsert
java.lang.RuntimeException: com.salesforce.dataloader.exception.ParameterLoadExc
eption: Error loading parameter: sfdc.password of type: java.lang.String
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:162)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:100)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:253)
Caused by: com.salesforce.dataloader.exception.ParameterLoadException: Error loa
ding parameter: sfdc.password of type: java.lang.String
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
93)
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.jav
a:120)
... 2 more
Caused by: javax.crypto.BadPaddingException: Given final block not properly padd
ed
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(Encry
ptionUtil.java:210)
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
86)
... 5 more
C:\Program Files (x86)\salesforce.com\Data Loader\bin>^A
Can anyone help me with this error-
2024-02-29 12:34:19,259 INFO [Rating] process.ProcessRunner run (ProcessRunner.java:158) - Setting field types
2024-02-29 12:34:21,409 INFO [Rating] process.ProcessRunner run (ProcessRunner.java:162) - Setting object reference types
2024-02-29 12:34:28,409 INFO [Rating] process.ProcessRunner run (ProcessRunner.java:166) - Creating Map
2024-02-29 12:34:28,409 INFO [Rating] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:55) - Instantiating data access object: queryRatingAll of type: databaseRead
2024-02-29 12:34:28,453 WARN [Rating] support.AbstractApplicationContext refresh (AbstractApplicationContext.java:633) - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'queryRatingAll' defined in file [C:\Users\ujennifx\OneDrive - Intel Corporation\Desktop\Rating Data Loader\database-conf.xml]: Cannot resolve reference to bean 'dbDataSource' while setting bean property 'dataSource'
2024-02-29 12:34:28,455 FATAL [Rating] controller.Controller createDao (Controller.java:241) - Error creating data access object
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'queryRatingAll' defined in file [C:\Users\ujennifx\OneDrive - Intel Corporation\Desktop\Rating Data Loader\database-conf.xml]: Cannot resolve reference to bean 'dbDataSource' while setting bean property 'dataSource'
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:377) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:135) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1684) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1433) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:521) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:325) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:323) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[dataloader-60.0.0.jar:?]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:975) ~[dataloader-60.0.0.jar:?]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:960) ~[dataloader-60.0.0.jar:?]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:625) ~[dataloader-60.0.0.jar:?]
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:142) ~[dataloader-60.0.0.jar:?]
at org.springframework.context.support.FileSystemXmlApplicationContext.<init>(FileSystemXmlApplicationContext.java:85) ~[dataloader-60.0.0.jar:?]
at com.salesforce.dataloader.dao.database.DatabaseConfig.getInstance(DatabaseConfig.java:55) ~[dataloader-60.0.0.jar:?]
at com.salesforce.dataloader.dao.database.DatabaseReader.<init>(DatabaseReader.java:84) ~[dataloader-60.0.0.jar:?]
Yury Bondarau The root cause of this exception is in line 25 - password is not encrypted correctly
The reason of this issue potentially can be in difference between encryption method (when you generated password) and dectyption (when you pass encoded password it can not be properly decrypted)Could you please try to re-generate password. And also could you please provide command lines you used to generate key.txt; password and data-loader configuration xml (process-conf.xml)javax.crypto.BadPaddingException: Given final block not properly padded
Hi Yury
I have generated encrypted password like this .but its showing error .why...
The following document will help you to generate encrypted password - https://developer.salesforce.com/docs/atlas.en-us.dataLoader.meta/dataLoader/command_line_create_encryption_key.htm Hi Salesforce Test5,It looks like problem in password encryption. Do you use plain salesforce password? If not how did you encrypt password?