SQL Select failed but no error on load

Tue, 24 Apr 2012 16:16:43 GMT

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

SQL Select failed but no error on load

Jason_Michaelides — Tue, 24 Apr 2012 16:19:39 GMT

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

SQL Select failed but no error on load

Tue, 24 Apr 2012 16:23:26 GMT

We are using a LOAD statement prior to the SELECT.

topic SQL Select failed but no error on load in QlikView

SQL Select failed but no error on load

SQL Select failed but no error on load

SQL Select failed but no error on load