Skip to main content
Nina_Valtcheva5
Nina_Valtcheva5
Level 4
August 27, 2015
Question

SFDC Sync Error: CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: trgFindDunsAccount: System.LimitException: Too many query rows: 50001

  • August 27, 2015
  • 2 replies
  • 4107 views

Does anybody know what this error means?

CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: trgFindDunsAccount: System.LimitException: Too many query rows: 50001

I've been seeing this error a lot for several weeks now and Marketo Support just told me to reach out to our SFDC Admin / SFDC support. Our SFDC Admin told me it has to do with whether or not these records have a website, but I'm not confident that's the case. All the leads affected are still syncing to SFDC despite this error but I just want to know what it means and how to stop it from happening.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Kenny_Elkington
Adobe Employee
Kenny_ElkingtonAdobe Employee
Adobe Employee
August 27, 2015

Hi Nina,

The cause of this error is that code firing during an insert event in your SFDC instance is making a SOQL query returning more than 50,000 records, causing the APEX code to throw an exception and the insert/update to fail.  While whether the code fires or not may have to do with whether a 'website' field is present on the record being inserted/updated, the exception is still the result of SFDC-side code, and there's nothing in the absrtact that can be done on the Marketo side to prevent it.  Your admin may be able to provide instructions or conditions that you can implement in Marketo, but it's usually going be better practice to fix the problem at the source, such as by switching to using Batch Apex​ in the offending code.

J
JeffSm6
Level 6
August 27, 2015

Hi Nina,

This is a SFDC issue, not a Marketo issue. Here is a resource from their community that will help. You may have to go back and perform a single lead action to sync this one to your SFDC campaign. It's happened to me before...not often, but every once in a while.

CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY - Salesforce Developer Community

Terms & ConditionsAccessibility statement

Loading footer...