Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

abw20347
New Contributor II

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

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.

5 Replies

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

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.

niceqlik
New Contributor III

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

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.

brouvreau
New Contributor

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

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

tduarte
Contributor II

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

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

agenorcanal
New Contributor II

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

Thanks a Lot !

Informação muito útil.