This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
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...