Qlik Community

Qlik Sense Data Connectivity

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (4)
1 Solution

Accepted Solutions
Highlighted
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
Highlighted
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

Highlighted
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.