• Martin Johnson 9
  • NEWBIE
  • 0 Points
  • Member since 2016

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies

Hi,

 

I want to query the records which are modified with last 15 mins.

Please let me know the SOQL query for the same. I tried

 

select name from Opportunity

     where SystemModstamp >  Datetime.now().addMinutes(-15)

 

it did not work.

 

I want to run the query using force.com explorer/workbench

Please let me know if there is any other method to get this.

 

Thanks,

Babu.

  • April 26, 2013
  • Like
  • 0

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.