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.
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
@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