14 Replies Latest reply: Dec 3, 2014 3:36 AM by Shane Spencer RSS

    Help setting up Governance Dashboard for Cluster

    Shane Spencer

      I've installed Governance Dashboard on a separate server to my Clustered Production Environment.

      I want to set it up to analyze this cluster but cannot figure out the MultiCluster template.

       

      I've tried using the Help guide but it just gives me an headache:

      http://documentation.qlikview.com/governance-dashboard/1.1/QlikView_help.htm#Create_a_MultiCluster_Script.htm

       

      I've got 2 QVS servers, the log folders are as follows:

      \\gbw05041.hbeu.adroot.hsbc\QlikViewServer

      \\gbw05042.hbeu.adroot.hsbc\QlikViewServer

       

      I've got 1 Publisher server, the logs are as follows:

      \\gbw05040.hbeu.adroot.hsbc\QlikTech\DistributionService

      Repository:

      \\gbw05040.hbeu.adroot.hsbc\QlikTech\ManagementService\QVPR

       

      My documents are on this NAS Share:

      \\hbeu.adroot.hsbc\dfsroot\GB002\corep_mi_qlikview\QlikView_AccessPoint

       

      I've created a new profile directory for the cluster, but do I need one for each QVS Server?

      C:\ProgramData\QlikTech\Governance_1.1\profiles\RCT

       

      Attached is the template. Can someone please help?

        • Re: Help setting up Governance Dashboard for Cluster
          Tyler Waterfall

          Yes, sometimes I wonder who made these instructions

           

          A couple of comments:

          • One profile for each Server/Publisher (or just Server). So, if you have 2 QVS (non-clustered) running, you will have 2 profiles. You can put the Publisher with one of the servers.  Below is what I think you;ll need.
          • For each profile, you need to create a profile folder. You have one (RCT). But you will need one for the 2nd QVS profile, one for the Aggregator, and one for the global aggregator.  Copy the template profile folder for this and rename it.  (You will end up with 4 profile folders). For this post, I will call the additional profiles: SERVER_No2, Aggregator, Global. You will need to use the same filepath in the template as the name of the profile folders.
          • Currently each profile must include QVW/QVD files to scan (i.e. you can't just scan QVS logs in a profile.).  Due to this, I point the 2nd profile to scan the RCT profile folder (please note the bullet below about using UNC) and I exclude the QVX_LastRun and QVD_Historical folders -- no need to scan these files.
          • You are referencing C:\ for the profile folder -- is this the local C:\ of the machine that will reload the Dashboard?  If not - or if the Governance Dashboard might reload on different Distribution service servers, please use UNC path instead of C:\.
          • Other housekeeping: remove all 'unused' Server and aggregator variables, as described below.
          • Publisher DateTime format - refer to doc on this -- you can find this in the TaskResults xml files.

           

          //Here's what the script will look like:

           

          // 1. How many distinct "Servers" (Source Document folder(s) and standalone or clustered Server/Publisher) will be scanned?

          SET vHowManyServers = 2;    // two distinct QVS (not-clustered)

           

          // 2. How many Aggregators are needed?

          SET vHowManyAggregators = 1;    // 1 aggregator per 5 profiles

           

          //3. How many years of server log history is needed?

          SET vHistoricalYears = 1;          //  Years back from today of server log history.

           

          //// "SERVER" Configuration

          // Server 1

          SET vMultiCluster_ProfilePath_1 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\RCT';

          SET vMultiCluster_FilePath_1a = '\\hbeu.adroot.hsbc\dfsroot\GB002\corep_mi_qlikview\QlikView_AccessPoint';

          SET vMultiCluster_ServerPath_1 = '\\gbw05041.hbeu.adroot.hsbc\QlikViewServer';

          SET vMultiCluster_HasAudit_1 = 1;          // Do you have audit logging set in QMC?

          SET vMultiCluster_PublisherPath_1 = '\\gbw05040.hbeu.adroot.hsbc\QlikTech\DistributionService';                // Has Publisher?: Log Path

          SET vMultiCluster_QVPRPath_1 = '\\gbw05040.hbeu.adroot.hsbc\QlikTech\ManagementService\QVPR';

          SET vMultiCluster_PubDateTimeFormat_1 ='CCYY-MM-DD H*24:MI:SS';      // What's your datetime format?

           

          // Server 2

          SET vMultiCluster_ProfilePath_2 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\SERVER_No2';

          SET vMultiCluster_FilePath_2a = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\RCT';

          SET vExcludeFiles_or_Folders_2a = 'QVX_LastRun|QVD_Historical';  

          SET vMultiCluster_ServerPath_2 = '\\gbw05042.hbeu.adroot.hsbc\QlikViewServer';

          SET vMultiCluster_HasAudit_2 = 1;

          SET vMultiCluster_PublisherPath_2 = '';

          SET vMultiCluster_QVPRPath_2 = '';

          SET vMultiCluster_PubDateTimeFormat_2 ='CCYY-MM-DD H*24:MI:SS';  // What's your datetime format?


          // REMOVE all the other servers in the template -- Server 3 - Server 6


          /// AGGREGATOR Configuration

          //// Start with 101 and increment sequentially (do not skip numbers!)

           

          // Aggregator 1

          SET vMultiCluster_ProfilePath_101 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\Aggregator';

          SET vMultiCluster_FilePath_101a = '$(vMultiCluster_ProfilePath_1)';

          SET vMultiCluster_FilePath_101b = '$(vMultiCluster_ProfilePath_2)';

          SET vClusterName_101a = 'gbw05041';    // Add unique name for each "cluster"

          SET vClusterName_101b = 'gbw05042';

           

          // REMOVE the other Aggregator 2 from the the template


          ////==================================

          ////  GLOBAL Aggregator Configuration

           

          // GLOBAL Aggregator

          SET vMultiCluster_ProfilePath_201 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\Global';

          SET vMultiCluster_FilePath_201a = '$(vMultiCluster_ProfilePath_101)';

          • Re: Help setting up Governance Dashboard for Cluster

            Tyler,  I would like some clarification please.

             

            How can I tell if my environment is “clustered” or “non-clustered”?

             

            My environment seems to be the same as Shane has described in his post.  I’ve got QVS log files (Audit, Events, Performance, Sessions) being generated on 2 servers (QV1, and QV2).  The QV1 server has everything, while the QV2 server has only QVS.  There is a common Documents share being used.

             

            In your response you make reference to “having 2 QVS (non-clustered) running”.  So based on what Shane has described, dose he have a “non-clustered” environment?

             

            If my environment is clustered what type of scan profile do I need to use?

             

            Thanks for your time.

            Bob

              • Re: Help setting up Governance Dashboard for Cluster
                Tyler Waterfall

                rasnyder - You can tell in one of two ways:

                1) In QMC > System > QVS folder, click on the QVS in question and click on "General". You will see an entry for each QlikView Server

                2) See how many QVS log folders there are. There is just one location (folder) per QlikView Server (single node or clustered). So, if you have two separate QVS folder (server A and server B), then I would say you have an non-clustered, two QVS environment (which would require the "multi-cluster" script in GovDB).

                  • Re: Help setting up Governance Dashboard for Cluster

                    Tyler,

                     

                    Per point 1) of your response, see the screen print below.

                     

                     

                    It would appear that I have a clustered environment.  Yet I have each QVS writing to separate locations, local to each QVS.

                     

                    Is is possible that my "clustered' environment was/is setup wrong?

                    Should the "Log Folder" in the screen print below be set/changed to a location common to both QVS's?

                     

                     

                    As it is now, each QVS has a local Log Folder as is set in the screen print'

                     

                    I still plan to use the "multi-cluster" script as described above in this discussion unless you now advise different.

                     

                    Thanks...

                      • Re: Help setting up Governance Dashboard for Cluster
                        Tyler Waterfall

                        Interesting. I would have said to write the QVS logs to the same folder on a share somewhere easily accessible by both QVS servers.

                        If you are getting the logs sent to two separate servers then I would use the Muli-cluster config script.

                        Your other option would be to update where the two QVS logs are written. (You'd probably want to move the existing logs from both servers to the new location.)  Talk it over with the Qlik admin of course!

                  • Re: Help setting up Governance Dashboard for Cluster

                    That's what I was thinking.

                     

                    Thanks again for your time.

                    Bob