AnsweredAssumed Answered

List feature classes can't find anything in SDE - why?

Question asked by Tiaman on Nov 13, 2014
Latest reply on Sep 10, 2017 by whuyp

I'm trying to create a script that pulls about 20 or so feature classes out of sde and puts them in a geodatabase for a group of people to look at for a special project. I'm trying to do this with a for loop and the copy_management function. However after playing around with the script for a while I realized I needed to start back at the beginning because I seem to be having an issue getting the ListFeatureClasses function to even return anything from my SDE connection. Here is just a simple test I put together:

 

import arcpy

import os

 

warehouse = r"C:\Users\aaronmanuel\AppData\Roaming\ESRI\Desktop10.0\ArcCatalog\Warehouse.sde"

testgdb = r"C:\Projects\Test\TestGDB.gdb"

 

 

arcpy.env.workspace = warehouse

 

 

fcList = arcpy.ListFeatureClasses("*") 

 

 

print fcList

 

Running this script returns "[ ]" - an empty list.

 

Running it after changing the environment to the testgdb returns this:

 

[u'TestLine', u'coa_water_meter', u'coa_water_hydrant']

 

Which is correct, I put in these three features for testing purposes.

 

Googling has led me a few other threads of the "ListFeatureClasses returns an empty list" variety, but ultimately I couldn't find any real answer. What other factors besides stuff like typos and incorrect file paths could be causing this function to return and empty list?

 

Thanks.

Outcomes