- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QVD cannot load "Field not found"
Hi!,
I encounter a "Field not found" error when I load my QVDs but when I re-load my raw files first, the reloading of the QVDs are successful.
How can I fix this?
Thanks
Bobbet
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Marcus,
Good morning!
I finally found the root cause. The QVD was being overwritten by another script (Silly me 🙂 )
Thanks for the inputs.
Bobbet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Try to check whether the QVD you stored is in the correct QVD loading path,
, also the name of the QVD
lastly check whether the QVD is updated after the script execution to store QVD is completed.
Thanks and regards,
Arthur Fong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Arthur,
Thanks for the recommendations. I've re-checked the names and the path. They are all good. This happens for one QVD only and the rest of the QVDs in the script are being loaded successfully.
My observation is that when I re-load the extraction of the raw files from our database, the loading of this particular QVD is also successful.
Bobbet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I think you had stored 2 or multiple tables into the same QVD name, which will lead to overwriting of QVD files.
Do check in your script if there is any tables sharing the same name before storing into QVD.
Thanks and regards,
Arthur Fong
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Arthur,
All tables have unique QVD names. Kind of weird but I'll also re-check if there is something amiss.
Thanks
Bobbet
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
When error like this occurs I tend could to manually check the content of my QVD using a QVD preview or QVD metadata tool.
The QViewer, currently developed by @rwunderlich , is an good alternative for both data and metadata. If you are using Sublime text editor then you can also be helped with viewing the meta data using the inQlik package.
https://github.com/inqlik/inqlik-tools
Qlik Community MVP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please share the Script Load or QVF file attachment ?
Make sure the QVDs file stored with correct Field name ???
Thanks
Justin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Your qvd might be overwritten from any other qvw (yours or from a different user maybe the server). By checking the filetime you could identify if it was your qvw which has written the file and by opening the qvd with an editor like notepad++ you could also see just at the beginning of the xml when and from which user the qvd was created.
- Marcus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Marcus,
Good morning!
I finally found the root cause. The QVD was being overwritten by another script (Silly me 🙂 )
Thanks for the inputs.
Bobbet