Skip to main content

Official Support Articles

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

Qlik Replicate: Task with MySQL source not picking up PK indicator when on an unsupported ODBC driver version

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

Qlik Replicate: Task with MySQL source not picking up PK indicator when on an unsupported ODBC driver version

 

Issue 


I encountered this recently when testing a NULL entry to a column on a task from MySQL source to Snowflake target. When I opened the Table Settings -> Transform tab, I noticed there was no primary key indicator on my ID column, even though I specify this in the source DDL.

 

documents_noPK.PNG

 

source DDL:

CREATE TABLE kelly.test (
id serial NOT NULL PRIMARY KEY,
class BIGINT UNSIGNED NOT NULL,
user_id BIGINT UNSIGNED NOT NULL UNIQUE
);

 

Resolution

 

For Replicate 2022.5, only these MySQL ODBC Unicode Driver 64-bit versions are supported on the Replicate Server: 

5.3.11 to 5.3.13
or
8.0.23

Doc reference


The driver in my environment was 8.0.28. When I downgraded to 8.0.23, then I was able to see the Primary Key icon in the transform column.

 

test_hasPK.png

 

 

Environment

 

The information in this article is provided as-is and to be used at own discretion. Depending on tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.

 

Version history
Last update:
2 weeks ago
Updated by:
Contributors