Skip to main content
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?
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
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
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
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.
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
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.

Reply