topic Re: Not able to set workspace using standalone Python script for ArcGIS in Geodatabase Questions

Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 06:51:36 GMT

I am facing a very weird issue in setting the workspace. When I setup the workspace inside python window in ArcMap/ArcCatalog, it just works fine. But the moment I do the same in a standalone python script, the things do not work at all. I tried other options like creating connection file in scratch folder and then setting it as a workspace but still no luck. I am facing this issue on ArcGIS Desktop 10.2.1 and my database is 64 bit Oracle.

I had ArcGIS Pro 2.1 installed on the same machine hence I also tried the same thing after uninstalling ArcGIS Pro but still no luck.

Re: Not able to set workspace using standalone Python script for ArcGIS

NeilAyres — Wed, 22 Aug 2018 07:43:08 GMT

Can you browse the database in ArcCatalog once you have opened the connection file?

Just setting env.workspace = "my connection file.sde" has always worked for me.

What happens?

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 07:51:05 GMT

Hi Neil,

Yes, I can browse the database in ArcCatalog/ArcMap and walk around the featureclasses/datasets etc. But this is driving me crazy as env.workspace = "my connection file.sde" is no way working for me.

Re: Not able to set workspace using standalone Python script for ArcGIS

NeilAyres — Wed, 22 Aug 2018 08:02:41 GMT

What happens when you set env.workspace = "my connection file.sde" in your python script?

Are you using os.path.join() to construct the path pointer to the connection file? Or just raw strings.

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 09:00:26 GMT

I set up my workspace in the following manner

arcpy.env.workspace = r"Database Connections\Connection to sde.sde"

# Just for sake of testing, I am trying to print all the datasets

print arcpy.ListDatasets()

The above code snippet prints all the datasets list if I run it in python window withing ArcMap but If I try to run the same snippet in a script, it Print "None"

Re: Not able to set workspace using standalone Python script for ArcGIS

DanPatterson_Retired — Wed, 22 Aug 2018 09:53:21 GMT

in a standalone script it will need more information that provided since the script has no information as to where the project is. Can you use a full path to your database connection

Create Database Connection—Data Management toolbox | ArcGIS Desktop

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 10:38:06 GMT

Hi Dan,

Thanks for the suggestion. I have tried that option as well and it didn't work.

Re: Not able to set workspace using standalone Python script for ArcGIS

JoeBorgione — Wed, 22 Aug 2018 11:45:00 GMT

I like to use ArcCatolog to provide the the path: with it open, navigate to the workspace and up at the top of the window is the actual path. Click, copy and paste it into your code:

arcpy.env.workspace = r'X:\your\copied\path\here'‍

Re: Not able to set workspace using standalone Python script for ArcGIS

NeilAyres — Wed, 22 Aug 2018 12:57:28 GMT

This is not going to work:

arcpy.env.workspace = r"Database Connections\Connection to sde.sde"

The script has no idea where your user profile will be.

Copy the full path as Joe suggests.

Or copy the sde file to a local space and use that.

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 13:02:59 GMT

I have tried with full path as well, no luck!

Re: Not able to set workspace using standalone Python script for ArcGIS

JoeBorgione — Wed, 22 Aug 2018 13:38:17 GMT

Let's see exactly what your are using.

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 13:54:08 GMT

Option1

Import arcpy

arcpy.env.workspace = r‘Database Connections\Connection to sde.sde’

print arcpy.ListDatasets()

Option2

Import arcpy

arcpy.env.workspace = r‘C:\Users\<MyUserName>\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\Connection to sde.sde’

print arcpy.ListDatasets()

Result in Python Window within ArcMap : [‘dataset1’, ‘dataset2’]

Result in Pyscripter : None

Re: Not able to set workspace using standalone Python script for ArcGIS

JoeBorgione — Wed, 22 Aug 2018 14:14:25 GMT

I don't have pyscripter but I can run this in an idle shell:

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 14:24:41 GMT

Here how it happens even when I try the same in IDLE

Re: Not able to set workspace using standalone Python script for ArcGIS

JoeBorgione — Wed, 22 Aug 2018 14:51:15 GMT

I wonder if it's bombing on the spaces in your actual paths.

Dan Patterson‌ ; care to comment?

Re: Not able to set workspace using standalone Python script for ArcGIS

NeilAyres — Wed, 22 Aug 2018 15:21:45 GMT

Can you also try arcpy.Exists(r"path to sde connection file.sde")

Re: Not able to set workspace using standalone Python script for ArcGIS

DanPatterson_Retired — Wed, 22 Aug 2018 15:22:23 GMT

I zone out whenever I see SDE anywhere

Re: Not able to set workspace using standalone Python script for ArcGIS

NeilAyres — Wed, 22 Aug 2018 15:27:53 GMT

Ha, ha,

But I also zone out when I see this sort of stuff...

>>> X, Y = np.mgrid[xmin:xmax:100j, ymin:ymax:100j]>>> positions = np.vstack([X.ravel(), Y.ravel()])>>> values = np.vstack([m1, m2])

What does it mean.....

Re: Not able to set workspace using standalone Python script for ArcGIS

JoeBorgione — Wed, 22 Aug 2018 15:36:34 GMT

Just numpy messing with you Neil.

Dan- I think because SDE isn't pc any more. It's really Enterprise Geodatabse....

Re: Not able to set workspace using standalone Python script for ArcGIS

HarshalGharat — Wed, 22 Aug 2018 16:45:31 GMT

Tried after getting rid of spaces as well, same result. This is driving me crazy since a week!