3 Replies Latest reply: May 8, 2015 11:44 AM by Paul Tribe RSS

    Multi Server configuration - External variables include file cannot be found

    Paul Tribe

      Hi, something is not right in my configuration and receiving the error mentioned in the subject.

      any ideas on why the external variables are not being found?

       

      1) Governance Dashboard is installed on the single publisher server CCV752

      2) location of the QVW is the default: C:\ProgramData\QlikTech\Governance_1.1\profiles\default

      3) There are two servers with QVS installed

      4) the multi cluster configuration file is located in the same folder as the QVW. "MultiCluster_UserConfig_Template.txt"

      5) configuration tab in QVW is set to use the multi cluster config using relative path

      6) shares are accessible on the QVS servers listed in the config file.

       

      The multi cluster config file contents with comment lines stripped out

       

      SET vHowManyServers = 3;

      SET vHowManyAggregators = 1;

      SET vHistoricalYears = 1;          

      // SERVER 1 CCV003 which has QVS and QMS services
      SET vMultiCluster_ProfilePath_1 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\INT1'; // Profile Directory on Config page
      SET vMultiCluster_FilePath_1a = 'G:\Qlikview\Documents\Public'; // this is pointing to a subdirectory in the 'qlikview' share
      SET vMultiCluster_FilePath_1b = '';
      SET vMultiCluster_FilePath_1c = '';
      SET vMultiCluster_FilePath_1d = '';
      SET vMultiCluster_FilePath_1e = '';
      SET vExcludeFiles_or_Folders_1a = '*issue.qvw';
      SET vExcludeFiles_or_Folders_1b = '';
      SET vExcludeFiles_or_Folders_1c = '';
      SET vExcludeFiles_or_Folders_1d = '';
      SET vExcludeFiles_or_Folders_1e = '';
      SET vMultiCluster_ServerPath_1 = '\\CCV003\QlikTech\QlikViewServer';    // Has Server?: Log Path
      SET vMultiCluster_HasAudit_1 = 1;             // Has Audit logging?:1 = Yes, 0 = No.
      SET vMultiCluster_PublisherPath_1 = '';    // Has Publisher?: Log Path
      SET vMultiCluster_QVPRPath_1 = '\\CCV003\QlikTech\ManagementService\QVPR';    // Repository Path
      SET vMultiCluster_PubDateTimeFormat_1 ='CCYY-MM-DD H*24:MI:SS';

       

      // Server 2 CCV004 which has QVS and QMS services
      SET vMultiCluster_ProfilePath_2 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\INT2'; // Profile Directory on Config page
      SET vMultiCluster_FilePath_2a = 'G:\Qlikview\Documents\Public'; //both QVS servers point to the same folder on the publisher server 'Qlikview'.
      SET vMultiCluster_FilePath_2b = '';
      SET vMultiCluster_FilePath_2c = '';
      SET vMultiCluster_FilePath_2d = '';
      SET vMultiCluster_FilePath_2e = '';
      SET vExcludeFiles_or_Folders_2a = '*issue.qvw'';
      SET vExcludeFiles_or_Folders_2b = '';
      SET vExcludeFiles_or_Folders_2c = '';
      SET vExcludeFiles_or_Folders_2d = '';
      SET vExcludeFiles_or_Folders_2e = '';              // This represents the "Excluded Files | Directories" input
      SET vMultiCluster_ServerPath_2 = '\\CCV004\QlikTech\QlikViewServer';
      SET vExcludeFiles_or_Folders_2b = '';
      SET vExcludeFiles_or_Folders_2c = '';
      SET vExcludeFiles_or_Folders_2d = '';
      SET vExcludeFiles_or_Folders_2e = '';    
      SET vMultiCluster_HasAudit_2 = 1;             // Has Audit logging?:1 = Yes, 0 = No.
      SET vMultiCluster_PublisherPath_2 = '';     // Has Publisher?: Log Path
      SET vMultiCluster_QVPRPath_2 = '\\CCV003\QlikTech\ManagementService\QVPR';    // Repository Path
      SET vMultiCluster_PubDateTimeFormat_1 ='CCYY-MM-DD H*24:MI:SS';       // DateTime format of Publisher task result logs (default = CCYY-MM-DD H*24:MI:SS)
           
      // Server 3 CCV752 - using this for publisher since it the windows logical cluster for the 2 active/passive publisher servers in this windows cluster and has QDS service
      SET vMultiCluster_ProfilePath_3 = 'C:\ProgramData\QlikTech\Governance_1.1\profiles\INT3';
      SET vMultiCluster_FilePath_3a = ''; //does the publisher point to a file path: did not find an example
      SET vMultiCluster_FilePath_3b = '';
      SET vMultiCluster_FilePath_3c = '';
      SET vMultiCluster_FilePath_3d = '';
      SET vMultiCluster_FilePath_3e = '';
      SET vExcludeFiles_or_Folders_3a =  '';
      SET vExcludeFiles_or_Folders_3b = '';
      SET vExcludeFiles_or_Folders_3c = '';
      SET vExcludeFiles_or_Folders_3d = '';
      SET vExcludeFiles_or_Folders_3e = '';
      SET vMultiCluster_ServerPath_3 = ''; //should this be a blank since it is a publish server only
      SET vMultiCluster_HasAudit_3 = 1;   
      SET vMultiCluster_PublisherPath_3 = C:\ProgramData\QlikTech\DistributionService';
      SET vMultiCluster_QVPRPath_3 = 'C:\ProgramData\QlikTech\ManagementService\qvpr';
      SET vMultiCluster_PubDateTimeFormat_3 ='CCYY-MM-DD H*24:MI:SS';  // DateTime format of Publisher task result logs (default = CCYY-MM-DD H*24:MI:SS)

       


      ////====================================
      /// 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\aggregate1';
      SET vMultiCluster_FilePath_101a = '$(vMultiCluster_ProfilePath_1)';
      SET vMultiCluster_FilePath_101b = '$(vMultiCluster_ProfilePath_2)';
      SET vMultiCluster_FilePath_101c = '$(vMultiCluster_ProfilePath_3)';


      SET vClusterName_101a = 'UKEMARTCCV003'; // Add unique name for each "cluster" to distinguish it from other "clusters"
      SET vClusterName_101b = 'UKEMARTCCV004';
      SET vClusterName_101c = 'UKEMARTCCV752';

      ///==================================
      ////  GLOBAL Aggregator Configuration

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