Force.com-JavaScript-REST-Toolkit icon indicating copy to clipboard operation
Force.com-JavaScript-REST-Toolkit copied to clipboard

Uploading multiple content files to salesforce using ForceTK : UNABLE_TO_LOCK_ROW error

Open sahilbatraa opened this issue 10 years ago • 1 comments
trafficstars

We have a code in method to which we are passing index and uploading a file to salesforce content one by one , once the response is received i.e ID is received , call is made again so same method with index change. This process works fine for many instance however as there are large number of users , we are sometimes seeing error and instead of getting ID in response we are getting error :

0: {message: "unable to obtain exclusive access to this record", errorCode: "UNABLE_TO_LOCK_ROW",…}

  1. errorCode: "UNABLE_TO_LOCK_ROW"
  2. fields: []
  3. message: "unable to obtain exclusive access to this record"

We are getting this error if files are uploaded for same session. It is like session issue ? or there is some issue as we are uploading all files one by one and still there is error as unable to obtain exclusive access to this record.

sahilbatraa avatar Jun 26 '15 07:06 sahilbatraa

This will occur when another user has the record locked for modification. Since you can't do 'SELECT ... FOR UPDATE' via the REST API, I think the best you can do here is to catch the error and retry the request.

metadaddy avatar Jun 26 '15 23:06 metadaddy