topic Missing rows after reopening document in QlikView

Missing rows after reopening document

ManuelRühl — Mon, 19 Oct 2009 12:49:05 GMT

I have built a huge table with different information like sales, purchases and stock.

The tables are linked with "concatenate load".

So I get round about 9.000.000 records.

Everything works fine, but if I save the document, close it and reopen it, 2.000.000 records are missing.

And even the linked table with information about the products now contains 0 rows,

but if I reload the qvw everything it's fine again until I save,close and reopen ...

I'm using 8.50.6299.5.

Other qvw-files work witout any problems with nearly the same tables.

Missing rows after reopening document

Mon, 19 Oct 2009 13:09:42 GMT

Having 9 Million records in the QV table should not be the exact problem. I have applications with almost the same volume of records. This should cause only the out of memory error in the clientsduring refresh/or in the server during reload if there is not enough memory.

How do you identify the recorda are missing? If by a count, may be because of the duplicates. Records may not be actually missing. Check the QVW file size before and after you save and see whether there is a difference. Try for the distinct /non-distinct counts on major key fields.

--Arun

Missing rows after reopening document

ManuelRühl — Mon, 19 Oct 2009 13:44:24 GMT

If i press Ctrl+T and check the amount of rows, I can see that rows are missing.

And some fields are simply empty, like the product-info-table.

Why should there be not enugh memory. I can load the qvw completely,

only if i reopen it I have got problems.

Missing rows after reopening document

Mon, 19 Oct 2009 14:34:34 GMT

Can you take a backup of the QVW and try the exercise with a minimized set of data (probaly by running in the debug mode with few hundreds of data) and check whether the issue can be replicated?

One clarification : Are you loading the product-info and such tables directly from the source or from QVD?

--Arun

Missing rows after reopening document

ManuelRühl — Mon, 19 Oct 2009 17:03:19 GMT

it doesnt matter how many records i load ... even if i choose 1000, there

are records missing after reopening ....

everythung is loaded from qvd.

Missing rows after reopening document

biester — Mon, 19 Oct 2009 17:15:29 GMT

Just to be sure check if dynamic data reduction is envolved in some way. Else, I couldn't think of a plausible explanation and would give it to support.

Rgds,
Joachim

Missing rows after reopening document

Mon, 19 Oct 2009 17:30:36 GMT

I do agree to Jo. This is interesting! Finally, if you copy the scripts to a new QWV and relaod , then also same issue? Also, make sure the resident table usage (if any ) are corerct.

Good luck,

--Arun

Missing rows after reopening document

ManuelRühl — Thu, 22 Oct 2009 13:21:58 GMT

Thank You, that was my problem !