topic Failed to Load Large Table in QlikView https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351042#M130170 <HTML><HEAD></HEAD><BODY><P>Publisher at night, but I made a schema change so manually right now.&nbsp; I tried locally then I tried manually from the server to use more resources and improve stability.&nbsp; Both gave the same read error.&nbsp; </P></BODY></HTML> Mon, 14 May 2012 21:13:43 GMT 2012-05-14T21:13:43Z Failed to Load Large Table https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351040#M130168 <HTML><HEAD></HEAD><BODY><P>We have one table that is in mysql and is 10 million records. We re-load the full table every day.&nbsp; I keep getting an error about failure to read, but I can run the query manually.&nbsp; Are there any tricks to loading large tables?&nbsp; </P></BODY></HTML> Mon, 14 May 2012 21:03:17 GMT https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351040#M130168 2012-05-14T21:03:17Z Failed to Load Large Table https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351041#M130169 <HTML><HEAD></HEAD><BODY><P> How are you reloading the file? Publisher or . . . .<BR />Stephen</P></BODY></HTML> Mon, 14 May 2012 21:05:52 GMT https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351041#M130169 2012-05-14T21:05:52Z Failed to Load Large Table https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351042#M130170 <HTML><HEAD></HEAD><BODY><P>Publisher at night, but I made a schema change so manually right now.&nbsp; I tried locally then I tried manually from the server to use more resources and improve stability.&nbsp; Both gave the same read error.&nbsp; </P></BODY></HTML> Mon, 14 May 2012 21:13:43 GMT https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351042#M130170 2012-05-14T21:13:43Z Failed to Load Large Table https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351043#M130171 <HTML><HEAD></HEAD><BODY><P> We have the same problem loading tables from an Microsoft Access. We created a batch file (.bat) and schedule the file to run.</P><P>The batch file is:</P><P>psexec -u UserName -p Password "c:\Program Files (x86)\QlikView\qv.exe" -r "Q:\Path\QlikViewDocument.qvw"</P><P></P><P>The problem seems to be that Publisher has a problem reloading with an ODBC connection.</P><P>Stephen</P></BODY></HTML> Mon, 14 May 2012 21:21:33 GMT https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351043#M130171 2012-05-14T21:21:33Z Failed to Load Large Table https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351044#M130172 <HTML><HEAD></HEAD><BODY><P>Strange our seems to be opposite, where publisher loads fine but manually with ODBC it doesn't.&nbsp; So it doesn't seem to be a publisher issue.&nbsp; </P></BODY></HTML> Mon, 14 May 2012 21:25:44 GMT https://community.qlik.com/t5/QlikView/Failed-to-Load-Large-Table/m-p/351044#M130172 2012-05-14T21:25:44Z