Skip to main content The Trailblazer Community will be unavailable from 2/1/2025 to 2/2/2025. Please plan your activities accordingly.
Hi Guys

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

 
8 answers
  1. Feb 29, 2024, 7:07 AM

    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:?]

  2. Apr 26, 2016, 3:59 AM
    share your code  please are you deploing or dml u doing
  3. Mar 31, 2016, 7:39 PM
    Yury Bondarau

    The root cause of this exception is in line 25  - password is not encrypted correctly

    javax.crypto.BadPaddingException: Given final block not properly padded

    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)
  4. Mar 31, 2016, 8:34 AM
    Hi Salesforce Test5,

    It looks like problem in password encryption.  Do you use plain salesforce password? If not how did you encrypt password?
0/9000