topic How to change root folder path in shared persistence QlikSense 3.2 site. in Management & Governance

How to change root folder path in shared persistence QlikSense 3.2 site.

abw20347 — Thu, 20 Apr 2017 01:52:01 GMT

Hello friends, this is my first question here, as I am new to QlikSense... I have configured QlikSense site earlier - production and failover site... however the shared root path was used incorrectly , and later we desided to move to different path however I do not have any clue about how to change the root folder now.. as the root folder is grayed out when look at in the QMC.

Could you pleaes help me here on how to proceed changing the root folder now?

Thank you very much for your suggestions and help.

Re: How to change root folder path in shared persistence QlikSense 3.2 site.

Anonymous — Thu, 20 Apr 2017 15:39:38 GMT

That is a very good question and I would advise caution by initially seeking the advice of Qlik via your support contract.

If you guess and it all breaks, then you would probably have to contact them anyway for them to help mend it. So a pre-emptive call before could save you & them much grief.

Re: How to change root folder path in shared persistence QlikSense 3.2 site.

niceqlik — Fri, 18 Aug 2017 11:07:14 GMT

Hi,

There are 2 options to make a root folder change in Shared Persistence systems:

Option 1 (This option makes sense if your defined root path contains drive letter reference. Example : \\SERVER\C$\SHAREDFOLDER and you want to use a different drive):

1. Stop all Qlik Sense services except Qlik Sense Repository Database.

2. Under C:\Program Files\Qlik\Sense\Repository\PostgreSQL\9.6\bin folder there is an executable called PgAdmin3. Run this to connect Qlik Sense Repository Database. Please note that Qlik Sense Database is using port 4432 rather than the default Postgresql port 5532.

3. Once you connect, proceed to Databases -> QSR -> Schemas - > public -> Tables and find the table called ServiceClusterSettingsSharedPersistenceProperties

4. Make appropriate changes in the below fields to define new folder paths.

RootFolder
AppFolder
StaticContentRootFolder
Connector32RootFolder
Connector64RootFolder
ArchivedLogsRootFolder

5. Copy all previous folder content into the new one.

6. Start all Qlik Sense services.

Option 2 (This option makes sense if your defined root path does not contains drive letter reference. Example: \\SERVER\SHAREDFOLDER):

1. Stop all Qlik Sense services.

2. Unshare your shared folder using Windows share options in the folder properties.

3. Create a new folder to be used for root folder where you want to use but make its name same as the previous one.

4. Share this folder now and make sure that UNC path is exactly the same as the previous one.

5. Copy all previous folder content into the new one.

6. Start all Qlik Sense services.

Re: How to change root folder path in shared persistence QlikSense 3.2 site.

brouvreau — Mon, 18 Sep 2017 21:10:50 GMT

Hello,

I also tried to modify these entries in QSR Database, but not only in this table.

you also have to verify or !make appropriate changes in 3 other tables :

DataConnections.Connectionstring where DataConnections.Name = AttachedFiles and where DataConnections.Name = ArchivedLogsFolder
EngineServiceSettings.DocumentDirectory where EngineServiceSettings.TableFilesDirectory = C:\ProgramData\Qlik\Sense\Apps.
RepositoryServiceSettings.AppImportFolder

Now I am able to import Apps without problems.

Regards

Re: How to change root folder path in shared persistence QlikSense 3.2 site.

tduarte — Thu, 19 Apr 2018 12:03:46 GMT

Hi,

The best way to update shared folders paths is by using the QlikSenseUtil.exe tool located in C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil

Instructions are available on the Support Portal => Knowledge section.

Direct link to the article 000045909:

https://qliksupport.force.com/articles/000045909

Regards,

Telmo

Re: How to change root folder path in shared persistence QlikSense 3.2 site.

agenorcanal — Sat, 30 Jun 2018 22:00:13 GMT

Thanks a Lot !

Informação muito útil.

Re: How to change root folder path in shared persistence QlikSense 3.2 site.

jamshed07 — Sun, 17 Jan 2021 12:19:40 GMT

Thank you very much , this solved my issue . I have network path and option 2 is working fine with me