Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sunillamba
Contributor
Contributor

Data Lost Issue because of QVD row optimized

Dear Team,

When initially I am fetching data from SAP, I have around 15000 records in the qvd file. But when i am fetching data from that qvd file and storing into another qvd file. I am left with only around 9000 records. I am not any changes during this process. The major reason which was highlighted is "qvd row optimized", which resulted in  loss of data.

Request you to look into this and suggest suitable solution for the same.

Looking forward for your support.

Thanks

Sunil

 

 

3 Replies
pablolabbe
Luminary Alumni
Luminary Alumni

Hi Sunil,

  Please check the following:

  Do you have enough space to store the new QVD ?

  Do you have any where clause in the LOAD Statement  from the extracted QVD ? 

  Are you using distinct clause in the LOAD statement ?

  Maybe you have some special character stored in a column and this breaking the store process. Try to select a few columns a check if with only these columns the QVD is stored with all rows.

 Try to disable the optimization adding a where clause with only this criteria 1=1. here is an example:

  LOAD 

     Field1

FROM FILE.QVD (qvd) 

Where 1=1;

Hope it helps !

 

  

Sunillamba
Contributor
Contributor
Author

Dear Team,

Thanks for the suggestion.

But the provided suggestion are not helping to get of the issue. Still some
data get lost due to row optimization.

Looking forward for your support.
marcus_sommer

How do you check the number of records?

- Marcus