topic Re: ListFeatureClasses : no result in Developers Questions

ListFeatureClasses : no result

MagalyClément-Zaber — Wed, 28 Feb 2018 12:46:25 GMT

Hi!

Here is a script that works on my machine :

#-*- coding: utf-8 -*-
import arcpy
arcpy.env.workspace = r"\\nassig\service$\geomatique\archi\6-Traitements\2-Python-36\2-Execution\cnx\PROD_donvdr_DC.sde"
print(arcpy.env.workspace)
fcList = arcpy.ListFeatureClasses()
for fc in fcList:
print(fc)

call "C:\PROGRA~1\ArcGIS\Pro\bin\Python\Scripts\propy" \\NASSIG\service$\geomatique\archi\6-Traitements\2-Python-36\1-Scripts\tests\test.py

It doesn't work on my server. I have no error.

Any idea ?

Thanks for help !

Python 3.6.2

Re: ListFeatureClasses : no result

JoshuaBixby — Wed, 28 Feb 2018 14:36:12 GMT

Given the path, it looks like there is a network file share containing the SDE connection file. If so, are the same user credentials being used on your machine and server to run the script? To eliminate the network file share as a potential problem, copy the SDE connection file local to the server and point the script to the local copy.

Re: ListFeatureClasses : no result

MagalyClément-Zaber — Wed, 28 Feb 2018 14:45:45 GMT

#-*- coding: utf-8 -*-
import arcpy
arcpy.env.workspace = r"D:\temp\cnx\PROD_donvdr_DC.sde"
print(arcpy.env.workspace)
fcList = arcpy.ListFeatureClasses()
for fc in fcList:
print(fc)

Result :

D:\temp>call "C:\PROGRA~1\ArcGIS\Pro\bin\Python\Scripts\propy" D:\temp\test.py
D:\temp\cnx\PROD_donvdr_DC.sde
Appuyez sur une touche pour continuer...

I can connect to D:\temp\cnx\PROD_donvdr_DC.sde from ArcCatalog

It's the same user.

Re: ListFeatureClasses : no result

JoshuaBixby — Wed, 28 Feb 2018 14:55:32 GMT

I am stumped. I can't understand why it is asking for user input, 'Appuyez sur une touche pour continuer," when run from the server. Nothing I see in the code snippet indicates you should see that. You have Pro installed on the server and configured the same way as on your local machine?

Re: ListFeatureClasses : no result

MagalyClément-Zaber — Wed, 28 Feb 2018 15:00:41 GMT

"Appuyez sur une touche pour continuer..." appears when the batch is finished ("pause")

call "C:\PROGRA~1\ArcGIS\Pro\bin\Python\Scripts\propy" D:\temp\test.py
pause

It is "normal"

I have Pro 2.1 on the two machines.

Re: ListFeatureClasses : no result

MagalyClément-Zaber — Tue, 06 Mar 2018 10:18:44 GMT

On my machine :

desc.dataElementType ==> DEWorkspace

On the Server :

desc.dataElementType ==> DEFile

Same sde file.

Same User.

I am lost 😞

Re: ListFeatureClasses : no result

MagalyClément-Zaber — Tue, 06 Mar 2018 10:21:42 GMT

I find this :

arcgis desktop - Python script fails on stand alone but works in ArcMap as a toolbox - Geographic Information Systems St…

and

https://community.esri.com/thread/102747

But didn't help...

Re: ListFeatureClasses : no result

MagalyClément-Zaber — Tue, 06 Mar 2018 13:48:05 GMT

I found the solution : uninstalling Oracle 64

Installation Oracle 64

I works fine

In my opinion, there was a problem installing Oracle 64-bit