topic Re: QVD Refresh issue!! in QlikView

QVD Refresh issue!!

Mon, 26 Jan 2026 18:19:17 GMT

After QVW and QVD are deployed into server, When we refresh the new data few columns value does not appear but using this same new QVD in new QVW it works fine it populates all the values. Why is it creating problem ? because of which i have to re develop my whole project and deploy it again.

Is it every month i have to do this exercise ?

Re: QVD Refresh issue!!

vikasmahajan — Tue, 06 May 2014 05:28:38 GMT

Hii,

You need to check where qvd's are actually stored in your applications whether it is generating properly ?

Make best practice to have a folder structure

Sr No	Folder Name	Description of Folder (Contents)
1	Extrator	All Scripts to get data from data source and make qvds ( QVD GEN)
2	QvDs	All applications qvd's will be stored inthis folder
3	Excels and Other Support Files	All Excels Files and supporting files required for applications will be stored inthis folder
4	Media and Images	All Images , Logos , Media Files will be stored into this folder
5	Working Folder	Current Development qvw's will be copied here inthis folder
6	Final Reports	All Finilised Qvw's Will be copied here and mapped to Access Points of Qlikview
7	Connection Strings	All Connections Strings will be copied with starting Application Name_Connectionstring
8	Mail Distribution	Here We will store all qvw's files which we will be scheduling in publisher

All Qvw's please check folder path and make sure that the paths are proper.

Hope this help you.

Vikas

Re: QVD Refresh issue!!

its_anandrjs — Tue, 06 May 2014 05:30:17 GMT

When creating the QVD use NoOfFields() function to check how many fields are fetch for cross check may be some where due to any logic or join it is not seen use it like

LET vNoofFields = NoOfFields('TableName')

Re: QVD Refresh issue!!

Tue, 06 May 2014 05:41:41 GMT

Hi Vikas,

Thanks for replying!!

Yes i do follow proper folder structure. QVD generation is successful.

The problem is it creates the QVD and is also fetches all the columns. But for few column values are not populating.

For EG:

Old QVD : Country (Column Name)- India, Singapore , Australia

New QVD : Country (Column Name) - India , Australia ( It does not populate Singapore)

But the New QVD if i link it with new QVW it works fine, It does not work with Older QVW

Re: QVD Refresh issue!!

Tue, 06 May 2014 05:42:42 GMT

Hi Anand,

Thanks for replying!!

All the columns are populated:

The problem is it creates the QVD and is also fetches all the columns. But for few column values are not populating.

For EG:

Old QVD : Country (Column Name)- India, Singapore , Australia ( Values)

New QVD : Country (Column Name) - India , Australia ( It does not populate Singapore)

But the New QVD if i link it with new QVW it works fine, It does not work with Older QVW

Re: QVD Refresh issue!!

vikasmahajan — Tue, 06 May 2014 05:50:43 GMT

tHEN THERE IS PROBLEM IN YOUR SQL SCRIPT you need to check it or attach if possible.

Vikas

Re: QVD Refresh issue!!

its_anandrjs — Tue, 06 May 2014 05:56:35 GMT

May be it is due to some logic i believe you do one thing at the same time cross check the raw source data there is that missing value is available or not if available so may be due to some logic like left join or right join the values missing due to keys. so check with raw data for cross check or you can use set ErrorMode in the application like put this code in the script like

Set ErrorMode=0;

Re: QVD Refresh issue!!

Tue, 06 May 2014 06:28:04 GMT

@vikas : I use the same SQL Script everytime to create the QVD. What i am not able to find is why its not working on older QVW. And the same QVD if i use to create new project or QVW the logic works. So problem is with QVW is my take Do i need to enable or disable any option at the time of refresh

Re: QVD Refresh issue!!

Tue, 06 May 2014 07:34:48 GMT

Are you using incremental load for this QVD?

Re: QVD Refresh issue!!

Tue, 06 May 2014 07:38:29 GMT

No i don not use incremental load. I just use initial load each time i create new qvd. I do not insert the the data into QVD

Re: QVD Refresh issue!!

Peter_Cammaert — Tue, 06 May 2014 07:40:25 GMT

Data Reduction thru Section Access?

Re: QVD Refresh issue!!

Tue, 06 May 2014 07:44:43 GMT

No . I do not have sectional access at all for my project

Re: QVD Refresh issue!!

Tue, 06 May 2014 07:46:08 GMT

As Anand mentioned, try using ErrorMode = 0.

Some more thoughts:

>> Is the OLD QVW, pointing to same database.

>> Try commenting the whole script and Reload the QVW, and then uncomment and reload again.

>> Compare script of OLD QVW and New QVW.

>> Create copy of OLD QVW and then try.

>> Does this happen everytime?

Seems like OLD QVW might have got corrupted.

Thanks,

Angad

Re: QVD Refresh issue!!

Peter_Cammaert — Tue, 06 May 2014 07:46:46 GMT

You can use Dmitry's QViewer to inspect the data that's really in the QVD (visit easyqlik.com, the free version loads 50000 records). Do not rely on QVWs as they may have other factors influencing data availability.