QVD Refresh issue!!

[#1]

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 ?

[vikasmahajan]

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

[its_anandrjs]

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')

[#4]

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

[#5]

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

[vikasmahajan]

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

Vikas

[its_anandrjs]

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;

[#8]

@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

[#9]

Are you using incremental load for this QVD?

[#10]

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