2 Replies Latest reply on Nov 30, 2017 4:45 AM by Rahul Kumar

    Salesforce sync issues

    Rahul Kumar

      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
        • Re: Salesforce sync issues
          Josh Hill

          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.