nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Setting workspace to SDE feature dataset

KerryAlley

I have a python add-in that successfully edits data in a file .gdb (with or without invoking the editor in the script), but I can't edit data in an SDE feature dataset. I can edit the SDE data (9.3) manually in ArcMap, and the add-in successfully interacts with the SDE data using search cursors. SP1 is installed. Any suggestions about what might be causing the error in response to this code?

workspace = r"Database Connections\GDB_HMSDEV.sde\GDB_HMSDEV.HMSADMIN.KerrySandbox" edit = arcpy.da.Editor(workspace)

Traceback (most recent call last):
File "C:\Users\kalley\AppData\Local\ESRI\Desktop10.1\AssemblyCache\{87D25F75-9A62-5BC9-A006-4B496936EC0F}\ShieldToolTest_addin.py", line 79, in onLine
edit = arcpy.da.Editor(workspace)
RuntimeError: cannot open workspace

I can provide the full code if necessary...just wanted to keep it simple first.

Vind meer berichten getagd met

Accepted answers

MikeVolz

Kerry:

Since you are using ArcGIS v10.1 you might need to specify the full path to the SDE connection and just

r"Database Connections\GDB_HMSDEV.sde\GDB_HMSDEV.HMSADMIN.KerrySandbox"

All comments

DanNguyen

If my GIS session is through a Citrix connection, do you know what would be my database connection? I can't seem to get my script to start Edit session.

Any helps will be greatly appreciated.

Thanks

KerryAlley

Thanks mvolz47!

What you said finally sank into my thick head... and set off a whole cascade of Eureka moments.
I simply changed the workspace (using the .workspacePath of a layer instead of its .dataSource):

workspace = rdsmall_lyr.workspacePath

which was equivalent to the SDE connection path:

workspace = r"C:\Users\kalley\AppData\Roaming\ESRI\Desktop10.1\ArcCatalog\GDB_HMSDEV.sde"

and everything went smoothly!

Thanks again!!

JakeSkinner

Hi Kerry,

You won't be able to set the workspace to a feature dataset. It will need to be set only to the sde geodatabase. When you specify a feature class within the feature dataset, just add the feature dataset name first. Ex:

env.workspace = r"Database Connections\SQLSERVER.sde"
desc = arcpy.Describe("Structures\Bridges")

MikeVolz

Kerry:

Since you are using ArcGIS v10.1 you might need to specify the full path to the SDE connection and just

r"Database Connections\GDB_HMSDEV.sde\GDB_HMSDEV.HMSADMIN.KerrySandbox"

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.