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

[rwunderlich]

The bugid is QV-7088.  But I just discovered the solution  is to turn on the "AllowDataLineage" in the easter egg or settings.ini.

The default for AllowDataLineage is 0. It apparently has no effect in QV11.2, but must be set on in QV12 to get <LineageInfo> elements in QVDs.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Hello Rob ( rwunderlich‌ ),

Thank you for escalating this issue.

I've tried to add AllowDataLineage=1 to the Settings.ini file located here: C:\ProgramData\QlikTech\QlikViewServer, but it doesn't seem to work. Would you know the place it should be placed for lineage data to be added into the qvd files being created during the Distribution Service reload tasks, please?

Many thanks in advance for your help.

Best regards,

Janusz

[Anonymous]

Hello Tyler ( twa‌ ),

Would you have an update on the issue mentioned within Rob's last comment, please?

Would there be a fix included to the next QGD release, please?

Many thanks,

Janusz

[Anonymous]

Hi All,

According to QlikMarket (screenshot below), QlikView 12  is not supported by QGD v2.0.1 yet?

Question: When new version of QGD for QV12 is planned to be released, please?

Kind regards,

Janusz

[Tyler_Waterfall]

Governance Dashboard 2.x is compatible with QV 12.x.

The Qlik Market page needs updating.

[rwunderlich]

Janusz,

The location for the settings.ini file for server reloads is:

C:\Windows\system32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Hi Tyler,

Would you know when the bugs mentioned in this post are going to be fixed, please?

Thanks,

Janusz

[Tyler_Waterfall]

rwunderlich‌ - I am not seeing any "Connection String" in QVD metadata, just the "CreatorDoc" which is the QVW that generated the QVD. Am i missing something? (In Desktop, there is no "enable lineage", correct? Just in server?

Thanks!

janusz.twardziak‌ - In answer to your question, Governance Dashboard pulls the available metadata from the QVDs at present and is limited to what lineage data is present in the QVD. (That is, unless I have missed something!)

[rwunderlich]

The Connection String is in the <LineageInfo><Discriminator> element.

In QV12, AllowDataLineage=1 must be set for the Desktop. You can set it using the easter egg or in

"C:\Users\uid\AppData\Roaming\QlikTech\QlikView\Settings.ini"

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

[Anonymous]

Hello Tyler ( twa‌),

Thank you for your reply.

I will try to explain what in my opinion is missing from QlikView Governance Dashboard 2.0.1 by providing this very simple example.

Let's have Test Loader.qvw that connects to a database, sends SQL query in order to extract data, saves the result data set into .qvd file and dropes the table from memory at the end. So, after reload the loader's data model is empty, no tables.

Now, when I open Fiscal_Month.qvd and check the Lineage information this is what I see:

Now, when I reload Governance Dashboard 2.0.1 only for this folder, then the above QVD's lineage information is missing. The QGD's Profile Directory looks like that:

As you can see QVWTableLineage qvd file is missing that normally would include that lineage information. If I open QVDTableLineage qvd file still no lineage information included.

I can understand why QVWTableLineage qvd is not generated, but why there is no Lineage information included into QVDTableLineage?

Many thanks,

Janusz