Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
hlines_usacs
Creator II
Creator 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
marcus_sommer

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

View solution in original post

1 Reply
marcus_sommer

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