Qlik Community

Ask a Question

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
Talk to Experts Tuesday: Live chat Aug. 24th 10 AM ET: Bring your Qlik Gold Client questions REGISTER TODAY

CDC task data inconsistency for Compose Data Warehouse April 2020 Release and SR1

David_Fergen
Digital Support
Digital Support

CDC task data inconsistency for Compose Data Warehouse April 2020 Release and SR1

 
There may be a data inconsistency when using the affected versions of Compose for Data Warehouses in conjunction with ALL of the following:
  • Snowflake
  • Replicate CDC
  • Type 1 entities

Environment:

  • Compose for Data Warehouses April 2020 Release (version 6.6 Initial Release)
  • Compose for Data Warehouses April 2020 SR1 Release (Jun 2020 Release). 

     

 

Fix Version:

  • Compose for Data Warehouse April 2020 SR2 (6.6 SP04) 

 

Workaround:

A workaround of the product defect by one of the following:
If the entity does not have any relation to it – truncate the table and reload it
If the entity has relations to it – truncate the HUB table and all the tables of the entities that has relations to it and then reload them

 

Cause:

On Snowflake, for tables with only Type 1 columns, new records loaded by the CDC task would always start with HUB ID = 1 resulting in duplicate IDs in the HUB every time the CDC task was executed. This is the cause of the data inconsistency. 

 

Information provided on this defect is given as is at the time of documenting.  For up to date information, please review the most recent Release Notes, or contact support at support.qlik.com with the ID CMPS9370 for reference 

 

 
 

 

Labels (1)
Version history
Revision #:
3 of 3
Last update:
‎2020-08-28 05:51 AM
Updated by: