topic Re: ArcSDE FeatureClass update with edit session problems in Python Questions

ArcSDE FeatureClass update with edit session problems

JoeHewitt — Wed, 06 Nov 2013 01:23:09 GMT

Hello,

I am trying to run an update on an ArcSDE FeatureClass using ArcPy.
With the goal of my code starting an edit session, making a change to my FC and then saving the changes, so this change will show up in the (date_Changed) attribute like ArcSDE is supposed to. This is my code below: (Just an example of trying to use the insertcursor, normally I would try to deletefeatures then append, but I figured start small first)


import arcpy
from arcpy import env
arcpy.MakeFeatureLayer_management(r'Database Connections\GISAdmin@SBMPERDBS003.sde\GISAdmin.Leonora_Drilling\GISAdmin.LEO_DH_Collars','LeoDHCollars')
arcpy.MakeXYEventLayer_management(r'\\SBMPERTST001\Applications\GIS\DataShed Exploration_LEO Export\Arc_DHCollars.csv',"NAT_East","NAT_North","LeoDHCollarsNEW")
arcpy.MakeFeatureLayer_management("LeoDHCollarsNEW",'LeoDHCollarslyr')
arcpy.ChangeVersion_management('LeoDHCollars','Transactional','GISADMIN.DataUpdates','')
workspace=r'Database Connections\GISAdmin@SBMPERDBS003.sde'
edit= arcpy.da.Editor(r'Database Connections\GISAdmin@SBMPERDBS003.sde')
edit.startEditing(True,True)
edit.startOperation()
with arcpy.da.InsertCursor("LeoDHCollars", ('SHAPE@', 'Hole_Type')) as icur:
    icur.insertRow([(7642471.100, 686465.725), 'New School'])
edit.stopOperation()
edit.stopEditing(True)
arcpy.DisconnectUser(r'Database Connections\SDE@SBMPERDBS003.sde', "ALL")
arcpy.ReconcileVersions_management(workspace,"ALL_VERSIONS","SDE.GIS_Default","GISADMIN.DataUpdates","LOCK_ACQUIRED","NO_ABORT","BY_OBJECT","FAVOR_TARGET_VERSION","POST","KEEP_VERSION")

The problem I am getting is RunTime Error: Workspace already in transaction mode.

Any thoughts of why?

Re: ArcSDE FeatureClass update with edit session problems

MattSayler — Thu, 07 Nov 2013 22:05:42 GMT

Is your data versioned?

Re: ArcSDE FeatureClass update with edit session problems

MattSayler — Thu, 07 Nov 2013 22:26:57 GMT

Try setting the workspace first thing. Also should it be "env.workspace = r'Database Connections\GISAdmin@SBMPERDBS003.sde'"? And on line 15 it switches from 'Database Connections\GISAdmin@SBMPERDBS003.sde' to 'Database Connections\SDE@SBMPERDBS003.sde'

Not super confident any of those are causing the error, but easy enough to try.

Re: ArcSDE FeatureClass update with edit session problems

PaulSchneider — Sun, 12 Dec 2021 05:12:15 GMT

I believe you are getting this error because the dataset is not registered as versioned with the database?

Try changing to:

...
edit.startEditing(True,False)
...

or register the dataset as versioned before opening the edit session

Re: ArcSDE FeatureClass update with edit session problems

WilliamCraft — Thu, 12 Dec 2013 13:46:14 GMT

And on line 15 it switches from 'Database Connections\GISAdmin@SBMPERDBS003.sde' to 'Database Connections\SDE@SBMPERDBS003.sde'

The "Database Connections" part of the path that you are seeing is normal behavior. This is Esri's way to abbreviating the default location where SDE connection files are stored on the machine when creating them under Database Connections in ArcCatalog or ArcMap. So, "Database Connections\..." really refers to the user profile directory. For example in Windows 7 or Windows Server 2008 R2,

C:\Users\userID\AppData\Roaming\ESRI\ArcCatalog\SDE@SBMPERDBS003.sde

...would be represented by Esri software as...

Database Connections\SDE@SBMPERDBS003.sde

Re: ArcSDE FeatureClass update with edit session problems

MathewCoyle — Tue, 21 Jan 2014 20:32:16 GMT

My solution was to create a version then create a database connection file and reference the newly created version as the default. I could then drop the change version operation as the edit opens with the specified version from the connection file.

Re: ArcSDE FeatureClass update with edit session problems

MattSayler — Fri, 24 Jan 2014 14:50:07 GMT

The "Database Connections" part of the path that you are seeing is normal behavior. This is Esri's way to abbreviating the default location where SDE connection files are stored on the machine when creating them under Database Connections in ArcCatalog or ArcMap. So, "Database Connections\..." really refers to the user profile directory. For example in Windows 7 or Windows Server 2008 R2,

C:\Users\userID\AppData\Roaming\ESRI\ArcCatalog\SDE@SBMPERDBS003.sde

...would be represented by Esri software as...

Database Connections\SDE@SBMPERDBS003.sde

I was refering to the switch in user from GISAdmin to SDE.

Re: ArcSDE FeatureClass update with edit session problems

pfoppe — Mon, 11 Jun 2018 19:44:01 GMT

Esri has confirmed this situation and marked it as a bug:

BUG-000114598:
-----------------------------
RuntimeError "workspace already in transaction mode" occurs when using da.UpdateCursor on TableView after changing the version.