• Ender_
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
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
I have a .csv file which contains all data needed for the update of the records of the custom object Signed Product (Product__c), whose Ids are listed in the first column. However, I am not able to map the fields, as all fields are detected as one - I login into the Data Loader, click on Update, select Signed Product in the "Select Salesforce Object:" list. Under browse, I select the appropriate .csv file. Then when I arrive to "Step 3: Mapping", the data loader detects only one column (where the header is the sequence of all headers of all columns contained in the file, separated by column ";"). Mapping is of course impossible! If I proceed with the update, I get the error file with the error "Id not specified in an update call", even though there is an ID for each record. The tool does not detect it due to the wrong mapping i.e. inability to map.

I think that this problem is connected with certain regional settings (e.g., German, Dutch) whereas the files can not be used as input .csv files for the Data Loader (I am using a German computer now, I know that there are issues with regional settings!). Should I use Notepad ++ to convert the format of the file? What should I do? I would need to get the steps necessary in order to convert the file into a .csv (comma delimited) format compatible with the tool.

Thanks a lot in advance,
& happy start of new year - looking forward to your kind replies