I am struggling with the following issue:
I created a arcpy script in which I connect to a database via sqlalchemy and collect some data into a pandas data frame. When I execute the tool within ArcGIS 10.3., it works perfectly fine. However, when I try to run it a second time within the same ArcGIS-session, it does not proceed, does not react to cancelling and seems to do nothing at all.
Here is what I basically do:
from sqlalchemy import create_engine import pandas # set up sqlalchemy engine: engine = create_engine('mssql+pyodbc://[USER]:[PASSWORD]@[SERVER]/[DATABASE]?driver=SQL+Server') # design query query = "some SELECT query here" # read data to pandas data frame df = pandas.read_sql_query(query, engine)
As I said, for the first run, everything is fine. When I execute it again, nothing happens, not even an error message. Another strange thing: it looks like it works fine when I execute the code from my IDE's python console, I can run it as often as I like. Seems like the problem is either in the engine setup or within ArcGIS.
Any help would be great, thank you!
EDIT: When I modify the script to force an error, fix this error and run it again, I get the following error message:
... File "C:\Python27\lib\site-packages\sqlalchemy\sql\selectable.py", line 2469, in __init__ for c in columns: AttributeError: 'tuple' object has no attribute 'lowercase'