Failed to read data at {0:26}

[MattiaD]

Buongiorno a tutti, 

ho creato una connessione ad un db MySql nella versione SaaS di QlikSense. Riscontro il seguente problema, quando provo a selezionare una tabella nello script mi viene restituito il seguente errore:

Questo succede SOLO per questa tabella, le altre presenti nel database sono state aggiunte allo script senza errori o problemi.

Non riesco a capire quale sia il problema, potete aiutarmi?

Grazie mille

[rhodamineb1]

Hi, 

I have the exact same issue on few tables. I'd appreciate any help.

Thanks.

[Daniele_Purrone]

Buon pomeriggio Mattia!
This might happen if the tables contain unsupported data types (like json, for instance).

The list of supported data types is here:
Supported MySQL Enterprise Edition data types

Hope this helps!

[rhodamineb1]

Hello,

Firstly thanks for your kind answer. I've checked my table that has been throwing error but all the field types are supported by Qlik. 

You can see my tables field types below:

[Daniele_Purrone]

Thanks @rhodamineb1 is that also related to MySQl? Are the same tables always failing consistently? 
If you try loading them from a version of Qlik Sense Desktop, are they also failing?

[NicolasAimain1]

For those who encounter this problem, one solution is to convert data on SQL side

I had the same problem on several field but it worked when I excluded these fields or limited the amount of row loaded

I manage to load the full dataset using CONVERT(<my_field>,CHAR) as <my_field> during the SELECT on each field that had an error

Regards