SQL Select failed but no error on load

[#1]

Hi,

I am VERY new to QlikView so this may be something obvious, I have a qvw which has a very simple select which stores the data into a QVD. The qvw is loaded via scheduling on the QMC.

The select should retrieve around 27 million records, and often does, but some days it only picks up 5 million but the load does not end in failure, there has been issues (low memory, running a bit slow) with the SQL Server so I assume it is to do with this, but I am wondering why the load does not fail despite the Select not completing?

We are using QV10 if that makes any difference.

Thanks

K

[Jason_Michaelides]

Are you using a LOAD statement, or just SELECT?  I find using LOAD is more reliable...

[#3]

We are using a LOAD statement prior to the SELECT.