Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Streamlining user types in Qlik Cloud capacity-based subscriptions: Read the Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Al_gar
Creator
Creator

Primary Key not created

When replicating a list of tables from HANA to SQL Server some of the tables are created without PK, instead they are created with a non-clustered unique index. Looking at the source table definition the corresponding columns are set as key columns. Is this an expected behavior for why Qlik Replicate?

Qlik Replicate November 2024
source endpoint SAP HANA S/4
target endpoint SQL Server 2022

Labels (3)
1 Solution

Accepted Solutions
Alan_Wang
Support
Support

Hi @Al_gar 

Please check if you were impacted by this particular bug. If a deeper investigation is needed, open a support case for a resource to be assigned to work with you.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Missing-Primary-Key-on-Target...

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

2 Replies
Alan_Wang
Support
Support

Hi @Al_gar 

Please check if you were impacted by this particular bug. If a deeper investigation is needed, open a support case for a resource to be assigned to work with you.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Missing-Primary-Key-on-Target...

If the issue is solved please mark the answer with Accept as Solution.
Al_gar
Creator
Creator
Author

Hi @Alan_Wang, this bug might be the cause.  I'll work with my team to get Replicate updated. Thanks.