Qlik Community

Knowledge

Search or browse our knowledge base to find answers to your questions ranging from account questions to troubleshooting error messages. The content is curated and updated by our global Support team

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS

Performance issue when loading Data Warehouse satellites tables after the upgrade to Qlik Compose 2021.8.0.465

cancel
Showing results for 
Search instead for 
Did you mean: 
Nanda_Ravindra
Support
Support

Performance issue when loading Data Warehouse satellites tables after the upgrade to Qlik Compose 2021.8.0.465

After upgrading  Qlik Compose for Data Warehouse from V6.6 to Qlik Compose 2021.8.0.465, the CDC ETL job is taking a long time to finish.

Process number# 790 in the CDC task is taking a long time to finish. Below analytical function is one that takes time to execute.

This query is taking a long time to finish even when running outside of Compose:

( SUM(COALESCE([qlk__DIF], 0))
OVER ( PARTITION BY [ID]
) [qlk__SUM]

 

Resolution

 

Upgrade to 2021.8 SP13 (2021.8.569).

Incremental loading of the DWH for SQL Server (Process Step 5050.0) statement has been changed to address this issue.

 

Fix Version:

Issue fixed in 2021.8 - sp13(2021.8.569).

 

Cause

Product Defect ID: RECOB-5081

 

Environment

Qlik Compose - 2021.8.0.465
Qlik Compose 
Qlik Compose for Data Warehouses 
Database - SQL server

Labels (2)
Version history
Last update:
‎2022-06-08 02:20 AM
Updated by: