topic Re: Unexpected Primary Key in Qlik Compose

Unexpected Primary Key

vtatarnikov — Fri, 14 Mar 2025 20:49:07 GMT

Hi!

I have created Entity with 2 business keys, made mapping and started task.

Then I realized that only one field is a business key and removed the mark from the entity in the logical model. Then I did the model and dwh validation, ran the object update script. And started the mapping task again and got this error:

ETL task aborted - Unexpected Primary Key violations detected in 'TSTG_clients_P'

I have deleted all tables associated with my entity and I cannot see the TSTG_clients_P table.

How to solve this problem?

Re: Unexpected Primary Key

suresh_pulagam — Thu, 23 Dec 2021 21:23:08 GMT

Hi @vtatarnikov ,

Hope you see the below error.

After you run the database script manually, clear the metadata cache and regenerate the instructions. The task should run fine after that.

Re: Unexpected Primary Key

vtatarnikov — Fri, 24 Dec 2021 05:55:18 GMT

Thanks Suresh, but it did not help.

I cleared the cache and did the dwh validation, regenerate mapping, everything is ok. But when I run the mapping task, I get the same error.

Re: Unexpected Primary Key

vtatarnikov — Fri, 24 Dec 2021 06:08:57 GMT

The duplicate handling function helped me. Before that, I did not check this box for this task, because I'm sure there are no duplicates.
Perhaps the problem was not what I described originally.

In any case, I would like to receive technical support comments to understand what was the matter.