QVD cannot load "Field not found"

[Bobbet]

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

[Arthur_Fong]

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

[Bobbet]

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

[Arthur_Fong]

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

[Bobbet]

Hi Arthur,

     All tables have unique QVD names. Kind of weird but I'll also re-check if there is something amiss. 

    Thanks

Bobbet

[Vegar]

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://easyqlik.com/

https://github.com/inqlik/inqlik-tools

[justinphamvn]

Hi,

Please share the Script Load or QVF file attachment ?

Make sure the QVDs file stored with correct Field name  ???

Thanks

Justin.

[marcus_sommer]

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

[Bobbet · Accepted solution]

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