topic Re: Automation starts with cached query results in Qlik Automate

Automation starts with cached query results

Old_Blendr_man — Sun, 22 Jun 2025 10:05:10 GMT

There is something greatly wrong with the automation component !

I created an automation that starts with a MySQL query. It should run a query like "select X from Y limit 1" So it will always return 1 (one) result as a maximum.

I restart the automation after each run since I need to verify if everything was done as needed and inspected.

But I notice that the "limit 1" is omitted from the MySQL query and it fact it runs now over all items in my database table.

The history of the blocks and the automation itself is garbled and shows wrong results that do not belong to the real run too.

Re: Automation starts with cached query results

rafaelencinas — Sun, 22 Jun 2025 18:28:53 GMT

Hi @Old_Blendr_man !

Witch one are you trying to extract data? Qlik Data Gateway or MySQL Connector ?

Thansks!

Re: Automation starts with cached query results

Old_Blendr_man — Mon, 23 Jun 2025 07:13:30 GMT

Hi I use the MySQL connector with a rather standard simple query.

Re: Automation starts with cached query results

Shai_E — Tue, 24 Jun 2025 09:51:45 GMT

Hi @Old_Blendr_man

You might want to create a support case for this with all the relevant attachments like

workspace json file, run json file showing the issue, pictures, run ids, etc