Failed to Load Large Table

[#1]

We have one table that is in mysql and is 10 million records. We re-load the full table every day.  I keep getting an error about failure to read, but I can run the query manually.  Are there any tricks to loading large tables? 

[#2]

How are you reloading the file? Publisher or . . . .
Stephen

[#3]

Publisher at night, but I made a schema change so manually right now.  I tried locally then I tried manually from the server to use more resources and improve stability.  Both gave the same read error. 

[#4]

We have the same problem loading tables from an Microsoft Access. We created a batch file (.bat) and schedule the file to run.

The batch file is:

psexec -u UserName -p Password "c:\Program Files (x86)\QlikView\qv.exe" -r "Q:\Path\QlikViewDocument.qvw"

The problem seems to be that Publisher has a problem reloading with an ODBC connection.

Stephen

[#5]

Strange our seems to be opposite, where publisher loads fine but manually with ODBC it doesn't.  So it doesn't seem to be a publisher issue.