Apex Code Development You need to sign in to do that
Don't have an account?
Geetha Reddy Struggling with Apex Data Loader Command Line Password
I seem to be having an issue with the Encrypt or decrypt portion of the password process.
Even i added security token to it but same problem.
0 [main] INFO com.salesforce.dataloader.process.ProcessConfig - Loading process
configuration from config file: C:\Datalodercli\process-conf.xml
47 [main] INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader -
Loading XML bean definitions from file [C:\Datalodercli\process-conf.xml]
47 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanDefinitionReader -
Using JAXP implementation [com.sun.org.apache.xerces.internal.jaxp.DocumentBuil
derFactoryImpl@1256ea2]
62 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver -
Trying to resolve XML entity with public ID [-//SPRING//DTD BEAN//EN] and system
62 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver -
Trying to locate [spring-beans.dtd] in Spring jar
78 [main] DEBUG org.springframework.beans.factory.xml.ResourceEntityResolver -
Found beans DTD [http://www.springframework.org/dtd/spring-beans.dtd] in classpa
th
94 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionPa
rser - Loading bean definitions
94 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionPa
rser - Default lazy init 'false'
94 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionPa
rser - Default autowire 'no'
94 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionPa
rser - Default dependency check 'none'
94 [main] INFO org.springframework.core.CollectionFactory - JDK 1.4+ collection
s available
94 [main] INFO org.springframework.core.CollectionFactory - Commons Collections
3.x available
109 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.ut
il.LinkedHashMap]
109 [main] DEBUG org.springframework.beans.factory.xml.DefaultXmlBeanDefinitionP
arser - Found 1 <bean> elements in file [C:\Datalodercli\process-conf.xml]
109 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Creatin
g instance of bean 'accountMasterProcess' with merged definition [Root bean: cla
ss [com.salesforce.dataloader.process.ProcessRunner]; abstract=false; singleton=
false; lazyInit=false; autowire=0; dependencyCheck=0; initMethodName=null; destr
oyMethodName=null; factoryMethodName=null; factoryBeanName=null; defined in file
[C:\Datalodercli\process-conf.xml]]
109 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g BeanPostProcessors before instantiation of bean 'accountMasterProcess'
125 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Getting
BeanInfo for class [com.salesforce.dataloader.process.ProcessRunner]
125 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Caching
PropertyDescriptors for class [com.salesforce.dataloader.process.ProcessRunner]
140 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'class' of type [java.lang.Class]
140 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'configOverrideMap' of type [java.util.Map]
140 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'controller' of type [com.salesforce.dataloader.controller.Controller]
140 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Found p
roperty 'name' of type [java.lang.String]
140 [main] DEBUG org.springframework.beans.CachedIntrospectionResults - Class [
com.salesforce.dataloader.process.ProcessRunner] is cache-safe
156 [main] DEBUG org.springframework.core.CollectionFactory - Creating [java.ut
il.LinkedHashMap]
156 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setName(java.lang.String)] on object of class [com.salesforce.dataloader.pr
ocess.ProcessRunner]
172 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
Name(java.lang.String)] with value of type [java.lang.String]
172 [main] DEBUG org.springframework.beans.BeanWrapperImpl - About to invoke wr
ite method [public synchronized void com.salesforce.dataloader.process.ProcessRu
nner.setConfigOverrideMap(java.util.Map)] on object of class [com.salesforce.dat
aloader.process.ProcessRunner]
172 [main] DEBUG org.springframework.beans.BeanWrapperImpl - Invoked write meth
od [public synchronized void com.salesforce.dataloader.process.ProcessRunner.set
ConfigOverrideMap(java.util.Map)] with value of type [java.util.Map]
187 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g BeanPostProcessors before initialization of bean 'accountMasterProcess'
187 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g afterPropertiesSet() on bean with name 'accountMasterProcess'
187 [main] DEBUG org.springframework.beans.factory.xml.XmlBeanFactory - Invokin
g BeanPostProcessors after initialization of bean 'accountMasterProcess'
219 [accountMasterProcess] INFO com.salesforce.dataloader.controller.Controller
- The controller config has been initialized
219 [accountMasterProcess] INFO com.salesforce.dataloader.process.ProcessRunner
- Initializing process engine
219 [accountMasterProcess] INFO com.salesforce.dataloader.process.ProcessRunner
- Loading parameters
922 [accountMasterProcess] ERROR com.salesforce.dataloader.config.Config - Erro
r loading parameter: sfdc.password of type: java.lang.String
java.lang.NumberFormatException: For input string: "as"
at java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
at java.lang.Integer.parseInt(Integer.java:456)
at java.lang.Integer.valueOf(Integer.java:526)
at java.lang.Integer.decode(Integer.java:919)
at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(Encrypt
ionUtil.java:58)
at com.salesforce.dataloader.security.EncryptionUtil.decryptString(Encry
ptionUtil.java:194)
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
68)
at com.salesforce.dataloader.config.Config.postLoad(Config.java:620)
at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config
.java:646)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:95)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:75)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:227)
969 [main] FATAL com.salesforce.dataloader.process.ProcessRunner - Unable to ru
n process accountMasterProcess
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:137)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:75)
at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.ja
va:227)
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
83)
at com.salesforce.dataloader.config.Config.postLoad(Config.java:620)
at com.salesforce.dataloader.config.Config.loadParameterOverrides(Config
.java:646)
at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.jav
a:95)
... 2 more
Caused by: java.lang.NumberFormatException: For input string: "as"
at java.lang.NumberFormatException.forInputString(NumberFormatException.
java:48)
at java.lang.Integer.parseInt(Integer.java:456)
at java.lang.Integer.valueOf(Integer.java:526)
at java.lang.Integer.decode(Integer.java:919)
at com.salesforce.dataloader.security.EncryptionUtil.textToBytes(Encrypt
ionUtil.java:58)
at com.salesforce.dataloader.security.EncryptionUtil.decryptString(Encry
ptionUtil.java:194)
at com.salesforce.dataloader.config.Config.decryptProperty(Config.java:6
68)
... 5 more
My process-conf.xml Files:
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN"
"http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="accountMasterProcess"
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="accountMasterProcess"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="true"/>
<entry key="sfdc.debugMessagesFile"
value="C:\Datalodercli\accountInsertSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://login.salesforce.com"/>
<entry key="sfdc.username" value="mvrsreddy@gmail.com"/>
<entry key="sfdc.password" value="9016019f5e18b6c75f993da5924fd33bB0aszGmt639q7ut2j7UKT3ux"/>
<entry key="process.encryptionKeyFile"
value="C:\Datalodercli\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:\Datalodercli\account.sdl"/>
<entry key="dataAccess.name"
value="C:\Datalodercli\accountInsert.csv"/>
<entry key="process.outputSuccess"
value="C:\Datalodercli\accountInsert_success.csv"/>
<entry key="process.outputError"
value="C:\Datalodercli\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 in advance.
Here is an example,
C:\ProgramFiles\Dataloader\bin> encrypt -e abz
C:\ProgramFiles\Dataloader\bin> encrypt -v 5046500bce74f14d abz
"Decryption of encrypted value MATCHES the expected value"
This verify your encrypted password is correct.
All Answers
Hey Geetha,
What command are using to encrypt?
May be you can get some help from this link.
http://abztech.wordpress.com/2011/05/24/encrypting-salesforce-password/
Hi alibzafar ,
By this way i am encrypting password.
1. Open command prompt in ur system.
2. Change the directory to bin directory of ur datalaoder(Example:C:\ProgramFiles\Dataloader\bin).
3. In the command prompt type encrypt.bat -g test(Example:C:\ProgramFiles\Dataloader\bin>encrypt.bat -g test)
4. Hit enter then key will be generated copy the key and paste it in key.txt file(create .txt file and rename it to key.txt and paste the key).
5.type encrypt.bat -e kevin123456 and location of ur key.txt file(Example:C:\ProgramFiles\Dataloader\bin>encrypt.bat -e kevin123456 "C:\ProgramFiles\Dataloader\test\key.txt" ) .
6. Hit enter then one alpha numeric number will be genarated copy that and paste it in Process-conf.xml file.
Did you already worked on this part?
If so can u share Code snippet .
Instead of generating text file, you can directly use the encrypted password . To generate encrypted password use command
C:\ProgramFiles\Dataloader\bin> encrypt -e passwordSecurityToken
This will genrate the enrypted password, which you can directly use in your process-conf file. To verify your encrypted password run command
C:\ProgramFiles\Dataloader\bin> encrypt -v encryptedPassword passwordSecurityToken
Another thing is you are using '.bat' in your command, try using without it
Hope this helps
Thanks
Hi Ali,
I am getting this error
2012-08-29 12:18:20,453 ERROR [accountMasterProcess] config.Config decryptProper
ty (Config.java:669) - Error loading parameter: sfdc.password of type: java.lang
.String
HI Geetha,
Have you verified your encrypted password?
C:\ProgramFiles\Dataloader\bin> encrypt -e passwordSecurityToken .
and finally I am checking from command promt.
file location>process.bat "process.xml location" bean id
Same Error coming:
2012-08-29 17:46:50,812 ERROR [accountMasterProcess] client.PartnerClient loginI
nternal (PartnerClient.java:534) - Error while logging in to web service at: htt
p://www.salesforce.com//services/Soap/u/25.0, error was:
[LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
Can any one help on this issue..
You need to verify your credentials before running 'process' command
How to verify credentials before running 'process' command ?
Any Process please suggest me.
Here is an example,
C:\ProgramFiles\Dataloader\bin> encrypt -e abz
C:\ProgramFiles\Dataloader\bin> encrypt -v 5046500bce74f14d abz
"Decryption of encrypted value MATCHES the expected value"
This verify your encrypted password is correct.
C:\Program Files\salesforce.com\Data Loader\bin>encrypt -v 5046500bce74f14d abz
Decryption of encrypted value MATCHES the expected value
I got like this Ali .
After that :
C:\Program Files\salesforce.com\Data Loader\bin>process.bat "C:\Program Files\salesforce.com\Data Loader\Test" accountMasterProcess
But i am getting Error:
Error loading parameter: sfdc.password of type: java.lang.String
You solved my problem. Tank's!
Unsupported option: -v