Governance Dashboard on external Shared Storage

[Anonymous]

Hi

We run a QlikView 11SR2, 11.0.11414.0, Cluster with resilient external Shared Storage for all the QV system data, QVW's, QVD's etc...

Currently we have the QlikView Governance Dashboard Beta 1.0. installed and working on a single node of the Cluster in folder C:\ProgramData\QlikTech\Governance_1.0Beta as recommended in document QlikView Governance Dashboard Beta - Pre-Installation Notes http://community.qlik.com/docs/DOC-3546.

I'd like to place it on the external Shared Storage via a unc path, benefit from the resilience against node failure that will provide.

Is there any reason not to do so, or any pitfalls to beware ?

Best Regards, Bill Markham

[Michael_Tarallo]

Hello Bill - here are some thoughts.

QlikView Governance Dashboard (qvw) uses file paths, QlikView script and its QlikView Expressor engine to access scan an extract from a variety of QlikView related files - (QVDs, QVXs, QVWs and logs). If installed on a shared storage device and the files are accessed via UNC it may cause some performance related problems depending on where the files are and how big they are when attempting to scan an extract the metadata from them.

There is also a known issue where if using UNC - you must have a sub-folder appended to the share when configured in the QlikView Governance Dashboard.

So for example if your share folder name is folder1 pointing to c:\QVDocuments\sub-folder1
then \\machine\folder1 - will not work for the QlikView Governance Dashboard configuration.

Make sure the UNC share is mapped for example to c:\QVDocuments and then when you use it in the QlikView Governance Dashboard - it is used as \\machinename\sharename\sub-folder1

Please post back here to let us know what you found and how you did.

Regards,

Mike T

[mountaindude]

I just installed Governance Dashboard 1.0 (=GD), and the UNC issue is still there. Seems it can be fixed, as noted buy Michael, by sharing a folder higher in the directory hierarcy (on the server/disk where the the logs reside), and then referring that directory from GD's config tab.

Also, scanning large files over the network is a bad-bad-bad idea, in my experience. Having tried a full scan of many 10s (probably 100+ GByte, actually..) of GByte of QVWs and QVDs, it just isn't practical. After watching lots of network traffic passing in the process monitor, it was time to cancel the experiment and go for a local installation on the server where the QVW/QVDs reside.

[Tyler_Waterfall]

Hello Goran,

I'm glad you are working with the 1.0 GA Dashboard.

The workaround is still there for UNC root folders, as you've described and as noted in the Release Notes (GOV-122).

Concerning the delay in scanning large files over the network, I agree that trying to read large files over the network with any tool is not optimal, so a local install might be better.  However, if you have large log files - namely years and years of session logs - that will take longer to scan.  If this is the case, you might consider paring down your log files (save copies first!) or just keep more recent (and relevant) sessions history logs in the QlikViewServer folder.

[mountaindude]

Yes, the UNC workaround does work, true.

Re large log files, it didn't seem to be much of a problem scanning a years worth of log files over the network. Took a few minutes, but nothing too bad.

[Tyler_Waterfall]

All,

If you run into the UNC root folder error, try using the following:

\\servername\e$\sharedfoldername

where e represents the specific drive letter on the server (servername) where your target folder (sharedfoldername) resides.

[jazzsran]

Hi Tyler,

I am using the same way but it's still failing for me.

My path is(giving servername in the first one):

\\<servername>\D:\QlikView\QlikViewFiles\SourceDocuments

Error:

File directory does not exist, cannot be reached, or is empty.

Please validate path: \\<servername>\D:\QlikView\QlikViewFiles\SourceDocuments

NOTE: If you are referencing a UNC share, you must point to a subfolder within the UNC root and not directly to the root folder.

Thanks,

Jaspreet

[Tyler_Waterfall]

Use D$ (dollar sign) instead of 😧 (colon).

\\<servername>\D$\QlikView\QlikViewFiles\SourceDocuments

[Anonymous]

hello what should i wait if i am using $ and the path has been confirmed by myself and the security has been configured well . Thanks in advance