Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
jason_michaelid
Not applicable

SQL Select failed but no error on load

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

Not applicable

SQL Select failed but no error on load

We are using a LOAD statement prior to the SELECT.