topic Oracle odbc read failed in QlikView https://community.qlik.com/t5/QlikView/Oracle-odbc-read-failed/m-p/325714#M119931 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I have a big problem</P><P>when i'm trying to load a table in the script using oracle odbc driver</P><P>this table contains nearly 1 million record</P><P>but it stop loading @ 340.000 and this message appear</P><P>"ODBC Read Failed"</P><P>when i press "OK"</P><P>this is what's written in the script execution progress dialog </P><P>"QUX_unexpected end of data oracle odbc: invalid datetime format " </P><P></P><P></P><P>i tried to run the select statement on the plsqldev and it returns the table normally but the problem in the script in qlikview</P><P></P><P>Attached the two error messages.</P><P></P><P>p.s</P><P>The other tables are loaded normally but this issue appear in this table only.</P><P></P><P>Any Help Please</P><P></P><P>Regards,</P><P>Mona </P></BODY></HTML> Tue, 06 Sep 2011 10:37:13 GMT 2011-09-06T10:37:13Z Oracle odbc read failed https://community.qlik.com/t5/QlikView/Oracle-odbc-read-failed/m-p/325714#M119931 <HTML><HEAD></HEAD><BODY><P>HI,</P><P>I have a big problem</P><P>when i'm trying to load a table in the script using oracle odbc driver</P><P>this table contains nearly 1 million record</P><P>but it stop loading @ 340.000 and this message appear</P><P>"ODBC Read Failed"</P><P>when i press "OK"</P><P>this is what's written in the script execution progress dialog </P><P>"QUX_unexpected end of data oracle odbc: invalid datetime format " </P><P></P><P></P><P>i tried to run the select statement on the plsqldev and it returns the table normally but the problem in the script in qlikview</P><P></P><P>Attached the two error messages.</P><P></P><P>p.s</P><P>The other tables are loaded normally but this issue appear in this table only.</P><P></P><P>Any Help Please</P><P></P><P>Regards,</P><P>Mona </P></BODY></HTML> Tue, 06 Sep 2011 10:37:13 GMT https://community.qlik.com/t5/QlikView/Oracle-odbc-read-failed/m-p/325714#M119931 2011-09-06T10:37:13Z Oracle odbc read failed https://community.qlik.com/t5/QlikView/Oracle-odbc-read-failed/m-p/325715#M119932 <HTML><HEAD></HEAD><BODY><P>i found that there's 3 columns in this table which cause the problem but i don't know why??</P></BODY></HTML> Tue, 06 Sep 2011 12:01:58 GMT https://community.qlik.com/t5/QlikView/Oracle-odbc-read-failed/m-p/325715#M119932 2011-09-06T12:01:58Z