I use Microsoft Query via Excel to query an Intersystems database.
Since upgrading from CACHE to Intersystems, lots of reports fail to refresh twice - by which I mean I can open the report (which may have several separate queries) and query the database once, and then it will refuse to reconnect.
I get:
[IRIS ODBC][State : S1000][Native Code 417] .... Access denied
If I then close and reopen excel, I can run the query again.