https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Data-Transfer-Data-Conversion/m-p/1830530#M9451 <P>Hi,<BR />I found an issue in Qlik Data Transfer.<BR />Can't upload data from a MySQL Database due to the error:</P><DIV class="MuiGrid-root MuiGrid-container MuiGrid-wrap-xs-nowrap MuiGrid-justify-xs-space-between"><DIV class="MuiGrid-root MuiGrid-container MuiGrid-align-items-xs-center"><SPAN>Reload failed</SPAN></DIV><DIV class="MuiGrid-root MuiGrid-item"><SPAN>The value '4070905200' could not be converted to type integer(4-bytes)</SPAN></DIV></DIV><DIV class="MuiCollapse-container MuiCollapse-entered"><DIV class="MuiCollapse-wrapper"><DIV class="MuiCollapse-wrapperInner"><DIV class="MuiGrid-root jss1320 MuiGrid-container MuiGrid-direction-xs-column"><DIV class="MuiGrid-root MuiGrid-item">mytable_name &lt;&lt; QueryResult</DIV><DIV class="MuiGrid-root MuiGrid-item">&nbsp;</DIV><DIV class="MuiGrid-root MuiGrid-item">It seems it can't upload datas from a Date/Time fields (if I disable the field, it works!).</DIV><DIV class="MuiGrid-root MuiGrid-item">Some help? How can I edit the "Load Statement" in Qlik Data Transfer to use a CAST() function?</DIV><DIV class="MuiGrid-root MuiGrid-item"><LI-PRODUCT title="Qlik DataTransfer" id="qlikDataTransfer"></LI-PRODUCT>&nbsp;</DIV></DIV></DIV></DIV></DIV> Fri, 10 Dec 2021 21:09:00 GMT Marcoimp 2021-12-10T21:09:00Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Data-Transfer-Data-Conversion/m-p/1830530#M9451 <P>Hi,<BR />I found an issue in Qlik Data Transfer.<BR />Can't upload data from a MySQL Database due to the error:</P><DIV class="MuiGrid-root MuiGrid-container MuiGrid-wrap-xs-nowrap MuiGrid-justify-xs-space-between"><DIV class="MuiGrid-root MuiGrid-container MuiGrid-align-items-xs-center"><SPAN>Reload failed</SPAN></DIV><DIV class="MuiGrid-root MuiGrid-item"><SPAN>The value '4070905200' could not be converted to type integer(4-bytes)</SPAN></DIV></DIV><DIV class="MuiCollapse-container MuiCollapse-entered"><DIV class="MuiCollapse-wrapper"><DIV class="MuiCollapse-wrapperInner"><DIV class="MuiGrid-root jss1320 MuiGrid-container MuiGrid-direction-xs-column"><DIV class="MuiGrid-root MuiGrid-item">mytable_name &lt;&lt; QueryResult</DIV><DIV class="MuiGrid-root MuiGrid-item">&nbsp;</DIV><DIV class="MuiGrid-root MuiGrid-item">It seems it can't upload datas from a Date/Time fields (if I disable the field, it works!).</DIV><DIV class="MuiGrid-root MuiGrid-item">Some help? How can I edit the "Load Statement" in Qlik Data Transfer to use a CAST() function?</DIV><DIV class="MuiGrid-root MuiGrid-item"><LI-PRODUCT title="Qlik DataTransfer" id="qlikDataTransfer"></LI-PRODUCT>&nbsp;</DIV></DIV></DIV></DIV></DIV> Fri, 10 Dec 2021 21:09:00 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Data-Transfer-Data-Conversion/m-p/1830530#M9451 Marcoimp 2021-12-10T21:09:00Z