Problems with Governance Dashboard 2.0

[Marcio_Campestrini]

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.

[Tyler_Waterfall]

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]

Hi Tyler

See attached

[Tyler_Waterfall]

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]

Tyler

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

[Marcio_Campestrini · Accepted solution]

Hi Tyler

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

I'm closing this topic.

[Anonymous]

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]

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]

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]

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.