topic Re: Qlik Replicate no Primary Keys in Qlik Replicate

Qlik Replicate no Primary Keys

Necator — Fri, 19 Nov 2021 13:01:42 GMT

Hello,

I tried to sync data from a MySQL Database to Snowflake. But it seems QlikReplicate ignored all of the primary keys, which are set on the MySQL database. Most of the tables contain longtext fields, so they won't be transferred as they are converted to LOBs. LOBs however only will be transferred by Qlik if there is a primary key.

Is there any method to check why QlikReplicate doesn't recognize the primary keys or set them manually?

Best

Nic

Re: Qlik Replicate no Primary Keys

john_wang — Fri, 19 Nov 2021 13:35:27 GMT

Hello @Necator ,

If I'm correct you are running MySQL ODBC 8.0.26, or 8.0.27. You can downgrade to any one between 8.0.23 - 8.0.25 (includes .25).

if you need additional assistance please attach the Diagnostics Package we will gladly help.

Regards,

John.

Re: Qlik Replicate no Primary Keys

Necator — Fri, 19 Nov 2021 13:56:16 GMT

Hi,

yes I was using 8.0.27. I graded down to 8.0.25 as you suggested. Do I need to configure anything to retrieve the information again from the server? It seems the keys are still missing if I run the pipeline?

Regards,
Nic

Re: Qlik Replicate no Primary Keys

john_wang — Fri, 19 Nov 2021 14:11:32 GMT

Hello @Necator ,

In general No. but if you can restart the Replicate Server service then it's better, however you need not other configuration steps, Replicate will detect the PK information automatically.

If the problem persist still, please send me:

1. the source table creation DDL;

2. the task export diagnostics package with source_unload/source_cpature set to Verbose. or repsrv.log file with SERVER set to Verbose.

Regards,

John.

Re: Qlik Replicate no Primary Keys

Necator — Fri, 19 Nov 2021 14:56:42 GMT

It works now, thanks.

Re: Qlik Replicate no Primary Keys

john_wang — Fri, 19 Nov 2021 15:00:04 GMT

Glad to hear that 😄