QVW LineageInfo missing

[blaise]

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.

Br Johan

[Tyler_Waterfall]

janusz.twardziak‌ -

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?

[Anonymous]

Hi twa‌

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?

Many thanks,

Janusz

[rwunderlich]

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.

-Rob

[Tyler_Waterfall]

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? twa@qlik.com

[Anonymous]

Hello twa‌,

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.

Best regards,

Janusz

[Anonymous]

Hello twa‌,

I'm not sure if you got my last reply. Would you find a minute to have a look, please?

Thanks,

Janusz

[rwunderlich]

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.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

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?

Best regards,

Janusz

[rwunderlich]

I've reported the missing Lineage data issue to Support.

I'll post any status updates here:

QV12 SR2 QVDs missing Lineage Info

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Tyler_Waterfall]

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.