Unable To Lock Row Error - Is this an example of MKTO fixing it? | Community
Skip to main content
M
mzzee
Level 4
October 15, 2019
Question

Unable To Lock Row Error - Is this an example of MKTO fixing it?

  • October 15, 2019
  • 2 replies
  • 7332 views

We are running across some of "Unable to Lock Row".


Here's an example in our system:

The activity on the bottom is where the error occurs.

The two proceeding events, which take place over an hour later, are described as "Run Action Change Status in SFDC Campaign". Are these two run actions an example of Marketo going back and updating the record after it has failed?

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

2 replies

Jay_Jiang
Jay_Jiang
Level 10
October 16, 2019

If your marketo program is synced with a Salesforce campaign, just change the status in the marketo program and the updated status will sync over to the salesforce campaign. Don't try to change the status in the SFDC campaign.

M
mzzeeAuthor
Level 4
October 21, 2019

We don't sync our MKTO programs to SFDC Campaigns, we use the "change status in SFDC campaign" flow step.

Usually when we "change status in SFDC campaign", typically 90-95% of records will go through fine. It's a few of them that will return a "Unable to Lock Row" error, and then we just have to run another batch campaign and it typically solves the issue.

My questions are 

1) why do a few records seem to trigger an "unable to lock row" error?

2) is there a report or a way to be notified when this happens? because if not, we are potentially missing out on attribution and program memberships if we have a few records every so often not being synced up correctly

Jay_Jiang
Jay_Jiang
Level 10
October 21, 2019

Is there a reason why you don't sync Marketo Programs to Salesforce Campaigns?

The error is generated on the Salesforce side - see https://help.salesforce.com/articleView?type=1&mode=1&id=000338933 and Unable to lock row - Salesforce Developer Community 

If you're running a batch campaign to with the flow step update SFDC campaign member status, you're essentially firing single API requests at Salesforce, which could cause that error to happen in Salesforce.

We sync every marketo program to a salesforce campaign and let member statuses sync over during the periodic sync cycles and haven't ever come across the issue

    M
    mzzeeAuthor
    Level 4
    February 21, 2020

    Is there a report that can be run to catch records who are being hit with the "LOCK ERROR" notification?

    Terms & ConditionsAccessibility statement

    Loading footer...