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?
Failed records: UNABLE_TO_LOCK_ROW
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
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
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
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
What are your thoughts?
Thank you
LM
Userlevel 5
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
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.