Unable to create/insert into SQL temp table after February 2019 upgrade
I have a SQL query in my data load that contains a temp table. I have never had issues creating a temp table in SQL before, and the script runs fine outside of Qlik Sense. I'm using ODBC to connect to Microsoft SQL Server.
After I upgraded to the new February 2019 update yesterday, however, my reload task of this app has failed with the error of "Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it."
Any ideas of what happened? Other than the Qlik Sense upgrade no settings etc have been changed. Again, this same code has worked fine in this app for about a year right up until I completed the upgrade last night.