Knowledge

[Andre_Sostizzo]

The purpose of this guide is to walk through how to change the path in which Apps, ArchivedLogs, Custom Data, and Repository content are stored when using Qlik Sense June 2017 or higher.

Environment:

• Qlik Sense Enterprise, November 2019

Note1: Some older releases (e.g. June 2017) of Qlik Sense Enterprise did not include the QlikSenseUtil.exe tool. A copy for older releases is attached to this article for use at end-customer's own risk since it is no longer supported.

Note2: Newer releases of QlikSenseUtil.exe require the port number for the Postgres database to be filled in. (Default is 4432). It also has the option to "Use SSL" if database traffic encryption has been enabled. (see Qlik Sense - Setting up database traffic encryption)

Steps as described in the video:

1. Navigate to the Service Cluster section of the Qlik Sense Management Console to determine the current share path
2. Create a new folder for share on the intended destination.
   
   Fig 1
   
   
3. Share this path through Windows file sharing as shown in Fig 1
   
   
   • Right-Click, select Properties 
   • Open the Sharing tab
   • Press Share...
   • In the available menu add the service account to have Read/Write permissions as visualized in Fig 2
     
     Fig 2

      

4. Copy the Network path to a text editor for reference later
5. Stop all Qlik Sense services except for the Qlik Sense Repository Database / PostgreSQL on all nodes
6. Move the Apps, ArchivedLogs, CustomData, and StaticContent folders from the previous share location to the new share
7. (R-Click run as administrator) Open the QlikSenseUtil.exe file (default location C:\Program Files\Qlik\Sense\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe)
   
   
   • If you've customized the installation path for Qlik Sense then it will be located at Drive:\Path\Where\Installed\Repository\Util\QlikSenseUtil\QlikSenseUtil.exe with adjustments to the bolded section to point to where Qlik Sense has been installed
8. In QlikSenseUtil:
   • Click on the Connect to database button to connect to the underlying Repository Database
     • Host Name: Enter the hostname of the Repository database
       • Most examples would use localhost if run from the Central Node
     • Database user: qliksenserepository
       • Modify only if a different account was provided during installation. 
     • Password: password for the qliksenserepository user
9. Next, click on the Service Cluster section and click OK to retrieve the current share path values
10. Replace the existing values with the new share path
    
    
    • Ensure that there are no double slashes in the paths (e.g. \\QlikSense\\Apps) as this is not a logical Windows path
      
      Example before values:
      
      
      Example after values:
      
      
11. Click on Save to save the values in the underlying Qlik Sense Repository Database
12. Click on Clear to clear the values and then OK to retrieve the values which exist in the underlying database to ensure that the previously entered values were saved in an expected manner
    
    It is ideal here to copy one of the paths and ensure that they work as expected in Windows
    
    
13. Start all previously stopped Qlik Sense Services

[m_cabrera]

Hi, I did all the steps to change the Share folder, but now I'm having issues with the Monitoring apps. After changing the share folder all the apps wors perfect, but the reload of the Monitoring apps throws this error

The following error occurred:
Connector reply error: Unable to connect to database:
Connection failed:
Please check the values for Username‚ Password‚ Host‚ and other properties.
The error occurred here:
db_check:
SELECT "id"
FROM "public"."log_entries"
WHERE "entry_timestamp" >= '2020-10-30 08:52:07'

The following error occurred:
Exists for \ failed: ExistsException \ failed: boost::filesystem::status: No se encuentra el nombre de red especificado: "\\JRG-SRV-QLIK\QlikShare\ArchivedLogs": unknown error
The error occurred here:
FOR each folder in DirList(archivedLogsFolder & '*')
The following error occurred:
Exists for \ failed: ExistsException \ failed: boost::filesystem::status: No se encuentra el nombre de red especificado: "\\JRG-SRV-QLIK\QlikShare\ArchivedLogs": unknown error
The error occurred here:
?

Any idea what should I do in order to solve this issue?

Thanks,