topic Re: Cannot open workspace in Python Questions

Cannot open workspace

KamyakaKasani — Tue, 06 Feb 2018 12:39:09 GMT

Getting the error "cannot open workspace" while using arcpy.da.Editor(arcpy.env.workspace) for a versioned data

Can anyone help on this.

Thanks,

Kamyaka

Re: Cannot open workspace

XanderBakker — Tue, 06 Feb 2018 12:41:14 GMT

I assume that you have the right license level available to start the editing on that workspace? Is it a Enterprise GDB (would require Standard or up). When you manually start editing on that workspace, does that work?

Re: Cannot open workspace

KamyakaKasani — Tue, 06 Feb 2018 13:07:52 GMT

Hi Xander,

Thanks for ur reply.

Yes, It is editing manually with the standard license.

Thanks,

Kamyaka

Re: Cannot open workspace

XanderBakker — Tue, 06 Feb 2018 13:31:43 GMT

If you look at the second example down below on this page Editor—Help | ArcGIS Desktop you can see the sequence of commands you should use. Can you post your code?

Re: Cannot open workspace

RebeccaStrauch__GISP — Tue, 06 Feb 2018 16:35:23 GMT

And make sure you are specifying

Path to the workspace to edit. Editor can edit only one workspace at a time

and not the FC. That sometimes is something that is overlooked. As Xander pointed out, check out the samples.

Re: Cannot open workspace

KamyakaKasani — Wed, 07 Feb 2018 04:16:14 GMT

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

Re: Cannot open workspace

XanderBakker — Sat, 11 Dec 2021 18:19:46 GMT

First of all, is this a script that will only be run 1 time or do you want to run it multiple times? If multiple times, it would be better to use an existing connection or check if it has already bee created. Creating a sde connection on the fly, requires additional like having the Oracle client 32 bits (ArcMap) and/or Oracle client 64 bits (ArcGIS Pro) installed and working and tnsnames.ora and sqlnet.ora configured properly (to name a few requirements).

If you look at the sample code that both Rebecca and I mentioned earlier:

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.InsertCursor(fc, ('SHAPE@', 'Name')) as icur:
    icur.insertRow([(7642471.100, 686465.725), 'New School'])

# Stop the edit operation.
edit.stopOperation()

# Stop the edit session and save the changes
edit.stopEditing(True)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

... you can see there is a sequence of steps to be followed:

you have you path to your feature class to be edited (line 4)
you determine the "path" (sde connection) which will be your workspace (line 5)
you create an editor object on your workspace (sde connection) at line 8
you start editing (see line 12) configuring that you want to edit versioned data
your start the edit operation (line 15)
on line 18 you start your update cursor with the logic you want to apply
at the end you stop your edit operation (line 22)
and finally you stop editing saving your edits (if they were successful) see line 25

What kind of business logic will you be applying inside the cursor?

Re: Cannot open workspace

KamyakaKasani — Sat, 11 Dec 2021 18:19:49 GMT

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)

Re: Cannot open workspace

XanderBakker — Wed, 07 Feb 2018 12:12:56 GMT

It should have failed on the line before also:

row[1] = '222'

This will not work since the index should be 0 and not 1. You only have 1 field.

and I don't think you have a featureclass and connection called like this:}

fc = 'Database Connections/Portland.sde/portland.jgp.schools'

Re: Cannot open workspace

KamyakaKasani — Sat, 11 Dec 2021 18:19:52 GMT

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

Re: Cannot open workspace

RebeccaStrauch__GISP — Wed, 07 Feb 2018 15:26:59 GMT

Hi Kamyaka Kasani ,

It looks like you are opening several thread that are related to the same issue? It is better to only post one, and if you have more information to help the original post, you can edit you post to add it (you can even change the title...but only if it help clarify...otherwise is can be confusing).

There are tips on posting https://community.esri.com/community/help-and-feedback/blog/2016/08/15/community-news-and-tips-how-to-ask-questions-and-get-answers?sr=search&searchId=55610eae-6c40-4925-9242-d5f4c4853a33&searchIndex=7‌ and any code can be posted using https://community.esri.com/people/curtvprice/blog/2014/09/25/posting-code-blocks-in-the-new-geonet?sr=search&searchId=dd5239d4-49ff-4661-80b7-babe88e70b5e&searchIndex=6‌ This help every one know if spacing is correct (critical for Python) and be able to refer to the same line number. (see Xander Bakker‌ code blocks vs your code blocks)

Just for reference, I think the other related posts are:

The requested operation is invalid on a closed state (#748417)

The requested operation is invalid on a closed state (#748418)

The requested operation is invalid on a closed state (#748387)

and this one which is post #748389

Having the relative responses in one post with ovoid duplication and will help others find a solution in the future. If there are no responses to some of the other posts, you can actually delete them...but only do so if there is no information, or if it is already included in another post. Thanks