Error Message: MALFORMED_QUERY: unexpected token: True
Action:
While using the Salesforce Source, the following error message was returned.
Error Message:
'MALFORMED_QUERY: unexpected token: True'
Solution:
MALFORMED_QUERY is a dead giveaway that the query sent to Salesforce was not in proper syntax. This is not a COZYROC error message. You will need to use Fiddler Tracing app to do trace of what is sent to Salesforce to cause the error being returned or contact Salesforce to do server side tracing. Search the web for MALFORMED_QUERY and you will see the message is Salesforce specific.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Error Message: Invalid Server Host (Salesforce Connection)
Action: When using the Salesforce Connection I am getting the error message below: Error Message: "Invalid Server Host" Solution: Salesforce has sent out notices to their customers that some Salesforce Platform API legacy versions will be deprecated ...Error Message: The underlying connection was closed: An unexpected error occurred on a send. (System.Web.Services)
Action: My Salesforce connections have suddenly started giving errors. Attached is the error message I am recieving on testing the connections . Please note the connections were working fine until yesterday and I am getting same issue for both ...Error Message: An existing connection was forcibly closed by the remote host
Action When making a request to a service connection, the following error message was returned. Error Message Error Message: An existing connection was forcibly closed by the remote host Solution The error message can be somewhat generic across ...Error Message: unable to connect to remote server
Action: When I run my SSIS+ package for transferring data from Salesforce Source to Salesforce Destination I get the following error message: Error Message: Unable to connect to remote server Solution: The reason for ...Error Message: Delegate token node not found.
Action: When using the Dynamics CRM source from the CozyRoc CRM connection manager, the following error message is received. The connection tests successfully and viewing data through the data flow task is possible, but it failed with the error ...