DATA GATEWAY DIRECT ACESS

[ramonneto]

Hi guys, I'm facing a new problem with Qlik Cloud. In an attempt to move our ETL process to Qlik Cloud, I'm using the MySQL connector for a specific query, which is identical to the data extraction done in Qlik Sense.

What happens is that in a query, in a specific field, Qlik Cloud returns "-1" in all rows, instead of the correct information:

I know the information is incorrect, because when I query the same query in Qlik Sense (or any data reading client) I see the data correctly. Could someone check?

[marksouzacosta]

Hi @ramonneto,

Interesting problem. That sounds like a case for Qlik Support.
Can you please answer a few questions?

1. What is the version of the Qlik Data Gateway installed?
2. Which Data Connection are you using?
3. What is the version of you MySQL Database and what is the Column Type?

Regards,

Mark Costa

[ramonneto]

HI @marksouzacosta 
1. I tested with version 1.6.6 and also with the current version 1.6.7.
2. MySQL Enterprise Edition (via Direct Access gateway). I configured the Qlik native connection service.
3. In MySQL version 5.7 the field is type "int(9) unsigned"

An interesting point is that this situation does not occur in other tables in my database.