topic Issue on loading data from Mysql db to QlikCloud in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-on-loading-data-from-Mysql-db-to-QlikCloud/m-p/1925536#M10670 <P>We encounter a strange error when loading data from a Mysql database<BR />The value of a field is not always loaded even if it exists in the data source. <BR />We have changed charset of mysql database, table and field to utf8mb4_unicode_ci without results.<BR />It would seem to be a Connector problem, what can we do?</P> <P>Suorce table data</P> <TABLE> <TBODY> <TR> <TD>10000</TD> <TD>AREA4</TD> </TR> <TR> <TD>10001</TD> <TD>AREA8</TD> </TR> <TR> <TD>10002</TD> <TD>AREA8</TD> </TR> <TR> <TD>10003</TD> <TD>AREA8</TD> </TR> <TR> <TD>10004</TD> <TD>AREA8</TD> </TR> <TR> <TD>10005</TD> <TD>AREA8</TD> </TR> <TR> <TD>10006</TD> <TD>AREA8</TD> </TR> <TR> <TD>10007</TD> <TD>AREA8</TD> </TR> <TR> <TD>10008</TD> <TD>AREA8</TD> </TR> <TR> <TD>10009</TD> <TD>AREA8</TD> </TR> <TR> <TD>10010</TD> <TD>AREA8</TD> </TR> <TR> <TD>10011</TD> <TD>AREA8</TD> </TR> <TR> <TD>10012</TD> <TD>AREA8</TD> </TR> <TR> <TD>10013</TD> <TD>AREA8</TD> </TR> <TR> <TD>10014</TD> <TD>AREA8</TD> </TR> <TR> <TD>10015</TD> <TD>AREA8</TD> </TR> <TR> <TD>10016</TD> <TD>AREA8</TD> </TR> <TR> <TD>10017</TD> <TD>AREA4</TD> </TR> <TR> <TD>10018</TD> <TD>AREA6</TD> </TR> <TR> <TD>10019</TD> <TD>AREA8</TD> </TR> <TR> <TD>10020</TD> <TD>AREA8</TD> </TR> <TR> <TD>10021</TD> <TD>AREA8</TD> </TR> <TR> <TD>10022</TD> <TD>AREA8</TD> </TR> <TR> <TD>10023</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10024</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10025</TD> <TD>AREA8</TD> </TR> <TR> <TD>10026</TD> <TD>AREA8</TD> </TR> <TR> <TD>10027</TD> <TD>AREA8</TD> </TR> <TR> <TD>10028</TD> <TD>AREA8</TD> </TR> <TR> <TD>10029</TD> <TD>AREA8</TD> </TR> <TR> <TD>10030</TD> <TD>AREA8</TD> </TR> <TR> <TD>10031</TD> <TD>AREA8</TD> </TR> <TR> <TD>10032</TD> <TD>AREA8</TD> </TR> <TR> <TD>10033</TD> <TD>AREA8</TD> </TR> <TR> <TD>10034</TD> <TD>AREA8</TD> </TR> <TR> <TD>10035</TD> <TD>AREA8</TD> </TR> <TR> <TD>10036</TD> <TD>AREA6</TD> </TR> <TR> <TD>10037</TD> <TD>AREA8</TD> </TR> <TR> <TD>10038</TD> <TD>AREA8</TD> </TR> <TR> <TD>10039</TD> <TD>AREA8</TD> </TR> <TR> <TD>10040</TD> <TD>AREA2</TD> </TR> <TR> <TD>10041</TD> <TD>AREA8</TD> </TR> <TR> <TD>10042</TD> <TD>AREA8</TD> </TR> <TR> <TD>10043</TD> <TD>AREA8</TD> </TR> <TR> <TD>10044</TD> <TD>AREA8</TD> </TR> <TR> <TD>10045</TD> <TD>AREA4</TD> </TR> <TR> <TD>10046</TD> <TD>AREA8</TD> </TR> <TR> <TD>10047</TD> <TD>AREA8</TD> </TR> <TR> <TD>10048</TD> <TD>AREA8</TD> </TR> <TR> <TD>10049</TD> <TD>AREA8</TD> </TR> <TR> <TD>10050</TD> <TD>AREA8</TD> </TR> <TR> <TD>10051</TD> <TD>AREA8</TD> </TR> <TR> <TD>10052</TD> <TD>AREA8</TD> </TR> <TR> <TD>10053</TD> <TD>AREA8</TD> </TR> <TR> <TD>10054</TD> <TD>AREA8</TD> </TR> <TR> <TD>10055</TD> <TD>AREA8</TD> </TR> <TR> <TD>10056</TD> <TD>AREA8</TD> </TR> <TR> <TD>10057</TD> <TD>AREA8</TD> </TR> <TR> <TD>10058</TD> <TD>AREA8</TD> </TR> <TR> <TD>10059</TD> <TD>AREA8</TD> </TR> <TR> <TD>10060</TD> <TD>AREA8</TD> </TR> <TR> <TD>10061</TD> <TD>AREA8</TD> </TR> <TR> <TD>10062</TD> <TD>AREA8</TD> </TR> <TR> <TD>10063</TD> <TD>AREA8</TD> </TR> <TR> <TD>10064</TD> <TD>AREA8</TD> </TR> <TR> <TD>10065</TD> <TD>AREA8</TD> </TR> <TR> <TD>10066</TD> <TD>AREA8</TD> </TR> <TR> <TD>10067</TD> <TD>AREA8</TD> </TR> <TR> <TD>10068</TD> <TD>AREA8</TD> </TR> <TR> <TD>10069</TD> <TD>AREA8</TD> </TR> <TR> <TD>10070</TD> <TD>AREA8</TD> </TR> <TR> <TD>10071</TD> <TD>AREA8</TD> </TR> <TR> <TD>10072</TD> <TD>AREA8</TD> </TR> <TR> <TD>10073</TD> <TD>AREA4</TD> </TR> <TR> <TD>10074</TD> <TD>AREA8</TD> </TR> <TR> <TD>10075</TD> <TD>AREA8</TD> </TR> <TR> <TD>10076</TD> <TD>AREA8</TD> </TR> <TR> <TD>10077</TD> <TD>AREA8</TD> </TR> <TR> <TD>10078</TD> <TD>AREA8</TD> </TR> <TR> <TD>10079</TD> <TD>AREA8</TD> </TR> <TR> <TD>10080</TD> <TD>AREA8</TD> </TR> <TR> <TD>10081</TD> <TD>AREA8</TD> </TR> <TR> <TD>10082</TD> <TD>AREA8</TD> </TR> <TR> <TD>10083</TD> <TD>AREA8</TD> </TR> <TR> <TD>10084</TD> <TD>AREA8</TD> </TR> <TR> <TD>10085</TD> <TD>AREA8</TD> </TR> <TR> <TD>10086</TD> <TD>AREA8</TD> </TR> <TR> <TD>10087</TD> <TD>AREA8</TD> </TR> <TR> <TD>10088</TD> <TD>AREA8</TD> </TR> <TR> <TD>10089</TD> <TD>AREA8</TD> </TR> <TR> <TD>10090</TD> <TD>AREA6</TD> </TR> <TR> <TD>10091</TD> <TD>AREA2</TD> </TR> <TR> <TD>10092</TD> <TD>AREA5</TD> </TR> <TR> <TD>10093</TD> <TD>AREA5</TD> </TR> <TR> <TD>10094</TD> <TD>AREA5</TD> </TR> <TR> <TD>10095</TD> <TD>AREA5</TD> </TR> <TR> <TD>10096</TD> <TD>AREA5</TD> </TR> <TR> <TD>10097</TD> <TD>AREA8</TD> </TR> <TR> <TD>10098</TD> <TD>AREA8</TD> </TR> <TR> <TD>10099</TD> <TD>AREA8</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 03 May 2022 10:31:07 GMT LucyInTheSky 2022-05-03T10:31:07Z Issue on loading data from Mysql db to QlikCloud https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-on-loading-data-from-Mysql-db-to-QlikCloud/m-p/1925536#M10670 <P>We encounter a strange error when loading data from a Mysql database<BR />The value of a field is not always loaded even if it exists in the data source. <BR />We have changed charset of mysql database, table and field to utf8mb4_unicode_ci without results.<BR />It would seem to be a Connector problem, what can we do?</P> <P>Suorce table data</P> <TABLE> <TBODY> <TR> <TD>10000</TD> <TD>AREA4</TD> </TR> <TR> <TD>10001</TD> <TD>AREA8</TD> </TR> <TR> <TD>10002</TD> <TD>AREA8</TD> </TR> <TR> <TD>10003</TD> <TD>AREA8</TD> </TR> <TR> <TD>10004</TD> <TD>AREA8</TD> </TR> <TR> <TD>10005</TD> <TD>AREA8</TD> </TR> <TR> <TD>10006</TD> <TD>AREA8</TD> </TR> <TR> <TD>10007</TD> <TD>AREA8</TD> </TR> <TR> <TD>10008</TD> <TD>AREA8</TD> </TR> <TR> <TD>10009</TD> <TD>AREA8</TD> </TR> <TR> <TD>10010</TD> <TD>AREA8</TD> </TR> <TR> <TD>10011</TD> <TD>AREA8</TD> </TR> <TR> <TD>10012</TD> <TD>AREA8</TD> </TR> <TR> <TD>10013</TD> <TD>AREA8</TD> </TR> <TR> <TD>10014</TD> <TD>AREA8</TD> </TR> <TR> <TD>10015</TD> <TD>AREA8</TD> </TR> <TR> <TD>10016</TD> <TD>AREA8</TD> </TR> <TR> <TD>10017</TD> <TD>AREA4</TD> </TR> <TR> <TD>10018</TD> <TD>AREA6</TD> </TR> <TR> <TD>10019</TD> <TD>AREA8</TD> </TR> <TR> <TD>10020</TD> <TD>AREA8</TD> </TR> <TR> <TD>10021</TD> <TD>AREA8</TD> </TR> <TR> <TD>10022</TD> <TD>AREA8</TD> </TR> <TR> <TD>10023</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10024</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>10025</TD> <TD>AREA8</TD> </TR> <TR> <TD>10026</TD> <TD>AREA8</TD> </TR> <TR> <TD>10027</TD> <TD>AREA8</TD> </TR> <TR> <TD>10028</TD> <TD>AREA8</TD> </TR> <TR> <TD>10029</TD> <TD>AREA8</TD> </TR> <TR> <TD>10030</TD> <TD>AREA8</TD> </TR> <TR> <TD>10031</TD> <TD>AREA8</TD> </TR> <TR> <TD>10032</TD> <TD>AREA8</TD> </TR> <TR> <TD>10033</TD> <TD>AREA8</TD> </TR> <TR> <TD>10034</TD> <TD>AREA8</TD> </TR> <TR> <TD>10035</TD> <TD>AREA8</TD> </TR> <TR> <TD>10036</TD> <TD>AREA6</TD> </TR> <TR> <TD>10037</TD> <TD>AREA8</TD> </TR> <TR> <TD>10038</TD> <TD>AREA8</TD> </TR> <TR> <TD>10039</TD> <TD>AREA8</TD> </TR> <TR> <TD>10040</TD> <TD>AREA2</TD> </TR> <TR> <TD>10041</TD> <TD>AREA8</TD> </TR> <TR> <TD>10042</TD> <TD>AREA8</TD> </TR> <TR> <TD>10043</TD> <TD>AREA8</TD> </TR> <TR> <TD>10044</TD> <TD>AREA8</TD> </TR> <TR> <TD>10045</TD> <TD>AREA4</TD> </TR> <TR> <TD>10046</TD> <TD>AREA8</TD> </TR> <TR> <TD>10047</TD> <TD>AREA8</TD> </TR> <TR> <TD>10048</TD> <TD>AREA8</TD> </TR> <TR> <TD>10049</TD> <TD>AREA8</TD> </TR> <TR> <TD>10050</TD> <TD>AREA8</TD> </TR> <TR> <TD>10051</TD> <TD>AREA8</TD> </TR> <TR> <TD>10052</TD> <TD>AREA8</TD> </TR> <TR> <TD>10053</TD> <TD>AREA8</TD> </TR> <TR> <TD>10054</TD> <TD>AREA8</TD> </TR> <TR> <TD>10055</TD> <TD>AREA8</TD> </TR> <TR> <TD>10056</TD> <TD>AREA8</TD> </TR> <TR> <TD>10057</TD> <TD>AREA8</TD> </TR> <TR> <TD>10058</TD> <TD>AREA8</TD> </TR> <TR> <TD>10059</TD> <TD>AREA8</TD> </TR> <TR> <TD>10060</TD> <TD>AREA8</TD> </TR> <TR> <TD>10061</TD> <TD>AREA8</TD> </TR> <TR> <TD>10062</TD> <TD>AREA8</TD> </TR> <TR> <TD>10063</TD> <TD>AREA8</TD> </TR> <TR> <TD>10064</TD> <TD>AREA8</TD> </TR> <TR> <TD>10065</TD> <TD>AREA8</TD> </TR> <TR> <TD>10066</TD> <TD>AREA8</TD> </TR> <TR> <TD>10067</TD> <TD>AREA8</TD> </TR> <TR> <TD>10068</TD> <TD>AREA8</TD> </TR> <TR> <TD>10069</TD> <TD>AREA8</TD> </TR> <TR> <TD>10070</TD> <TD>AREA8</TD> </TR> <TR> <TD>10071</TD> <TD>AREA8</TD> </TR> <TR> <TD>10072</TD> <TD>AREA8</TD> </TR> <TR> <TD>10073</TD> <TD>AREA4</TD> </TR> <TR> <TD>10074</TD> <TD>AREA8</TD> </TR> <TR> <TD>10075</TD> <TD>AREA8</TD> </TR> <TR> <TD>10076</TD> <TD>AREA8</TD> </TR> <TR> <TD>10077</TD> <TD>AREA8</TD> </TR> <TR> <TD>10078</TD> <TD>AREA8</TD> </TR> <TR> <TD>10079</TD> <TD>AREA8</TD> </TR> <TR> <TD>10080</TD> <TD>AREA8</TD> </TR> <TR> <TD>10081</TD> <TD>AREA8</TD> </TR> <TR> <TD>10082</TD> <TD>AREA8</TD> </TR> <TR> <TD>10083</TD> <TD>AREA8</TD> </TR> <TR> <TD>10084</TD> <TD>AREA8</TD> </TR> <TR> <TD>10085</TD> <TD>AREA8</TD> </TR> <TR> <TD>10086</TD> <TD>AREA8</TD> </TR> <TR> <TD>10087</TD> <TD>AREA8</TD> </TR> <TR> <TD>10088</TD> <TD>AREA8</TD> </TR> <TR> <TD>10089</TD> <TD>AREA8</TD> </TR> <TR> <TD>10090</TD> <TD>AREA6</TD> </TR> <TR> <TD>10091</TD> <TD>AREA2</TD> </TR> <TR> <TD>10092</TD> <TD>AREA5</TD> </TR> <TR> <TD>10093</TD> <TD>AREA5</TD> </TR> <TR> <TD>10094</TD> <TD>AREA5</TD> </TR> <TR> <TD>10095</TD> <TD>AREA5</TD> </TR> <TR> <TD>10096</TD> <TD>AREA5</TD> </TR> <TR> <TD>10097</TD> <TD>AREA8</TD> </TR> <TR> <TD>10098</TD> <TD>AREA8</TD> </TR> <TR> <TD>10099</TD> <TD>AREA8</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 03 May 2022 10:31:07 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Issue-on-loading-data-from-Mysql-db-to-QlikCloud/m-p/1925536#M10670 LucyInTheSky 2022-05-03T10:31:07Z