Qlik Community

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikdan
Contributor II
Contributor II

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.

 

Debugger view:SQL Temp Table Issue.PNG

 

Labels (3)
1 Solution

Accepted Solutions
Vu_Nguyen
Support (Former)
Support (Former)

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.

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.

View solution in original post

2 Replies
Vu_Nguyen
Support (Former)
Support (Former)

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.

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.

View solution in original post

grangerats
Partner
Partner

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.