data incorrect in qvw, but right in qvd

[Anonymous]

Dear,

I found a strange issue

I found that some of the data in my QVW file was incorrect ,but in the qvw's source qvd file,  that data was right .

and  When i reload the qvw,  The problem is gone.

This problem often can not be reproduced, but the frequency of occurrence in a month or so.

Has someone had a similar problem?

I very sure ,When qvw loaded, no other program occupies the QVD file.

thanks a lot !

that my qvw scritp , can any body helps! 

B.R

[swuehl]

Could you describe the issue a bit more detailed?

Have you assured that QVW and QVD were in sync, i.e. the QVW was actually updated with the latest data from the QVD?

Is the data transformed in any way when loaded into the QVW?

How have you compared the data?

[prieper]

in addition to Stefan:

is there any access-restriction active?

[Anonymous]

i can  assured that QVW and QVD were in sync, i.e. the QVW was actually updated with the latest data from the QVD .

in my case,i have found about 5 qvws had that problem, some has transformed  and so don't ,but i don't think the transformed will make that issue.

[Anonymous]

the qvw have  access-restriction active,   we use section access scritp,

but one question ,

the section access scrtip will make data incorrect occasionally?

i think that will make some rows invisible,but i don't understand that will make data wrong.

[prieper]

What do you mean with wrong?
Understand that some records are missing. This can happen due to access-restrictions.

Did you check number of records? Specific sums? On which field (might be NULL in the QVD) there is some restriction?

You may check this easily: when report is refreshed and still open it should show the same data as in the QVD.

Once closed and reopened will cause the access-restriction to become active and you may see lesser data.

[Anonymous]

Dear peter ,thanks for help,

see that ,

that 's my backup incorrect qvw, you can see the column "D5"  that have one row value 'AM2'

and ,that is my qvd data  ,  the column just have one value 'ALL'.

i am very sure that the qvw row count  is as same as qvd.  and  when i  reload , D5 value ""AM2""  turn to "ALL"

[Anonymous]

and it is the last time i  found the issue,   i have see any  similar issue in our other qvw  ,just like  parts of rows, some columns's values mix with other columns .

[prieper]

There is no other calculation involved?

What does

LOAD * FROM MyQVD (QVD)

result in?

[Anonymous]

In this case ,There is no other calculation .

Load * from  QVD(QVD), The  result  is   "ALL"  not  "AM".

and  if  I  reload the QVW agian , The qvw result  turn to "ALL" too .

It looks like it happened randomly.This is the point that bothers me!