Hey all, trying to generate a list for a project and can't get any results from the DB using arcpy. We have two SDE databases - our edit DB and 'warehouse' DB, with jobs moving data from edit to warehouse nightly. We are running postgres 9.6.8.
My script, if I can even call it that, is as simple as possible.
env.workspace = r'<connection file path>'
fc_list = arcpy.ListFeatureClasses()
print(fc_list[:20]) #don't want to get the whole list here, just see that it returns something
Pointing to our warehouse db, the script will run forever and never return anything. I have used ListFeatureClasses tons of times and have had issues in the past if I didn't point to the right workspace or there was something strange with the data. But I'm not sure if I've seen it get stuck like this. The connection file is using our admin schema shouldn't be an issue there.
I also tried using the walk function to step through the data that way, but no luck it also just hangs and doesn't return anything.
Strangely, I have no issues getting a list from our edit db. This would seem to indicate something different about our warehouse db that would cause this behavior, but I can't think of what that difference is.
Anyone seen this or have any suggestions how I can troubleshoot further with arcpy? Thanks.
