Strange locking error when using REST api through ArcServer

05-12-2014 06:59 AM
Occasional Contributor
I keep getting this message:

 "error": {
  "code": 400,
  "message": "Unable to complete operation.",
  "details": [
   "The current version does not support editing (base, consistent, or closed) [An open transaction was detected. All user transactions must be closed prior to StartEditing.]"

when i try to create feature via the REST endpoint on a Feature Service using the addFeatures method.
It appears to be related to some kind of ArcSDE locking.
This is a 10.1 arc server install using Oracle
I can get the edits to work once in a while, and some times for an hour or two on end. but then it breaks again.
i confirm in catalog that there are no locks on the sde connection used in the mxd for the feature service.

I thought edits through the REST api would handle the opening and closing of the edit session.
I never explicitly call "StartEditing" i just craft a string request in C# to send to the rest endpoint.

What is going on here?
Tags (2)
0 Kudos
2 Replies
New Contributor III
I had some locking issues with MS SQL.  Try setting the service pooling

"Maximum number of instances per machine:" to 1.

If that fixes your problem the issue might be related.  There was a patch available.
New Contributor III

Hello, did you find a fix for this issue?

0 Kudos