Hello I am facing following error in Boomi process when querying employee data from SalesForce. We have following SOQL query in Boomi. Appreciate if somebody can shed some light and explain how can I fix this issue. Thank you!
You just need to deselect the fields you are not going to use. It is decrease the size of query
Looking at your query, I can only think of three reasons you might see that:
1) You're passing some unexpected value in as the query parameter, causing the SOQL to be over 20k chars. (e.g. you're passing in the an entire document as the paramter vs just a salesforce id.
2) You have many fields on the Employee__c record, you've unchecked all of them in the operation (except Id and EC_ID__c remaining), but haven't saved the operation or deployed the new version of the operation.
3) The exception you're seeing is caused by another salesforce operation in your process and you're just looking at the wrong one.
If none of those are the cause, I'd recommend turning on trace connector logging. Check out the log to see the actual SOQL query sent to Salesforce.
Hi Ven Yar
This is actually a limit on salesforce. Salesforce Developers
May be you are sending more EC_ID__cin the IN clause.
Thank you all for your quick responses and suggestions!
From my further analysis I have found that though I receive MALFORMED_QUERY error at the end of the process execution, the real reason behind the issue is below:
Currently somehow sometimes during the end of the process SFTP file step is failing. This does not happen all the time. Since we have retry execution schedule is ON for the process, the process is executing one more time after the failure and causing error "MALFORMED_QUERY: SOQL statements can not be longer than 20000 characters".
Thanks for the info Ven.
Retrieving data ...