Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

Tags (1)
2 Replies
Highlighted
Partner
Partner

SQL Select failed but no error on load

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

Highlighted
Not applicable

SQL Select failed but no error on load

We are using a LOAD statement prior to the SELECT.