3 Replies Latest reply: Sep 18, 2017 5:10 PM by Bernard ROUVREAU RSS

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

    Arvind Waghmare

      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.
          Bill Markham

          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.
            Ismail Baygin

            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.
                Bernard ROUVREAU

                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