search

theswamis / dataloadercliq

Command Line Interface Quickstart
12 stars 5 forks source link

Cliq doesn't upsert records to SFDC #49

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Hi I'm trying to automate upserting process with Cliq and this is error I got.

2012-04-12 14:09:09,717 INFO  [main] controller.Controller initLog 
(Controller.java:404) - The log has been initialized
2012-04-12 14:09:09,827 INFO  [main] process.ProcessConfig getBeanFactory 
(ProcessConfig.java:103) - Loading process configuration from config file: 
H:\DataLoader\cliq_process\Upsert\config\process-conf.xml
2012-04-12 14:09:10,734 INFO  [main] xml.XmlBeanDefinitionReader 
loadBeanDefinitions (XmlBeanDefinitionReader.java:315) - Loading XML bean 
definitions from file 
[H:\DataLoader\cliq_process\Upsert\config\process-conf.xml]
2012-04-12 14:09:20,858 INFO  [Upsert] controller.Controller initConfig 
(Controller.java:365) - The controller config has been initialized
2012-04-12 14:09:20,874 INFO  [Upsert] process.ProcessRunner run 
(ProcessRunner.java:116) - Initializing process engine
2012-04-12 14:09:20,889 INFO  [Upsert] process.ProcessRunner run 
(ProcessRunner.java:119) - Loading parameters
2012-04-12 14:10:00,758 ERROR [Upsert] config.Config decryptProperty 
(Config.java:682) - Error loading parameter: sfdc.proxyPassword of type: 
java.lang.String
java.lang.NumberFormatException: For input string: "Br"
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at java.lang.Integer.valueOf(Unknown Source)
    at java.lang.Integer.decode(Unknown Source)
    at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(EncryptionUtil.java:68)
    at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:204)
    at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:668)
    at com.salesforce.dataloader.config.Config.postLoad(Config.java:625)
    at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:646)
    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)
2012-04-12 14:10:00,773 FATAL [main] process.ProcessRunner topLevelError 
(ProcessRunner.java:238) - Unable to run process Upsert
java.lang.RuntimeException: 
com.salesforce.dataloader.exception.ParameterLoadException: Error loading 
parameter: sfdc.proxyPassword 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.proxyPassword of type: java.lang.String
    at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:683)
    at com.salesforce.dataloader.config.Config.postLoad(Config.java:625)
    at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config.java:646)
    at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:120)
    ... 2 more
Caused by: java.lang.NumberFormatException: For input string: "Br"
    at java.lang.NumberFormatException.forInputString(Unknown Source)
    at java.lang.Integer.parseInt(Unknown Source)
    at java.lang.Integer.valueOf(Unknown Source)
    at java.lang.Integer.decode(Unknown Source)
    at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(EncryptionUtil.java:68)
    at com.salesforce.dataloader.security.EncryptionUtil.decryptString(EncryptionUtil.java:204)
    at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:668)
    ... 5 more

Please can you help.

Original issue reported on code.google.com by mar.mro...@gmail.com on 12 Apr 2012 at 1:19

GoogleCodeExporter commented 9 years ago 
It looks like the proxy password is not encrypted correctly.  I will have to 
look into it. 

What version of data loader and cliq are you using?

Original comment by vijay.swamidass@gmail.com on 19 Apr 2012 at 5:11

GoogleCodeExporter commented 9 years ago 
I'm using 24.0 and cliq is 2.2.0

Original comment by mar.mro...@gmail.com on 20 Apr 2012 at 7:07

GoogleCodeExporter commented 9 years ago 
Hi Vijay,

I was wondering if you got a chance to look at the above issue??

Original comment by mar.mro...@gmail.com on 9 May 2012 at 1:47

GoogleCodeExporter commented 9 years ago 
I don't have a proxy environment to use for testing.  Can you tell if the proxy 
password is encrypted in process-conf.xml?  I'm not sure what 'For input 
string: "Br"' means.

Original comment by vijay.swamidass@gmail.com on 9 May 2012 at 4:22

GoogleCodeExporter commented 9 years ago 
Hi, I am having this exact issue. I can confirm that the proxy password is not 
encrypted. Is CLIq supposed to do this for you? or should you be using some 
other process to generate an encrypted password to go in the CLIq config file?

Original comment by paulbert...@gmail.com on 2 Nov 2012 at 3:47

GoogleCodeExporter commented 9 years ago 
Sorry, Versions are 2.2.0 & DL version 25.0.2

Original comment by paulbert...@gmail.com on 2 Nov 2012 at 3:49