I've been having a big issue getting the Apex data loader to run via the command line. I'm using v14.
I've encrypted the password correctly:
Code:
encrypt -e passwordSecurityToken
The results I store in the conf file, which looks like this:
Code:
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="csvLenderExtractProcess"
class="com.salesforce.lexiloader.process.ProcessRunner"
singleton="false">
<description>csvLenderExtract job gets account info from salesforce and saves info into a CSV file."</description>
<property name="name" value="csvLenderExtract"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile" value="c:\Program Files\salesforce.com\Apex Data Loader 14.0\sfdcSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
<entry key="sfdc.username" value="user@customer.com"/>
<!-- password specified below is invalid, please generate one using the encrypt.bat utility -->
<entry key="sfdc.password" value="a58afc521f2f0f6a1f26adab1e6dbc740d705a086f9301310754ec6f9753d7d0" />
<entry key="process.encryptionKeyFile" value="c:\Program Files\salesforce.com\Apex Data Loader 14.0\conf\password.key" />
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="sfdc.extractionRequestSize" value="500"/>
<entry key="sfdc.extractionSOQL" value="Select Id, Name FROM Account"/>
<entry key="process.operation" value="extract"/>
<entry key="process.mappingFile" value="C:\Program Files\salesforce.com\Apex Data Loader 14.0\conf\accountExtractMap.sdl"/>
<entry key="dataAccess.type" value="csvWrite"/>
<entry key="dataAccess.name" value="C:\Program Files\salesforce.com\Apex Data Loader 14.0\data\extractLender.csv"/>
</map>
</property>
</bean>
</beans>
If I leave the sfdc.password entry in the xml it complains it's an invalid string. If I comment it out to just use the password file, I get:
Code:
1232 [csvLenderExtract] ERROR com.salesforce.lexiloader.process.ProcessRunner -
Invalid username, password, security token; or user locked out.
Exception in thread "main" java.lang.RuntimeException: [LoginFault [ApiFault ex
ceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:148)
at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.ja
va:228)
Caused by: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:563)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:475)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:187)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:166)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:11
2)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:92)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:864)
at com.salesforce.lexiloader.client.PartnerClient.connectImpl(PartnerCli
ent.java:169)
at com.salesforce.lexiloader.client.PartnerClient.connect(PartnerClient.
java:148)
at com.salesforce.lexiloader.controller.Controller.login(Controller.java
:174)
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:115)
... 1 more
I've been having a big issue getting the Apex data loader to run via the command line. I'm using v14.
I've encrypted the password correctly:
Code:
encrypt -e passwordSecurityToken
The results I store in the conf file, which looks like this:
Code:
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="csvLenderExtractProcess"
class="com.salesforce.lexiloader.process.ProcessRunner"
singleton="false">
<description>csvLenderExtract job gets account info from salesforce and saves info into a CSV file."</description>
<property name="name" value="csvLenderExtract"/>
<property name="configOverrideMap">
<map>
<entry key="sfdc.debugMessages" value="false"/>
<entry key="sfdc.debugMessagesFile" value="c:\Program Files\salesforce.com\Apex Data Loader 14.0\sfdcSoapTrace.log"/>
<entry key="sfdc.endpoint" value="https://www.salesforce.com"/>
<entry key="sfdc.username" value="user@customer.com"/>
<!-- password specified below is invalid, please generate one using the encrypt.bat utility -->
<entry key="sfdc.password" value="a58afc521f2f0f6a1f26adab1e6dbc740d705a086f9301310754ec6f9753d7d0" />
<entry key="process.encryptionKeyFile" value="c:\Program Files\salesforce.com\Apex Data Loader 14.0\conf\password.key" />
<entry key="sfdc.timeoutSecs" value="600"/>
<entry key="sfdc.loadBatchSize" value="200"/>
<entry key="sfdc.entity" value="Account"/>
<entry key="sfdc.extractionRequestSize" value="500"/>
<entry key="sfdc.extractionSOQL" value="Select Id, Name FROM Account"/>
<entry key="process.operation" value="extract"/>
<entry key="process.mappingFile" value="C:\Program Files\salesforce.com\Apex Data Loader 14.0\conf\accountExtractMap.sdl"/>
<entry key="dataAccess.type" value="csvWrite"/>
<entry key="dataAccess.name" value="C:\Program Files\salesforce.com\Apex Data Loader 14.0\data\extractLender.csv"/>
</map>
</property>
</bean>
</beans>
If I leave the sfdc.password entry in the xml it complains it's an invalid string. If I comment it out to just use the password file, I get:
Code:
1232 [csvLenderExtract] ERROR com.salesforce.lexiloader.process.ProcessRunner -
Invalid username, password, security token; or user locked out.
Exception in thread "main" java.lang.RuntimeException: [LoginFault [ApiFault ex
ceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:148)
at com.salesforce.lexiloader.process.ProcessRunner.main(ProcessRunner.ja
va:228)
Caused by: [LoginFault [ApiFault exceptionCode='INVALID_LOGIN'
exceptionMessage='Invalid username, password, security token; or user locked ou
t.'
]
]
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
orAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
onstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at java.lang.Class.newInstance0(Class.java:350)
at java.lang.Class.newInstance(Class.java:303)
at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:563)
at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:475)
at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.jav
a:187)
at com.sforce.ws.transport.SoapConnection.createException(SoapConnection
.java:166)
at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:11
2)
at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:92)
at com.sforce.soap.partner.PartnerConnection.login(PartnerConnection.jav
a:864)
at com.salesforce.lexiloader.client.PartnerClient.connectImpl(PartnerCli
ent.java:169)
at com.salesforce.lexiloader.client.PartnerClient.connect(PartnerClient.
java:148)
at com.salesforce.lexiloader.controller.Controller.login(Controller.java
:174)
at com.salesforce.lexiloader.process.ProcessRunner.run(ProcessRunner.jav
a:115)
... 1 more
