community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Salesforce Output Too Many Queries

Highlighted
Meteoroid

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.

Bolide

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...

Thanks

 

Andy 

Labels