Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Q&A with Qlik - Qlik Cloud Migration: Questions about migrating to Qlik Cloud? Catch the latest replay!
cancel
Showing results for 
Search instead for 
Did you mean: 
Old_Blendr_man
Contributor II
Contributor II

Automation starts with cached query results

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. 

Labels (2)
3 Replies
rafaelencinas
Partner - Creator II
Partner - Creator II

Hi @Old_Blendr_man ! 

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

 

Thansks!

"Without data, you're just another person with an opinion." — W. Edwards Deming.
Old_Blendr_man
Contributor II
Contributor II
Author

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

Shai_E
Support
Support

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