Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
we're experiencing intermittent issues while retrieving data when connecting Qlik Sense (June 2019 Patch 2) to a MySQL Database hosted on Amazon RDS.
In short, the problem we're experiencing is as follows: Four times out of ten (on average) our extraction scripts terminates with errors due to a missing field: Field <field_name> not found.
Please also note that the database structure is stable as we're not working on a development environment so nobody is making unsolicited changes to the underlying database/schema/table structures.
A more detailed explanation is provided below:
Connection Drivers used:
- MySQL Database - Amazon RDS - QlikSense --> ODBC 5.3(w) Driver
Our extraction application works as follows:
We use an Excel file to store the names of tables and fields we need to load. This file is then processed by our script to generate a load statement that looks like this:
Table1:
Load
FIELD_ONE,
FIELD_TWO,
FIELD_THREE,
FIELD_FOUR
;
SQL SELECT
FIELD_ONE as FIELD_ONE,
FIELD_TWO as FIELD_TWO,
cast(FIELD_THREE as char) as FIELD_THREE,
FIELD_FOUR as FIELD_FOUR
FROM Schema.Table1;
STORE Table1 INTO [lib://Folder_Connection/Table1.qvd](qvd);
At this point, we may or may not run into the aforementioned error: "Field <field_name> not found" (e.g.:"Field FIELD_FOUR not found").
We've done some preliminary testing to better understand possible causes and:
I cannot stress enough that most of the time the load script works correctly and no errors are thrown. It looks like sometimes field names get misinterpreted more that anything else.
Have you ever experienced issues similar to this before? How did you solve them?
Any bit of help is truly appreciated.
Please, let me know if I can provide any further detail to better explain the issue.
Thank you.
Regards,
Matteo