[with documented fix]: Extraneous single quotes cause failure in reload of Governance QVD Generator in Sense 3.2

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

Extraneous single quotes cause failure in reload of Governance QVD Generator; reload of Governance QVD Generator fails with error "file not found" in Qlik Sense 3.2.

Luckily, manual fix is possible: On LoopResouresAccessControl and LoopAppObjectsAccessControl tabs of the Governance QVD Generator data load script, remove extraneous single quotes.

Manual fix instructions: On the LoopResourcesAccessControl tab, replace all instances of this line: FROM ['$(file)'] with this line: FROM [$(file)] This change should be made on lines 24 and 31 of the LoopResourcesAccessControl tab.

On the LoopResourcesAccessControl tab, replace all instances of this line:
            store "$(stagingTable)" into ['lib://qsgc-qvds/$(stagingTable).qvd'] (qvd);
with this line:
            store "$(stagingTable)" into [lib://qsgc-qvds/$(stagingTable).qvd] (qvd);               
This change should be made on line 56 of the LoopResourcesAccessControl tab.

On the LoopAppObjectsAccessControl tab, replace all instances of this line:
            FROM ['$(file)']
with this line:
            FROM [$(file)]
This change should be made on line 48 of the LoopAppObjectsAccessControl tab.

On the LoopAppObjectsAccessControl tab, replace all instances of this line:
            store "$(stagingTable)" into ['lib://qsgc-qvds/$(stagingTable).qvd'] (qvd);
with this line:
            store "$(stagingTable)" into [lib://qsgc-qvds/$(stagingTable).qvd] (qvd);               
This change should be made on line 72 of the LoopAppObjectsAccessControl tab.

Steps to Reproduce

Attempt to reload the Governance QVD Generator in Qlik Sense 3.2

Expected behavior: Reload succeeds.

Actual behavior: Reload fails (until the fix is applied).

Reproduces how often: 100%

Versions

QS Governance 2.1.1 Qlik Sense 3.2

The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. The task qsgc-Refresh-Governance-Dashboard exists in the repository, therefore, it will not be created. The task qsgc-Generate-Governance-QVDs exists in the repository, therefore, it will not be created. d3dynamictreelayout-qs exists in the QMC, therefore, it will not be uploaded. DataLineage exists in the QMC, therefore, it will not be uploaded.

how to fix it

eapowertools-archive / qs-governance-dashboard