This guide aims to assist with upgrading Qlik Compose to Aug 2021. For an upgrade path overview, see Qlik Compose Upgrade Guide.
Content:
Aug 2021 upgrade guide
Upgrading from Qlik Compose Feb 2021 or May 2021 to Aug 21
This will be an in-place upgrade, but we still recommend you back up the installation, projects, and data warehouse before upgrading.
- Suspend all scheduled jobs, and stop all the tasks and services.
- After the Qlik Compose service has been stopped by the Installer, make sure that all child processes are also stopped.
Note: Qlik Compose runs a check to verify the termination of tasks and processes before running an upgrade. If any processes are found to be still running, the installation will be aborted.
- Run the Qlik Compose setup wizard for Aug 2021 as administrator.
- Open the command prompt as administrator and navigate to the Qlik Compose installation bin folder.
Default location: C:\Program Files\Qlik\Compose
- Upgrade project repositories by running one of the following commands, according to whether you changed the default location of the Compose for Data Warehouses "data" folder:
If you did not change the default location of the "data" folder, run the following:
composecli.exe upgrade
The command should complete with the following message:
Compose Control Program completed successfully.
If you changed the default location of the "data" folder, run the following:
ComposeCtl -d new_dir compose upgrade
Where new_dir is the location of the Compose "data" folder.
The command should complete with the following message:
Compose Control Program completed successfully.
- Run the below post-upgrade scripts to benefit from the latest enhancements that were added in Aug 2021 to the task ETL scripts:
ComposeCli.exe generate_upgrade_scripts
For each of your projects, the CLI output will tell you the name of the script and its location. Each script has a different name, consisting of the script identifier (the bold part), the project name, and a timestamp.
Example of Upgrade script 1:
C:\Program Files\Qlik\Compose\data\projects\Project_1\ddl-scripts \ComposeUpgradeFrom2021_5To2021_8Project_1__210714142110.sql
Example of Upgrade script 2:
C:\Program Files\Qlik\Compose\data\projects\Project_2\ddl-scripts\ComposeUpgradeFrom2021_8SP4To2021_8SP9Project_2__220114142110.sql
If you are unsure of which script to run, please run all scripts. If the object already exists, the scripts will exit with the message objects already exists. This message can be ignored.
7. Access each of your databases using SQL Workbench or a similar tool and run the script(s) that were created in Step#6.
8. When the script(s) completes successfully, generate and run your tasks in Compose.
9. Resume all suspended scheduled jobs and tasks.
If you are running any version earlier than Attunity Compose for Data Warehouses version 6.6.1, you must first upgrade to the 7.0 version before moving on to any of the later versions of Qlik Compose. The upgrade path for earlier versions of 6.6.1 is listed below. Contact support for upgrade instructions for unsupported versions and software downloads.
Upgrading from unsupported Compose for Data Warehouses versions to Aug 2021
Compose for Data Warehouses from 6.6.1 or 7.0 to Aug 2021
There is no direct upgrade path to Aug 2021. The upgrade path will have to be processed in two steps:
Feb 2021 to Aug 2021
- Upgrade to Compose Feb 2021 following the instructions Upgrading from Compose for Data Warehouses 6.6.1 or 7.0 to Feb 2021
- Upgrade to Compose Aug 2021, following the in-place upgrade steps one through nine as per these instructions.
Compose for Data Warehouses from 6.5 or 6.6 to Aug 2021
There is no direct upgrade path to Aug 2021. The upgrade path will have to be processed in three steps:
V6.6.1 to Feb 2021 to Aug 2021.
- Contact Support for upgrade instructions to Compose for Data Warehouses 6.6.1.
- Upgrade to Compose February 2021 following the instructions Upgrading from Compose for Data Warehouses 6.6.1 or 7.0 to Feb 2021
- Upgrade to Compose Aug 2021, following the in-place upgrade steps one through nine as per these instructions.
Compose for Data Warehouses from 6.3 or 6.4 to Aug 2021
There is no direct upgrade path to Aug 2021. The upgrade path will have to be processed in four steps:
V6.5 to V6.1.1 to Feb 2021 to Aug 2021.
- Contact Support for upgrade instructions to Compose for Data Warehouses 6.5.
- Contact Support for upgrade instructions to Compose for Data Warehouses 6.6.1.
- Upgrade to Compose February 2021 following the instructions Upgrading from Compose for Data Warehouses 6.6.1 or 7.0 to Feb 2021
- Upgrade to Compose Aug 2021, following the in-place upgrade steps one through nine as per these instructions.