Skip to main content
lauren_marsh
lauren_marsh
Contributor ⭐️⭐️
August 7, 2016
Question

Failed records: UNABLE_TO_LOCK_ROW

  • August 7, 2016
  • 6 replies
  • 163 views
I'm creating a CTA with multiple Actions but some of the records fail and the error message is: 
[UNABLE_TO_LOCK_ROW
: unable to obtain exclusive access to this record]. How do I prevent this so that all CTAs an be created?

    6 replies

    smorrisgainsightcom
    smorrisgainsightcom
    Helper ⭐️⭐️⭐️
    August 7, 2016
    Hi Lauren:

    What this error message typically means is that there is another process (SFDC trigger or batch job usually) that is updating the same records. If a Gainsight rule tries to update a record that is in the process of updating the same records. In your rule, what is the source object? I usually see this if the source is the account or opportunity.

    Thanks

    Scott
    smorrisgainsightcom
    smorrisgainsightcom
    Helper ⭐️⭐️⭐️
    August 7, 2016
    Hi Lauren:

    What this error message typically means is that there is another process (SFDC trigger or batch job usually) that is updating the same records. If a Gainsight rule tries to update a record that is in the process of updating the same records. In your rule, what is the source object? I usually see this if the source is the account or opportunity.

    Thanks

    Scott
    smorrisgainsightcom
    smorrisgainsightcom
    Helper ⭐️⭐️⭐️
    August 7, 2016
    Hi Lauren:

    What this error message typically means is that there is another process (SFDC trigger or batch job usually) that is updating the same records. If a Gainsight rule tries to update a record that is in the process of updating the same records. In your rule, what is the source object? I usually see this if the source is the account or opportunity.

    Thanks

    Scott
    lauren_marsh
    lauren_marshAuthor
    Contributor ⭐️⭐️
    August 7, 2016
    It's creating a CTA based on the "Table for CTA Rules" object.  This is loaded from our utilization data and doesn't touch any of the other SFDC objects that I can tell.
    lauren_marsh
    lauren_marshAuthor
    Contributor ⭐️⭐️
    October 3, 2016
    Is it possible that it's trying to make too many CTAs at a time?  How do you throttle the speed at which a rule runs?  I'm worried that each time I try to run the Rules to create the cta some will miss and it doesn't tell me which do so I've had to delete them all and rerun it.  Trying again now after have 1/3rd of the records being process fail due to this error.
    What are your thoughts?

    Thank you
    LM
    sundar
    sundar
    Expert ⭐️
    October 4, 2016
    Right now the rules run in a sequential order of schedule. So there is no possibility of two rules trying to create CTA at same time, but that will not rule out manual creation overlapping with rule run time. This should be rare and does not explain the above behaviour. Put thru a tix so that the support team can debug on that further.
    Terms & ConditionsAccessibility statement