Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Missing data on QV reload

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,

Tags (1)
5 Replies

Re: Missing data on QV reload

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


talk is cheap, supply exceeds demand
Not applicable

Re: Missing data on QV reload

Is views have any filters or ?

Re: Missing data on QV reload

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

Not applicable

Re: Missing data on QV reload

Yes in the view there are more rows

Not applicable

Re: Missing data on QV reload

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

Community Browser