Error during sheet and sheet object metadata collection

[nrichardsonQlarion]

Prerequisites

• [X] Put an X between the brackets on this line if you have done all of the following:
  • Checked that your issue isn't already filed: https://github.com/issues?utf8=✓&q=is%3Aissue+repo%3Aeapowertools/qs-governance-collector

Description

When attempting to load governance for a single app, "Error during sheet and sheet object metadata collection on appId " is thrown. Log files say to "check log for more information" but no further information is available.

Steps to Reproduce

1. Import Sales - SQL.qvf into Sense QMC
2. Run Governance collector against app
3. Governance crashes

Expected behavior: Governance should be able to handle a very basic demo app and load all information

Actual behavior: Governance fails with warning message in logs - "Unable to parse calculated dimension"

Reproduces how often: Every time with this QVF

Versions

Qlik Sense April 2018 Governance installer downloaded 2 July 2018 Win server 2012 R2

Additional Information

Attached logs & QVF

[nrichardsonQlarion]

2018-07-10.QlikSenseGovernance.log

QlikSenseGovernance_6_2_2018_14_34_bdc60ab8-0715-456a-ac9c-9d430f956262.log

Sales - SQL.zip

[Messmann]

I have the same issue with some app's. And when this error comes up nothing more happens and the Harvest App Data stops. To continue harvest new data without selecting the failing app you have to restart the EA Powertools Service.

Is it by any chance possible to let the harvest continue when an app fails ? Somthing like "On Error Resume next" ? and the point out in the log which app's has failed ?

A nice feature could also be to show the App name in the log and not just the ID. Makes it easier finding the failing app for deselecting and troubleshooting purposes.

Regards

Sune

[MustafaHadzi]

I have the same problem. I was looking for where there might be a mistake. And I found workaround. However, this will only be relevant for you if you don't need to know the sheetObject information in the Governance Dashboard.

Comment in the app-sheets.js file line 76-78 (Path -> ..\EAPowerTools\GovernanceCollector\agent\lib)

 /* writeToXML ("sheetObject", "sheetObject", {
        str_layout: objectLayoutArray
 }, appId); */

Now, the load of the Governance Collector is complete.

Try this workaround!

Regards MH