Discussion Board for collaboration related to QlikView App Development.
Hello fellow Qv'ers
Im trying to retrieve the qvw data lineage info from all my QVW but for some reason this data isn't present in the QVW when loading into QV as XML.
The lineage info resides in (XmlSimple, Table is [DocumentSummary/LineageInfo]).
Does anyone know why some qvw's doesn't have this info? I also have a lot of QVW's that also miss the DocumentSummary/FieldDescription and DocumentSummary/TableDescription.
I'm not sure what you mean by
the newest version of QVGD (v2.0.1) is skipping "an empty" QVW files
QVGD 2.0.1 will load the existing metadata in the QVW, even for "empty" QVWs. However, there might not be lineage information for those empty QVWS. In which case you get the best lineage you can from the lineage in the QVDs.
I don't think this lineage in the QVDs includes database connection, though, which I think is your dilemma and question.
Is that correct?
That's exactly what I meant. I'm aware of the QVD lineage information but there is no way to filter those QVDs created by extracting information from database. Any reason why it has been omitted?
QVDs do include the Connection string. If it's not reported in the QGD then perhaps it's just a change that needs to be made to QGD.
Can you send me an example (QVD and/or GovDB that scanned QVDs) where you are seeing (or Not seeing) this connection as you would expect in the lineage metadata? firstname.lastname@example.org
Thanks for your prompt replies.
The screenshot below shows exactly where I'm expecting to see the connection string or at least the information which QVDs were created by extracting information from database.
Am I missing something?
Many thanks in advance for your help.
I'm not sure if you got my last reply. Would you find a minute to have a look, please?
I just noticed that QV12 SR2 no longer writes LineageInfo to the QVD, as QV11 did. Not sure if this is by design or a bug. Either way an unpleasant change.
That would explain why this information is missing in the QVGD_QVDTableLineage data set.
Thanks a mill Rob for your help.
Tyler ( twa) would you advise, please?
I've reported the missing Lineage data issue to Support.
I'll post any status updates here:
QV12 SR2 QVDs missing Lineage Info
If the bug has been reported (thanks rwunderlich!) then we wait for Qlik R&D to fix it. If Rob has a bug # to share you could also report the issue and reference the bug - just to add more reason to fix it sooner than later.