Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Salesforce Output Too Many Queries


I'm trying to use the Salesforce Output tool to do an update of two fields to a table. It's about 12,000 fields in total. It's giving me the following error:


Error: Salesforce Output (13): Record-level error from Salesforce API: "CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY:trgPolicyBeforeInsert: System.LimitException: Too many SOQL queries: 101:--"


I know this is because I'm trying to update too many records in one go. I've attempted to alter the number of batches in the underlying tool (SalesforceOutput.yxmc) to no avail. Can anyone offer any help on how to resolve this, please?

Thanks in advance.


Hi @plundgren 


Did you ever resolve this? I've previously just batched the update (by writing a simple batch macro with the SFDC tool in it, rather than edit the yxmc like you tried), and this has worked for me in the past, though I'm conscious the tool has been updated since then.


Let me know if it's not still resolved and you want an example...