Latest Contributions by KamyakaKasani

Here is my code  mxd = arcpy.mapping.MapDocument("CURRENT") for lyr in arcpy.mapping.ListLayers(mxd): if lyr.name == 'test':     if lyr.supports("SERVICEPROPERTIES"):        servProp = lyr.serviceProperties        path = 'D:\\temp'        connection = "ttene71.sde"        fc = "test"        where = 'OBJECTID = 1' #35585        arcpy.CreateDatabaseConnection_management(path,connection,"ORACLE",<instance>,"DATABASE_AUTH",<user_name>,<password>,"SAVE_USERNAME","",<password>,"TRANSACTIONAL",<version_name>,"")        dbc = 'Database Connections//test1.sde'        workspace = os.path.dirname(dbc)        editor = arcpy.da.Editor(workspace)        editor.startEditing(False,True)        editor.startOperation()        cursor = arcpy.da.UpdateCursor(lyr,['OBJECTID','NAME'], where)        for row in cursor:              row[1] = '222'            cursor.updateRow(row) # getting the error here        del row        del cursor        editor.stopOperation()        editor.stopEditing(True)        del editor   del mxd ... View more

Manually I'm able to edit the data. While using arcpy I'm facing error. ... View more

I'm using Updatecursor logic all are working fine but while updating the row its getting failed at the statement  RuntimeError: The requested operation is invalid on a closed state  import arcpy import os fc = 'Database Connections/Portland.sde/portland.jgp.schools' workspace = os.path.dirname(fc) # Start an edit session. Must provide the workspace. edit = arcpy.da.Editor(workspace) # Edit session is started without an undo/redo stack for versioned data #  (for second argument, use False for unversioned data) edit.startEditing(False, True) # Start an edit operation edit.startOperation() # Insert a row into the table. with arcpy.da.UpdateCursor(fc, ('Name')) as ucur:     for row in ucur:          row[1] = '222'          ucur.updateRow(row)    # Failing at this case # Stop the edit operation. edit.stopOperation() # Stop the edit session and save the changes edit.stopEditing(True) ... View more

Even though same error it is throwing. ... View more

Here is my sample code path = 'D:\\temp' connection = "test1.sde" arcpy.CreateDatabaseConnection_management(path, connection, "ORACLE", instanse, "DATABASE_AUTH", "test", XXX, "SAVE_USERNAME", "", database, "TRANSACTIONAL", <version_name>,"") tablePath = path + "\\" + connection  arcpy.env.workspace = tablePath with arcpy.da.UpdateCursor(arcpy.env.workspace,[<field_name>], where) as cur:      # updatecursor stuff come here  ... View more

Hi Xander,   Thanks for ur reply.   Yes, It is editing manually with the standard license. Thanks, Kamyaka  ... View more