topic Re: Unable to create/insert into SQL temp table after February 2019 upgrade in Connectivity & Data Prep

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

qlikdan — Tue, 28 Dec 2021 20:21:37 GMT

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:

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

Vu_Nguyen — Wed, 13 Mar 2019 11:18:51 GMT

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.

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

grangerats — Thu, 10 Oct 2019 15:24:11 GMT

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.