function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Raghu Cheruvu 1Raghu Cheruvu 1 

ApiFault exceptionCode='MALFORMED_QUERY' error while running extract job using command line interface

Hi, 

I am facing the below error message while extracting data using data loader CLI:

ApiFault  exceptionCode='MALFORMED_QUERY'  
Bind variables only allowed in Apex code

Full SOQL being used:- 

SOQL="Select Id, IsDeleted, MasterRecordId, Name, LastName, FirstName, Salutation, RecordTypeId, IsPersonAccount, PersonTitle, PersonBirthdate, MDVN_MDV__c, Credentials_vod__c, Specialty_1_vod__c, Specialty_2_vod__c, Gender_vod__c, PDRP_Opt_Out_vod__c, PDRP_Opt_Out_Date_vod__c, Middle_vod__c, Suffix_vod__c, NPI_vod__c, ME__c, Account_Type__c, WK_MDV__c,mCRPC_Treatment_MDVN__c,Phone, Fax, PersonEmail, EDSE_Person_Has_Opted_In__c, Target__c,Pending_Validation_MDV__c,POA_Target_MDV__c,Role_MDVN__c FROM Account where LastModifiedDate > "

Below is the entire error message:- 

2015-01-31 11:06:27,474 INFO  [main] controller.Controller initLog (Controller.java:404) - The log has been initialized
2015-01-31 11:07:18,227 INFO  [main] controller.Controller initConfig (Controller.java:365) - The controller config has been initialized
2015-01-31 11:07:18,234 INFO  [main] process.ProcessRunner run (ProcessRunner.java:116) - Initializing process engine
2015-01-31 11:07:18,236 INFO  [main] process.ProcessRunner run (ProcessRunner.java:119) - Loading parameters
2015-01-31 11:07:18,238 INFO  [main] config.LastRun load (LastRun.java:96) - Last run info will be saved in file: C:\apexdataloader\conf\null_lastRun.properties
2015-01-31 11:07:18,372 INFO  [main] process.ProcessRunner run (ProcessRunner.java:127) - Logging in to: https://login.salesforce.com
2015-01-31 11:07:18,439 INFO  [main] client.PartnerClient login (PartnerClient.java:478) - Beginning Partner Salesforce login ....
2015-01-31 11:07:18,539 INFO  [main] client.PartnerClient loginInternal (PartnerClient.java:519) - Salesforce login to https://login.salesforce.com/services/Soap/u/24.0 as user data@medivation.com
2015-01-31 11:07:20,146 INFO  [main] dao.DataAccessObjectFactory getDaoInstance (DataAccessObjectFactory.java:51) - Instantiating data access object: C:\apexdataloader\temp\med_inq_201501311102.csv of type: csvWrite
2015-01-31 11:07:20,157 INFO  [main] process.ProcessRunner run (ProcessRunner.java:132) - Checking the data access object connection
2015-01-31 11:07:20,192 INFO  [main] process.ProcessRunner run (ProcessRunner.java:137) - Setting field types
2015-01-31 11:07:20,820 INFO  [main] process.ProcessRunner run (ProcessRunner.java:141) - Setting object reference types
2015-01-31 11:07:22,023 INFO  [main] process.ProcessRunner run (ProcessRunner.java:145) - Creating Map
2015-01-31 11:07:22,094 INFO  [main] action.OperationInfo instantiateAction (OperationInfo.java:95) - Instantiating action for operation: extract
2015-01-31 11:07:22,129 INFO  [main] controller.Controller executeAction (Controller.java:123) - executing operation: extract
2015-01-31 11:07:22,129 INFO  [main] action.AbstractAction execute (AbstractAction.java:115) - Loading: extract
2015-01-31 11:07:23,742 ERROR [main] client.PartnerClient runOperation (PartnerClient.java:332) - Error while calling web service operation: query, error was: 
[MalformedQueryFault [ApiQueryFault [ApiFault  exceptionCode='MALFORMED_QUERY'
 exceptionMessage='
in('Yes') and LastModifiedDate >Sqlcmd:
                               ^
ERROR at Row:1:Column:817
Bind variables only allowed in Apex code'
]
 row='1'
 column='817'
]
]

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
    at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
    at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:229)
    at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:203)
    at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:149)
    at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
    at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1334)
    at com.salesforce.dataloader.client.PartnerClient$5.run(PartnerClient.java:124)
    at com.salesforce.dataloader.client.PartnerClient$5.run(PartnerClient.java:116)
    at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:328)
    at com.salesforce.dataloader.client.PartnerClient.query(PartnerClient.java:392)
    at com.salesforce.dataloader.action.visitor.PartnerQueryVisitor.getQueryResult(PartnerQueryVisitor.java:65)
    at com.salesforce.dataloader.action.visitor.PartnerQueryVisitor.executeQuery(PartnerQueryVisitor.java:60)
    at com.salesforce.dataloader.action.visitor.AbstractQueryVisitor.visit(AbstractQueryVisitor.java:70)
    at com.salesforce.dataloader.action.AbstractExtractAction.visit(AbstractExtractAction.java:57)
    at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:125)
    at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:124)
    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)
2015-01-31 11:07:23,751 ERROR [main] action.AbstractAction handleException (AbstractAction.java:200) - Exception occured during loading
com.salesforce.dataloader.exception.ExtractException: 
in('Yes') and LastModifiedDate >Sqlcmd:
                               ^
ERROR at Row:1:Column:817
Bind variables only allowed in Apex code
    at com.salesforce.dataloader.action.visitor.AbstractQueryVisitor.visit(AbstractQueryVisitor.java:80)
    at com.salesforce.dataloader.action.AbstractExtractAction.visit(AbstractExtractAction.java:57)
    at com.salesforce.dataloader.action.AbstractAction.execute(AbstractAction.java:125)
    at com.salesforce.dataloader.controller.Controller.executeAction(Controller.java:124)
    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)
Caused by: [MalformedQueryFault [ApiQueryFault [ApiFault  exceptionCode='MALFORMED_QUERY'
 exceptionMessage='
in('Yes') and LastModifiedDate >Sqlcmd:
                               ^
ERROR at Row:1:Column:817
Bind variables only allowed in Apex code'
]
 row='1'
 column='817'
]
]

    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at java.lang.Class.newInstance0(Unknown Source)
    at java.lang.Class.newInstance(Unknown Source)
    at com.sforce.ws.bind.TypeMapper.readSingle(TypeMapper.java:627)
    at com.sforce.ws.bind.TypeMapper.readObject(TypeMapper.java:504)
    at com.sforce.ws.transport.SoapConnection.parseDetail(SoapConnection.java:229)
    at com.sforce.ws.transport.SoapConnection.createException(SoapConnection.java:203)
    at com.sforce.ws.transport.SoapConnection.receive(SoapConnection.java:149)
    at com.sforce.ws.transport.SoapConnection.send(SoapConnection.java:98)
    at com.sforce.soap.partner.PartnerConnection.query(PartnerConnection.java:1334)
    at com.salesforce.dataloader.client.PartnerClient$5.run(PartnerClient.java:124)
    at com.salesforce.dataloader.client.PartnerClient$5.run(PartnerClient.java:116)
    at com.salesforce.dataloader.client.PartnerClient.runOperation(PartnerClient.java:328)
    at com.salesforce.dataloader.client.PartnerClient.query(PartnerClient.java:392)
    at com.salesforce.dataloader.action.visitor.PartnerQueryVisitor.getQueryResult(PartnerQueryVisitor.java:65)
    at com.salesforce.dataloader.action.visitor.PartnerQueryVisitor.executeQuery(PartnerQueryVisitor.java:60)
    at com.salesforce.dataloader.action.visitor.AbstractQueryVisitor.visit(AbstractQueryVisitor.java:70)
    ... 6 more
2015-01-31 11:07:23,755 ERROR [main] progress.NihilistProgressAdapter doneError (NihilistProgressAdapter.java:58) - 
in('Yes') and LastModifiedDate >Sqlcmd:
                               ^
ERROR at Row:1:Column:817
Bind variables only allowed in Apex code

 
Paul S.Paul S.
You've provided no value to compare to in your where clause.  My guess is that's the issue.