Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, everyone!
I have an issue. There are monthly files located in a directory. They are stored by a qvw file but there are 2 tasks for this qvw. One of them is executed more often, no differences else.
And it turned out that a file that was created a year ago has no full amount of data. Its size is about 5-10% from "usual" monthly file size. So there are no any logs from that times and we're trying to figure out what happened. The main question is: is it possible that this file was stored partly? By any reason? Maybe there was a restart of services or another task was trying to get an access or anything else? Or QV only stores files if it is successful and in other cases doesn't store a new version at all?
There is another hypothesis - there were wrong data that accidently came from another source, but then they were fixed and updated, but our main qvd have not updated since then.
I'll be pleased to hear any suggestions!
You could look within the xml meta-data of the qvd (just opening the file with an editor like notepad++ or also qvd-reader like QViewer could provide meta-data to the qvd) to see which process created the qvd and also which were the source-data (only if the data-lineage is enabled). Maybe these or further meta-information may give any hint what happens then.
Quite probably the qvd was created with exact these data and that any manual triggered execution from anybody to fix any other issue or if the source is a database there were many records locked or something similar caused the missing data.
A technically issue during the storing is IMO very unlikely and leads usually either in a direct error which means that nothing was stored or into a corrupt qvd-file.
- Marcus
You could look within the xml meta-data of the qvd (just opening the file with an editor like notepad++ or also qvd-reader like QViewer could provide meta-data to the qvd) to see which process created the qvd and also which were the source-data (only if the data-lineage is enabled). Maybe these or further meta-information may give any hint what happens then.
Quite probably the qvd was created with exact these data and that any manual triggered execution from anybody to fix any other issue or if the source is a database there were many records locked or something similar caused the missing data.
A technically issue during the storing is IMO very unlikely and leads usually either in a direct error which means that nothing was stored or into a corrupt qvd-file.
- Marcus