Salesforce sync issues

Rahul_Kumar2
Level 2

Salesforce sync issues

Hello Everyone,

i have facing sf sync issues over last one month causes a no of leads did not sync with sf under various cases .

would someone have better understanding about those cases and how to control them , either from marketo side or sf side.

Kindly see attach cases below

Help will be really appreciated.

SF Sync Cases
UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: rh2.PS_Contact: execution of AfterUpdate caused by: System.DmlException: Upsert failed. First exception on row 0 with id a3Ko0000000kNcHEAU; first error: UNABLE_TO_LOCK_ROW, unable to obtain exclusive access to this record or 1 records: a3Ko0000000kNcHEAU: [] (rh2)
FIELD_CUSTOM_VALIDATION_EXCEPTION: CC Contact Status can not be moved back in Funnel
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: rh2.PS_Contact: System.LimitException: rh2:Too many query rows: 50001
FIELD_CUSTOM_VALIDATION_EXCEPTION: Rollup Helper cannot update parent record 00100000006kVRUAA2: UNABLE_TO_LOCK_ROW: unable to obtain exclusive access to this record
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: ContactTrg: execution of AfterUpdate caused by: System.DmlException: Update failed. First exception on row 0 with id a1t1N000006N2VrQAK; first error: TRANSFER_REQUIRES_READ, The new owner must have read permission: [] (DSE)
CANNOT_INSERT_UPDATE_ACTIVATE_ENTITY: ContactTrg: System.LimitException: Apex CPU time limit exceeded
Tags (1)
5 REPLIES 5
Josh_Hill13
Level 10 - Champion Alumni

Re: Salesforce sync issues

These are all SFDC errors that block Marketo from fully syncing the data. In many cases, Marketo will try later and the data will sync. But you should investigate the Notifications and list of leads so you can fix the problems to reduce data issues.

  • Lock Row - someone else is editing this record. Marketo will resolve normally.
  • Field Validation issues - that field has an Validation code of some type and Marketo is sending data that isn't conforming. Find out what it is and fix it on either end.
  • Apex CPU Limit - something caused SFDC to use up Apex code cycles (too many Apex triggers) and it can't process the incoming data. This can happen for many reasons, but often because you sent SFDC too many records and SFDC has too many triggers to process.
Rahul_Kumar2
Level 2

Re: Salesforce sync issues

Thanks Josh for wonderful guidelines.

Ed_Dunn
Level 1

Re: Salesforce sync issues

is there a way for Marketo support to change MKTO to SFDC sync to use 100 per API call rather than 200 records per API call? This would get around the Apex CPU time limit exceeded and System.LimitException: errors

SanfordWhiteman
Level 10 - Community Moderator

Re: Salesforce sync issues

Ed, it'd make make sense for you to open a new thread, otherwise there are multiple open questions on threads from years ago (in some cases the thread owners don't even have profiles anymore).

Ed_Dunn
Level 1

Re: Salesforce sync issues

okay thanks Sanford.  I just posted it as a new questions. Thanks