AnsweredAssumed Answered

Cannot access SDE from external Python Env

Question asked by xemoka on Nov 24, 2014
Latest reply on Mar 11, 2015 by asengupta-esristaff

Hello Everyone,


I'm having a strange problem this morning that I've seen mentioned a couple time here on the forum without resolution.


Suddenly (as in, has changed in the last couple weeks) I am unable to access SDE connections through an external python interpreter (that is, one that is outside of ArcMap or ArcCatalog).


From within Arc's python window something such as


print [ for i in arcpy.Describe(r'path_to_sde_connections\user@current_sde_version.sde\dataset\feature_class').fields]


will work perfectly fine, but in an interpreter (the same version/site-packages as used by Arc) it will fail:


Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\", line 1234, in Describe
    return gp.describe(value)
  File "C:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\geoprocessing\", line 374, in describe
    self._gp.Describe(*gp_fixargs(args, True)))
IOError: "path_to_sde_connections\user@current_sde_version.sde\dataset\feature_class" does not exist


path_to_sde_connections\user@current_sde_version.sde\dataset\feature_class being a placeholder, this is generalized and has been tried with a number of sde connections, this print cmd works on non-sde gdbs.)


This is resulting in a script that I used and ran last month only working form being loaded into a python window within arc, where before I could run it from the command line.


Has anyone seen this before, or perhaps found a solution?


I can't begin to understand why suddenly this would occur. This is after a system reboot to ensure it would be conflict/lock-free. The only recent things I've done would be a pip update of lxml and pandas—which shouldn't be effecting it, as it works from within Arc.