Missing rows after reopening document

[ManuelRühl]

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.

[#2]

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

[ManuelRühl]

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.

[#4]

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

[ManuelRühl]

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

are records missing after reopening ....

everythung is loaded from qvd.

[biester · Accepted solution]

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

[#7]

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

[ManuelRühl]

Thank You, that was my problem !