topic Qlikcloud - Executing non-SELECT queries in Connectivity & Data Prep

Qlikcloud - Executing non-SELECT queries

GA85 — Wed, 30 Oct 2019 08:29:56 GMT

Hey,

i'm using variables for my SQL Statement and set them with a lot of declare's.

On my Desktop Qlik I'm able to Change my config file with <add key="allow-nonselect-queries" value="True"/> that this works.

In the Qlikcloud enviroment i have now the same error again
(Connector error: Executing non-SELECT queries is disabled. Please contact your system administrator to enable it.)
My SQL Statement is like this (just an easy example)

SQL
declare @startdate as datetime = '2019.09.01'

select column_a,column_b from table_X where columndate >= @Startdate;

The used SQL is much more complex 😉 - so using the Statement without declare's at the beginning is not an Option for me. Is there any Option in QLIKCloud that this will work - are there some Settings or hints?

Re: Qlikcloud - Executing non-SELECT queries

gaidamichal — Wed, 03 Jun 2020 15:19:41 GMT

Hello,

Have you got around it somehow? I've got the same issue.

Re: Qlikcloud - Executing non-SELECT queries

Aleks24 — Thu, 11 Jun 2020 15:39:41 GMT

Someone has solution for Qlik Sense Business (Cloud)? How to enable non-select queries ?

Re: Qlikcloud - Executing non-SELECT queries

artemibe — Sat, 08 Aug 2020 10:15:58 GMT

Any solution???. Also have this problem in CLOUD version.

Re: Qlikcloud - Executing non-SELECT queries

langelwong — Tue, 11 Aug 2020 16:28:57 GMT

Hey ,

do you found a solution to this?

Re: Qlikcloud - Executing non-SELECT queries

Aleks24 — Wed, 12 Aug 2020 05:35:22 GMT

Hi,

There is no solution yet. But I've already posted this issue to "Ideas". Probably it should be reviewed in future cloud updates.

See : Executing non-SELECT queries with Qlik Sense Business