2 Replies Latest reply: Apr 24, 2012 12:23 PM by kmiles83 RSS

    SQL Select failed but no error on load

      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