search

developerforce / Force.com-JavaScript-REST-Toolkit

ForceTK - a minimal Force.com REST API for JavaScript apps
BSD 3-Clause "New" or "Revised" License
315 stars 175 forks source link

Uploading multiple content files to salesforce using ForceTK : UNABLE_TO_LOCK_ROW error #68

Open sahilbatraa opened 9 years ago

sahilbatraa commented 9 years ago

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.

metadaddy commented 9 years ago

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.