topic Re: Missing data on QV reload in QlikView

Missing data on QV reload

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

We have recently (from about 2-3 weeks) started facing a new problem.

We are loading about 1.9 million records from one of our database views into a Load with out any conditions. But recently I have noticed that it is fetching less than half of the records only. Even in the log files it will say 90000 records loaded. There is no error and the load always completes successfully.

Our version of QV is 11.20.12048.0 SR3

Has anyone else faced similar issues? Can it be related to Publisher memory or CPU?

Any help will be appreciated.

Thanks,

Re: Missing data on QV reload

Gysbert_Wassenaar — Thu, 20 Aug 2015 16:33:36 GMT

Can you upload the script of the document and the document log file?

Re: Missing data on QV reload

Thu, 20 Aug 2015 20:17:55 GMT

Is views have any filters or ?

Re: Missing data on QV reload

Peter_Cammaert — Fri, 21 Aug 2015 09:20:00 GMT

You're probably using a SELECT statement to read records from your database view.

If you launch the same SELECT in your Database Management tool (Oracle SQL Developer, SQL Server Management Studio or whatever command line tool you have at your disposal), do you get more rows?

Peter

Re: Missing data on QV reload

Fri, 21 Aug 2015 09:42:19 GMT

Yes in the view there are more rows

Re: Missing data on QV reload

Fri, 21 Aug 2015 09:42:57 GMT

Yes view is based on the underlying tables with conditions. But in QV we are selecting all of the records in the view