Skip to content
This repository has been archived by the owner on Jan 10, 2024. It is now read-only.

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

Open
sahilbatraa opened this issue Jun 26, 2015 · 1 comment

Comments

@sahilbatraa
Copy link

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
Copy link
Contributor

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.

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants