Multi Server configuration - External variables include file cannot be found

[paultribe]

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';

[Tyler_Waterfall]

That sounds like when the GovDB is reloading it cannot find the MultiCluster_UserConfig_Template.txt.  Have you tried using the full path (even w/ UNC) to that file just to double check?

If that doesn't work, post the error message and a screen shot from the configuration page of the GovDB, please.

Thanks!

[Anonymous · Accepted solution]

MS Windows Services like the QlikView Services cannot reference mapped drives such as the G: of G:\Qlikview\Documents\Public, you need to use the full unc path.

[paultribe]

Thank you Tyler and Bill. Both answers led to the resolution. I created shares on the server where GD is installed and used the unc path. it is scanning now for 5 minutes so I take that as a good sign.

Paul