[GIS] ArcPy.da.UpdateCursor error The requested operation is invalid on a closed state

arcpysql server

I am getting an error when trying to use the arcpy.da.UpdateCursor().
The error I am receiving is as followed

The requested operation is invalid on a closed state

I am in the python windows and trying to work with the current document

upsql = "OBJECTID = 3456"
with arcpy.da.UpdateCursor("GravityMain",["FromManHole"],upsql) as upcurs:
     for updat in upcurs:
         if updat:
             updat[0] = '222'
             upcurs.updateRow(updat)
del upcurs

How can I use the UpdateCursor with the current document mxd = arcpy.mapping.MapDocument("CURRENT")

I looked at arcpy.da.Editor but it wants the full path to the database.

Also, I am using a MSSQL database.

If I input the following I still get the error

fc = "C:\Users\name\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\Sewer.sde"
fcc = "C:\Users\name\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\Sewer.sde\EC_Sewer.DBO.Sewer_Network\EC_Sewer.DBO.ssGravityMain"
workspace = os.path.dirname(fc)
edit = arcpy.da.Editor(workspace)
edit.startEditing(False, True)
edit.startOperation()
upsql = "OBJECTID = 345"
with arcpy.da.UpdateCursor(fcc,["FromManHole"],upsql) as upcurs:
   for updat in upcurs:
      if updat:
            updat[0] = '222'
            upcurs.updateRow(updat)
edit.stopOperation()  
edit.stopEditing(True)          
del upcurs

Best Answer

Here is my complete solution. I needed to use arcpy.da.editor and I needed to add the dataset along with the sde path in order to access the layers from the current working session/ document. This works great but I still need to do a few things but it is working. Also, make sure you are not in edit mode when using arcpy.da.Editor(). With that said, thanks for all the help.

fc = r"C:\Users\Darrick\AppData\Roaming\ESRI\Desktop10.3\ArcCatalog\Sewer.sde\EC_Sewer.DBO.Sewer_Network"

workspace = os.path.dirname(fc)
edit = arcpy.da.Editor(workspace)
edit.startEditing(False, True)
edit.startOperation()
upsql = "OBJECTID = 175204"

with arcpy.da.UpdateCursor("GravityMain",["FromManHole"],upsql) as upcurs:
    for updat in upcurs:
        updat[0] = '222'
        upcurs.updateRow(updat)

edit.stopOperation()
edit.stopEditing(True)
del edit

Related Solutions

[GIS] Exporting lists of Feature classes and fields from SDE

Here's an example you can reference. It prints the results to both the console and to a text file, but you could easily manipulate it to write to a .csv file.

Hope this helps.

-ST

Results :

Feature Class Name : CR.CANADA1  
Geometry Type      : Polygon  
Has Spatial Index  : True  
Spatial Reference  : GCS_North_American_1927
  Field Name : CR.CANADA1.AREA       Field Type : Double            Field Length : 8
  Field Name : CODE                  Field Type : String            Field Length : 4
  Field Name : NAME                  Field Type : String            Field Length : 25
  Field Name : POP1991               Field Type : Double            Field Length : 8
  Field Name : POP91_SQMI            Field Type : Double            Field Length : 8
  Field Name : SHAPE                 Field Type : Geometry          Field Length : 4
  Field Name : SHAPE.AREA            Field Type : Double            Field Length : 0
  Field Name : SHAPE.LEN             Field Type : Double            Field Length : 0
  Field Name : SHAPE.FID             Field Type : OID               Field Length : 0
# of Fields in Feature Class 'CR.CANADA1' = 9

CODE :

import arcpy

logfile = open(r'C:\TEMP\ListFCs_ListFieldNames_ListFieldTypes.log', 'w')

def log_results(message):
    print(message)
    logfile.write(message)
    logfile.flush()
    return

def main():
    try:
        wk = arcpy.env.workspace = 'Database Connections/ORCL - SDE@SRVRNAME.sde'
        fcList = arcpy.ListFeatureClasses("*")
        fcList.sort()

        if not arcpy.Exists(wk):
            log_results("\n" + " SDE Connection File DOES NOT EXIST!!\n")
        else:
            fcCnt = 0
            fldCnt = 0

            for fc in fcList:
                fcCnt += 1
                desc = arcpy.Describe(fc)
                log_results ("\n Feature Class Name : {0}  \n Geometry Type      : {1}  \n Has Spatial Index  : {2}  \n Spatial Reference  : {3}".format(fc,desc.shapeType,str(desc.hasSpatialIndex),desc.spatialReference.name))
                #field = [f.name for f in arcpy.ListFields(fc)]
                fields = arcpy.ListFields(fc)
                fldCnt = 0
                for field in fields:
                    log_results ("\n    Field Name : {0: <24}  Field Type : {1: <20}  Field Length : {2}".format(field.name, field.type, field.length))
                    fldCnt += 1
                log_results ("\n # of Fields in Feature Class '{0}' = {1} \n".format(fc, fldCnt))

        log_results ("\n TOTAL # OF FEATURE CLASSES LISTED = {0}".format(fcCnt))
        log_results ("\n\n COMPLETED!! \n")

        logfile.close()

    except arcpy.ExecuteError:
        log_results (arcpy.GetMessages(2))

    except Exception as e:
        log_results (e[0])

if __name__ == '__main__':
    main()

[GIS] Unable to connect to “Database Connections/.sde” from python

Use full paths in scripts.

As far as python failing on opening the workspace, you may just be encountering a python format issue with the escape character. It is discussed on this nice blog

to illustrate:

>>> str = "C:\folder\file"
>>> str
'C:\x0colder\x0cile' <--Path being passed to arcpy (Bad)

>>> str = "C:\\folder\\file"
>>> str
'C:\\folder\\file'   <-- Good

>>> str = r"C:\folder\file"
>>> str
'C:\\folder\\file'   <-- Also Good

Related Question