Upgrading to Qlik Sense June 2017 or later from Qlik Sense versions earlier than 3.1 SR2

Qlik Sense June 2017 and later versions do not support the synchronized persistence model. To upgrade to Qlik Sense June 2017 or later from any version of Qlik Sense earlier than 3.1 SR2 and migrate from a synchronized to shared persistence model, follow the instructions on this page.

Upgrading from any version of Qlik Sense earlier than 3.1 SR2 to Qlik Sense June 2017 or later cannot be done using the setup program. If you wan to upgrade from Qlik Sense 3.1 SR1 or earlier to Qlik Sense June 2017 or later, you must first upgrade to Qlik Sense June 2017. Once your environment is on version June 2017 of Qlik Sense, you can upgrade to any newer version using the Qlik Sense setup program.

Warning: If you attempt to upgrade from Qlik Sense versions earlier than 3.1 SR2 to Qlik Sense June 2017 using the setup program you will receive an error.
Note: The new hostname must match the one used before the upgrade. Using a different hostname will cause a mismatch in the certificate, which will prevent you from accessing the hub. You can verify the previous hostname by:
- Checking the certificate name
- Checking the file C:\Programdata\Qlik\Sense\Host.cfg (String encoded based64)
See also Restoring a central node to a machine with a different hostname section in Restoring a Qlik Sense site

Do the following:

  1. Create a backup of your existing Qlik Sense deployment. For more information, see the help for the version of Qlik Sense that you are currently running.
  2. Change the PostgreSQL authentication mode in the configuration settings to allow the password to be changed.

    1. Stop the Qlik Sense Repository Database service.
    2. Open the Client Authentication file located in ProgramData\Qlik\Sense\Repository\PostgreSQL\<database version>\pg_hba.conf .
    3. Change the ADDRESS to 127.0.0.1/32, and change the METHOD to trust for for IPv4 local connections and local host replication.
    4. Change the ADDRESS to ::1/128, and change the METHOD to trust for IPv6 local connections and local host replication.
    5. Start the Qlik Sense Repository Database service.
  3. Change the Qlik Sense Repository Database password.
    To change the password using PostgreSQL command line:

    1. Open a command prompt and navigate to ProgramFiles\Qlik\Sense\Repository\PostgreSQL\<database version>\bin.

    2. Connect to the database by entering the following command:

      psql.exe -p 4432 -U postgres.

    3. Enter the following command to set the new user password:

      ALTER USER qliksenserepository WITH PASSWORD '<newpassword>';

      ALTER ROLE is displayed after successfully changing the password.

    To change the password using the pgAdmin tool:

    1. Launch pgAdmin and connect to the Qlik Sense Repository Database.

    2. Expand the tree in the left pane and click Login Roles > qliksenserepository.
    3. Right-click on qliksenserepository and select Properties.
    4. Click the Definition tab, and enter a Password.

  4. Reset the PostgreSQL authentication mode in the configuration settings to require authentication.

    1. Stop the Qlik Sense Repository Database service.
    2. Open the Client Authentication file located in ProgramData\Qlik\Sense\Repository\PostgreSQL\<database version>\pg_hba.conf .
    3. Change the METHOD back to md5.
    4. Start the Qlik Sense Repository Database service.

  5. Create a database dump file.

    If Qlik Sense is installed:

    1. Stop all Qlik Sense services except Qlik Sense Repository Database service. Ensure that the Qlik Sense Repository Database service is running.

    2. Open a command prompt and navigate to the location where the PostgreSQL database is installed, and enter the following commands:

      • set PGUSER=postgres

      • set PGPASSWORD=[superuserpassword]

      • pg_dumpall.exe -p 4432 > [path to dump file]

    If Qlik Sense has been uninstalled:

    1. Copy the PostgreSQL folder from %ProgramData%\Qlik\Sense\Repository\PostgreSQL\9.6 to a temporary location outside of the %ProgramData%\Qlik folder.
    2. Download and install PostgreSQL version 9.6 from the PostgreSQL website. For more information, see Installing and configuring PostgreSQL.
    3. Open a Command Prompt in Microsoft Windows.
    4. Navigate to the location where the PostgreSQL repository database is installed, cd "%ProgramFiles%\PostgreSQL\9.6\data\bin", and run the following commands:
      • pg_ctl.exe start -w -D "C:\SenseDB\9.6"
      • set PGUSER=postgres
      • set PGPASSWORD=password
      • pg_dumpall.exe > [path to dump file]
      • pg_ctl.exe stop -w -D "C:\SenseDB\9.6"
  6. Make a backup of log and application data in the following folders:
    • %ProgramData%\Qlik\Sense\Log
    • %ProgramData%\Qlik\Sense\Apps
    • %ProgramData%\Qlik\Sense\Repository\Content
    • %ProgramData%\Qlik\Sense\Repository\Extensions
    • %ProgramData%\Qlik\Sense\Repository\AppContent (if available)
    • %ProgramData%\Qlik\Sense\Repository\SharedContent (if available)
  7. Make a backup of any locations where content that supports the Qlik Sense environment may be kept (for example, QVD files created by load scripts).
  8. Create a file share, see Creating a file share.
  9. Create the following sub-folders in the file share:

    • Apps
    • ArchivedLogs
    • CustomData
    • StaticContent
  10. Copy following content from your synchronized persistence deployment to the file share:

    Content Copy from To subfolder
    Apps ..\ProgramData\Qlik\Sense\Apps Apps
    Logs (optional) ..\ProgramData\Qlik\Sense\Repository\Archived Logs ArchivedLogs
    Static content

    ..\ProgramData\Qlik\Sense\Repository\AppContent

    ..\ProgramData\Qlik\Sense\Repository\Content

    ..\ProgramData\Qlik\Sense\Repository\DefaultContent

    ..\ProgramData\Qlik\Sense\Repository\Extensions

    ..\ProgramData\Qlik\Sense\Repository\DefaultApps

    ..\ProgramData\Qlik\Sense\Repository\SharedContent

    Note: Each of these folders must be added as a sub-folder of the StaticContent folder.
    StaticContent
  11. Ensure that all Qlik Sense nodes are synchronized, and take all nodes offline by stopping the Qlik Sense services in Windows.
  12. Uninstall Qlik Sense. Accept the defaults when uninstalling to preserve the certificates settings.
  13. In the Command Prompt window, navigate to the folder containing the Qlik_Sense_setup.exe file.

  14. Run the following command to install Qlik Sense and restore your Qlik Sense Repository Database.
    Qlik_Sense_setup.exe databasedumpfile=<path_to_dump_file>

    Warning: The path to the dump file must be entered as an absolute path, using a relative path will result in an installation failure.
  15. Uninstall Qlik Sense on each of your rim nodes in multi-node deployment. Select the option to completely uninstall Qlik Sense when you uninstall on the rim nodes.
  16. Install Qlik Sense on each of the rim nodes.
  17. Connect the rim nodes in the QMC, select each node, and click the Redistribute button.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?