You need to sign in to do that
Don't have an account?
Alexander Tan
Need Help - Running Apex Data Loader Command Line Using Proxy
Hi all,
I am a new joiner and need help to configure my Apex Data Loader to run on Command Line (to be scheduled later) using my company proxy. I tested the Apex Data Loader with the interface, it worked fine. I can login, insert, update, etc. However, I cannot do the same when I run it on Command Line.
I did all steps required to produce encrypted password for the SFDC as well as for my NTLM password. This is my configuration:
<map> <entry key="dataAccess.name" value="C:\Output\Contacts_1_100.csv" /> <entry key="dataAccess.type" value="csvWrite" /> <entry key="process.initialLastRunDate" value="2012-09-25T00:00:00.000-0800"/> <entry key="process.operation" value="extract"/> <entry key="process.outputError" value="C:\Output\status\errorExtractContacts.csv"/> <entry key="process.outputSuccess" value="C:\Output\status\successExtractContacts.csv"/> <entry key="process.mappingFile" value="C:\Output\mapping\extractContacts.sdl"/> <entry key="process.encryptionKeyFile" value="C:\Data Loader\conf\process-key.xtf"/> <entry key="sfdc.proxyHost" value="proxy.alexander.local"/> <entry key="sfdc.proxyPort" value="8080"/> <entry key="sfdc.proxyNtlmDomain" value="alexander-local"/> <entry key="sfdc.proxyUsername" value="alexander"/> <entry key="sfdc.proxyPassword" value="klj24894221h34bv283"/> <entry key="sfdc.debugMessages" value="false"/> <entry key="sfdc.debugMessagesFile" value="C:\Output\logs\extractContacts.log"/> <entry key="sfdc.endpoint" value="https://login.salesforce.com/services/Soap/u/25.0"/> <entry key="sfdc.username" value="alexander@find.me"/> <entry key="sfdc.password" value="a386d9b1eafa6605926c21f0a27655ccf3bb18e9524b416c4f5cfc158869e416b04cc87d2795a2cd"/> <entry key="sfdc.timeoutSecs" value="540"/> <entry key="sfdc.loadBatchSize" value="100"/> <entry key="sfdc.entity" value="Contact"/> </map>
And this is the output I got:
2012-09-26 15:35:12,211 INFO [csvExportContacts] client.PartnerClient login (PartnerClient.java:478) - Beginning Partner Salesforce login .... 2012-09-26 15:35:12,211 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:123) - Salesforce login will use proxy host: proxy.alexander.local port: 8080 2012-09-26 15:35:12,211 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:129) - Salesforce login will use proxy user: alexander 2012-09-26 15:35:12,211 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:134) - Salesforce login will use proxy password from settings 2012-09-26 15:35:12,211 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:143) - Salesforce login will use proxy NTLM domain: alexander-local 2012-09-26 15:35:12,257 INFO [csvExportContacts] client.PartnerClient loginInternal (PartnerClient.java:519) - Salesforce login to https://login.salesforce.com/services/Soap/u/25.0/services/Soap/u/25.0 as user alexander@find.me 2012-09-26 15:35:13,054 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:13,054 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:13,773 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:13,773 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:14,601 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:15,273 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:15,289 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:15,289 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:17,461 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:123) - Salesforce login will use proxy host: proxy.alexander.local port: 8080 2012-09-26 15:35:17,461 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:129) - Salesforce login will use proxy user: alexander 2012-09-26 15:35:17,461 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:134) - Salesforce login will use proxy password from settings 2012-09-26 15:35:17,461 INFO [csvExportContacts] client.ClientBase getConnectorConfig (ClientBase.java:143) - Salesforce login will use proxy NTLM domain: alexander-local 2012-09-26 15:35:17,461 INFO [csvExportContacts] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: C:\Output\Contacts_1_100.csv of type: csvWrite 2012-09-26 15:35:17,461 INFO [csvExportContacts] process.ProcessRunner run (ProcessRunner.java:132) - Checking the data access object connection 2012-09-26 15:35:17,476 INFO [csvExportContacts] process.ProcessRunner run (ProcessRunner.java:137) - Setting field types 2012-09-26 15:35:17,554 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:17,554 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:18,273 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:18,273 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:19,054 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:19,757 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:19,757 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:19,757 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:20,570 INFO [csvExportContacts] process.ProcessRunner run (ProcessRunner.java:141) - Setting object reference types 2012-09-26 15:35:20,664 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:20,664 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:21,320 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:21,320 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:22,148 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:22,867 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:22,867 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:22,867 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:23,695 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:23,695 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:24,382 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:24,382 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:25,257 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:25,945 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:25,976 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:25,992 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:26,648 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:26,648 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:27,351 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:27,351 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:28,117 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:28,789 ERROR [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:103) - NTLM authentication error: Unexpected state: MSG_TYPE3_GENERATED 2012-09-26 15:35:28,789 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - NEGOTIATE authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:28,789 WARN [csvExportContacts] protocol.RequestAuthenticationBase process (RequestAuthenticationBase.java:88) - KERBEROS authentication error: Invalid name provided (Mechanism level: Could not load configuration file C:\WINDOWS\krb5.ini (The system cannot find the file specified)) 2012-09-26 15:35:29,335 INFO [csvExportContacts] process.ProcessRunner run (ProcessRunner.java:145) - Creating Map 2012-09-26 15:35:29,335 INFO [csvExportContacts] action.OperationInfo instantiateAction (OperationInfo.java:95) - Instantiating action for operation: extract 2012-09-26 15:35:29,351 INFO [csvExportContacts] controller.Controller executeAction (Controller.java:119) - executing operation: extract 2012-09-26 15:35:29,351 INFO [csvExportContacts] action.AbstractAction execute (AbstractAction.java:115) - Loading: extract 2012-09-26 15:35:29,351 ERROR [csvExportContacts] action.AbstractAction handleException (AbstractAction.java:199) - Exception occured during loading java.lang.IllegalArgumentException: Cannot parse empty string at com.salesforce.dataloader.mapping.SOQLInfo.getTrimmed(SOQLInfo.java:162) at com.salesforce.dataloader.mapping.SOQLInfo.<init>(SOQLInfo.java:122) at com.salesforce.dataloader.mapping.SOQLMapper.initSoqlMapping(SOQLMapper.java:123) at com.salesforce.dataloader.action.AbstractExtractAction.getDaoColumns(AbstractExtractAction.java:88) at com.salesforce.dataloader.action.AbstractExtractAction.initOperation(AbstractExtractAction.java:139) at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:117) at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:120) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:149) at com.salesforce.dataloader.process.ProcessRunner.run(ProcessRunner.java:100) at com.salesforce.dataloader.process.ProcessRunner.main(ProcessRunner.java:253) 2012-09-26 15:35:29,351 ERROR [csvExportContacts] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - Cannot parse empty string
I appreciate any help. Thank you.
Did you find a resolution to this problem ??
I am currently experiancing the same issue with trying to upgrade from 14 to 34
Thanks in advance
Martin