Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.

Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.

Sonja_Bauernfeind
Digital Support
Digital Support

Connector reply error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.

Qlik ODBC connector package (database connector built-in Qlik Sense) fails to reload with error Connector reply error:

Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.

The issue is observed when the query following SQL keyword is not SELECT, but another statement like INSERT, UPDATE, WITH .. AS or stored procedure call.

Environment:

  • Qlik Sense Enterprise on Windows
  • Qlik Sense Enterprise SaaS
  • Qlik Sense Desktop
  • QlikView Server
  • QlikView Desktop

 

Cause:

See the Qlik Sense February 2019 Release Notes for details on item QVXODBC-1406.

 

Resolution


By default, non-SELECT queries are disabled in the Qlik ODBC Connector Package and users will get an error message indicating this if the query is present in the load script. In order to enable non-SELECT queries, allow-nonselect-queries setting should be set to True by the Qlik administrator. 


To enable non-SELECT queries:


1. Modify the QvOdbcConnectorPackage.exe.config found in the locations mentioned below.
Set the parameter allow-nonselect-queries to True  Note: This is case sensitive. true will not work.

Note:
In a multi node environment, the changes need to be applied to all nodes.
Configuration file QvOdbcConnectorPackage.exe.config locations:

  • Qlik Sense Enterprise: C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
  • Qlik Sense Desktop: C:\Users\user-name\AppData\Local\Programs\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
  • QlikView: C:\Program Files\Common Files\QlikTech\Custom Data\QvOdbcConnectorPackage

Note: No service restarts should be required. 

EnableNon-SelectQueries.gif

 


2. Now non-select statements are already enabled. If you need to run SQL statements without any data table returned (INSERT/ UPDATE/ DELETE/ DROP), add keyword !EXECUTE_NON_SELECT_QUERY at the end of the query. Other queries that return data (such as WITH ... AS in PostgreSQL) does not need this keyword.

More details are documented in the Qlik ODBC Connector package help site.

Should you have more questions, our active Community is ready to help further

 

Related Content:

Labels (2)
Comments
langelwong
Partner
Partner

In a QlikCloud Enviromento what is the procedure?

Sonja_Bauernfeind
Digital Support
Digital Support

Hello @langelwong - in Qlik Sense SaaS editions, this is currently not possible. We have an active improvement request logged for it, and I would recommend lending your voice (your like/vote) to this idea in our ideas exchange: Executing non-SELECT queries with Qlik Sense Business .

SimonLessard
Contributor II
Contributor II

Hi ! I receive the following error when trying to insert data into a temp table with a SQL connector:

The following error occurred:
Unable to get column information for the fields that are used in the query: Object reference not set to an instance of an object.
 
The error occurred here:
SQL SELECT SQL_FIELD INTO #TEMP FROM SQL_TABLE WHERE SQL_TABLE .SQL_FIELD = '2020'
 

Is there a workaround for this ? 

Some people have suggested using a OLE DB connector instead of an SQL one or dowgrading the ODBC Package version but I was wondering if there was a proper solution for SQL connectors.

Thanks !

Version history
Revision #:
6 of 6
Last update:
‎2021-01-14 11:36 AM
Updated by: