topic Re: Issue with QVD size in App Development

Issue with QVD size

Akshaya — Tue, 19 Apr 2022 12:19:02 GMT

Hi All,

Greetings!

I am stuck with one of the issues as per below:

For one of the application, I took the existing view and i have added one column to it (say View is : XX_MTL_SYSTEM_ITEMS_EXTN_V, and i added column: ATTRIBUTE57 to it) without disturbing any existing written code in view and then i created a QVD from this view.
Now the issue is, the QVD that is already there is bigger in size than the one I am generating.

Things that i tried to resolve this:
1. first i tried full reload using as below: but no luck records were less by around 25k in my QVD

2. Then i tried Incremental reload as below: but no luck records were less by around 25k in my QVD

3. Later i tried first step 1 i.e. Full Load then step 2 i.e. Incremental load...so this time i was able to get the whole data as the records were matching, but now i am not getting the values in the below QVC column that i am supposed to get as per below.

I need help. Please advise on this.

Thanks,

Akshaya

@Anonymous @Qlik3

Re: Issue with QVD size

Akshaya — Tue, 19 Apr 2022 12:21:17 GMT

@MayilVahanan @GeorgePhilips23

Re: Issue with QVD size

durgesh22 — Tue, 19 Apr 2022 14:15:33 GMT

Hi @Akshaya

Re: Issue with QVD size

Akshaya — Tue, 19 Apr 2022 14:48:49 GMT

Hi @durgesh22 ,

I am expecting values like below screenshot for all the rows:

but what I am getting as below, i mean value in only one row.

Re: Issue with QVD size

rwunderlich — Tue, 19 Apr 2022 17:57:14 GMT

I'm guessing that your incremental load is not actually correct. That your existing QVD has duplicate rows.

If you do a full reload, followed immediately by an incremental, your row count should not increase (much -- depending on how fast you are generating new rows).

I would examine your existing QVD to see if it contains duplicate or extra rows.

-Rob

Re: Issue with QVD size

MayilVahanan — Wed, 20 Apr 2022 03:29:28 GMT

Hi Akshaya,

Can you pls post the entire script to verify.
As suggested by Rob, incremental logic might be inaccurate.

Re: Issue with QVD size

GeorgePhilips23 — Wed, 20 Apr 2022 07:41:23 GMT

Hey there, unfortunately I have less idea about Qvd Incremental loads and many more.

Surely together, we can learn more and grow old!

Re: Issue with QVD size

Akshaya — Mon, 25 Apr 2022 15:52:25 GMT

Its done, Thankyou all for your views 🙂

Re: Issue with QVD size

GeorgePhilips23 — Tue, 26 Apr 2022 06:01:49 GMT

It would be great if you mentioned where was the problem and how you solved!

Re: Issue with QVD size

Akshaya — Tue, 26 Apr 2022 13:20:52 GMT

Hi George,
Frankly speaking, the size of my QVD was still less than the actual QVD(not sure why), but the data was matching. and since data was matching so I moved forward neglecting the size difference in QVD size.

Thanks,

Akshaya