Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Marcio_Campestrini
Specialist
Specialist

Problems with Governance Dashboard 2.0

Hi!

I'm trying to use the GD 2.0.2 but when it goes to the expressions it crashes.

As far as I see it doesn't create the SOE table on the first environment scan.

Márcio Rodrigo Campestrini
1 Solution

Accepted Solutions
Marcio_Campestrini
Specialist
Specialist
Author

Hi Tyler

I've changed the configuration to set all the folders with QVWs and the GD worked.

I'm closing this topic.

Márcio Rodrigo Campestrini

View solution in original post

10 Replies
Tyler_Waterfall
Employee
Employee

Can you post a screen shot of the "Scan Details" page of the app please? Let's check how many QVWs were scanned.

Thanks.

Marcio_Campestrini
Specialist
Specialist
Author

Hi Tyler

See attached

Márcio Rodrigo Campestrini
Tyler_Waterfall
Employee
Employee

No QVWs were loaded, though I'm not sure if QVWs were not found or were not able to be loaded (if that makes sense).

I've not used a file path with a . in it as you have and am wondering if that is giving you grief. However, it is finding QVDs, so this is not likely the culprit.

Can you confirm you have QVWs in c:\Qlkview\1.Deploy folder?

Marcio_Campestrini
Specialist
Specialist
Author

Tyler

There's no QVWs in this folder, but in a subfolders. I've configured the prior version like this and it worked.

Márcio Rodrigo Campestrini
Marcio_Campestrini
Specialist
Specialist
Author

Hi Tyler

I've changed the configuration to set all the folders with QVWs and the GD worked.

I'm closing this topic.

Márcio Rodrigo Campestrini
Anonymous
Not applicable

It looks like with this version you have to explicitly list EVERY path that contains QVW files.

e.g. if you use the configuration script. set the variable:

LET vInputPath = '\\Server\QV\PATH1 | \\Server\QV\PATH2 | \\Server\QV\PATH3';

Where as in the past we could just refer to the top node of a folder tree and GD would scan the complete tree under that. Like this:

LET vInputPath = '\\Server\QV';

If you use subfolder you'll have to list them individually.

Bit of a retrograde step that one I think.)

Tyler_Waterfall
Employee
Employee

Paul -

I see no reason you couldn't point to '\\Server\QV', assuming it is not a UNC root folder.

What's not clear to me is whether having a "." in the filepath causes an issue.

Anonymous
Not applicable

Tyler, I have a bug for you.

In SUB fileScan , SUB fileSearch. In the loop that handles subfolders of a root, there is no code to handle when there are no exclusions (which is actually probably the most common scenario).

Here's the code, shortened to emphasise.


for each fldr in DirList('$(root)'&'\*')
 
  IF NumExclusions > 0 THEN
    ...
    IF exclusionsFound > 0 then
      ...
    ELSE
      ...
    ENDIF

  // No ELSE here to handle when (NumExclusions > 0) is NOT true

ENDIF

next fldr


I have added that non existent ELSE to my Governance Dashboard 2.0.2 using the same code as the other ELSE just above to load more FilePaths :

ELSE
   Concatenate (FilePaths)
   Load '$(fldr)' as %FilePath, RowNo() as %FilePathNumber autogenerate(1);

   CALL fileSearch ('$(fldr)',$(n))


and it now works fine and scans all my subfolders from my configured PATH.

Tyler_Waterfall
Employee
Employee

Thanks paul.w.routledge‌ for reporting and then suggesting a fix for a bug in the app.

I will add this to the 2.0.3 bugfix list.