Unable to create/insert into SQL temp table after February 2019 upgrade

[qlikdan]

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.

Debugger view:

[Vu_Nguyen · Accepted solution]

Hi Qlikdan,

Preventing non-SELECT SQL queries is an intentional change from Qlik Sense February 2019. Please check this article https://support.qlik.com/articles/000064538 for a solution.

[grangerats]

It's most certainly related to this mess. Not only do you now have the "!EXECUTE_NON_SELECT_QUERY" workaround, but temp tables simply won't work with the QvOdbcConnectorPackage.exe at all.