Qlik Community

Qlik Sense Data Connectivity

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

hlines_usacs
Contributor II

SQL query continuing to run after Script Abort

Hello,

We have noticed an issue when we abort a data reload that uses SQL queries. After I abort a reload, the SQL query continues to run even after I have restarted the reload. Has anyone else experienced this?

Thanks!

1 Solution

Accepted Solutions

Re: SQL query continuing to run after Script Abort

AFAIK this is a normal behaviour - the query can't know that the process which had started them didn't exists anymore until the query is finished and tried to transfer their data. This meant you would need to access the query-process directly within the database to be able to kill them. In general there are methods or specialized etl-tools to do such things but they are far away from trivial.

More practically could be to slice down the query into several smaller queries to avoid big queries and/or the use of incremental approaches to load only the current data. Here are various examples to these topic: Advanced topics for creating a qlik datamodel.

- Marcus

1 Reply

Re: SQL query continuing to run after Script Abort

AFAIK this is a normal behaviour - the query can't know that the process which had started them didn't exists anymore until the query is finished and tried to transfer their data. This meant you would need to access the query-process directly within the database to be able to kill them. In general there are methods or specialized etl-tools to do such things but they are far away from trivial.

More practically could be to slice down the query into several smaller queries to avoid big queries and/or the use of incremental approaches to load only the current data. Here are various examples to these topic: Advanced topics for creating a qlik datamodel.

- Marcus

Community Browser