Knowledge

Alternative way to change service cluster settings

Article Number: 000067526 | Last Modified: 2019/12/16

Description

A primary way to change service cluster settings (sharefolder path) is via Util.exe tools by editing "Service Cluster" tab.

More information on where to find Util.exe and how to use it, see Qlik Sense Utility - Functions and Features.

If the Util.exe is unavailable or cannot be launched due to specific operating system issues or domain policies, an alternative (manual) way can be used to change the Service Cluster settings.

Resolution

To make changes directly, a database query will need to be executed against the Qlik Sense Repository Database using PgAdmin.

! Before proceeding, a backup needs to be done. How To Take Backup And Restore Qlik Sense June 2017 or higher

For information on how to install pgAdmin, see Installing and Configuring PGAdmin 4 to access the PostgreSQL database used by Qlik Sense or NPrinting.

Run the following queries in pgAdmin:

UPDATE "public"."ServiceClusterSettingsSharedPersistenceProperties" SET "RootFolder"='\\shareserver\sharefolderpath';
UPDATE "public"."ServiceClusterSettingsSharedPersistenceProperties" SET "AppFolder"='\\shareserver\sharefolderpath\Apps';
UPDATE "public"."ServiceClusterSettingsSharedPersistenceProperties" SET "StaticContentRootFolder"='\\shareserver\sharefolderpath\StaticContent';
UPDATE "public"."ServiceClusterSettingsSharedPersistenceProperties" SET "Connector32RootFolder"='\\shareserver\sharefolderpath\CustomData';
UPDATE "public"."ServiceClusterSettingsSharedPersistenceProperties" SET "Connector64RootFolder"='\\shareserver\sharefolderpath\CustomData';
UPDATE "public"."ServiceClusterSettingsSharedPersistenceProperties" SET "ArchivedLogsRootFolder"='\\shareserver\sharefolderpath\ArchivedLogs'

Where \\shareserver\sharefolderpath is the new folder to specify.

Get Answers

Find Answers

Qlik Community

Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.

Join Us

Get Support

Have a Question?

Search Qlik's Support Knowledge database or request assisted support for highly complex issues.

Submit a case

Talk with a Representative

Critical Issues

Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.

Call Us