topic Re: Failed to read data at {0:26} in Connectivity & Data Prep

Failed to read data at {0:26}

MattiaD — Tue, 13 Dec 2022 13:55:02 GMT

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

Re: Failed to read data at {0:26}

rhodamineb1 — Wed, 11 Jan 2023 12:38:52 GMT

Hi,

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

Thanks.

Re: Failed to read data at {0:26}

Daniele_Purrone — Wed, 11 Jan 2023 12:47:20 GMT

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!

Re: Failed to read data at {0:26}

rhodamineb1 — Wed, 11 Jan 2023 13:09:23 GMT

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:

Re: Failed to read data at {0:26}

Daniele_Purrone — Wed, 11 Jan 2023 16:12:09 GMT

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?

Re: Failed to read data at {0:26}

NicolasAimain1 — Wed, 25 Oct 2023 09:21:08 GMT

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