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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!

Qlik Replicate: Missing Primary Key on Target Table

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Alan_Wang
Support
Support

Qlik Replicate: Missing Primary Key on Target Table

Last Update:

Aug 12, 2025 8:12:21 AM

Updated By:

Sonja_Bauernfeind

Created date:

Aug 12, 2025 8:12:21 AM

Tables with too many columns (approximately 15 or more) can end up with a Unique Index instead of a Primary Key when Qlik Replicate builds the table. This is caused by a defect, leading to the key column transformation feature being automatically applied as the default setting.

The default Use target definition setting gets switched to Use transformation definition, which reorders the key columns and builds a Unique Index instead of a Primary Key.

set key columns.png

 

Resolution

Workaround

Manually switch the option back to Use target definition. This will avoid the Unique Index instead of the Primary Key

Fix Version

Qlik Replicate November 2025.

 

Cause

SUPPORT-4339

 

Internal Investigation ID(s)

SUPPORT-4339

 

Environment

  • Qlik Replicate version before November 2025
Labels (1)
Version history
Last update:
‎2025-08-12 08:12 AM
Updated by: