topic Re: Qlik Replicate November 2022 version causing existing tasks to fail in Qlik Replicate

Qlik Replicate November 2022 version causing existing tasks to fail

desmondchew — Mon, 14 Nov 2022 10:30:41 GMT

We have several tasks that have been running for more than a year. We were on QDI version May 2021 latest patch. After we upgrade to November 2022, there are a few tasks started giving issues and failed. Our source DB is Oracle 11g. Target DB is MySQL 8.0.30

Error as shown. I have to reload the full table to workaround. But occasionally it still give error from time to time. Previously with May 2021 version, there's no such issue.

00011372: 2022-11-13T23:49:35 [TARGET_LOAD ]I: ODBC driver version: '08.00.0023' (ar_odbc_conn.c:633)
00011372: 2022-11-13T23:49:35 [TARGET_LOAD ]I: Target database time zone is UTC+0 hours (odbc_endpoint_imp.c:5135)
00011372: 2022-11-13T23:49:35 [TARGET_LOAD ]I: Target endpoint 'Mysqltarget' is using provider syntax 'MySQL' (provider_syntax_manager.c:947)
00011372: 2022-11-13T23:49:35 [TARGET_LOAD ]I: Default Target MySQL collation for utf8mb4 is 'utf8mb4_0900_ai_ci' (odbc_endpoint_imp.c:791)
00011372: 2022-11-13T23:49:36 [TARGET_LOAD ]I: Transaction size is 40000. Array size is 1000. (odbc_endpoint_imp.c:1066)
00011372: 2022-11-13T23:49:36 [TARGET_LOAD ]I: Loading tables in 2 parallel threads by default (odbc_endpoint_imp.c:2156)
00011372: 2022-11-13T23:49:36 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:941)
00003128: 2022-11-13T23:49:36 [SORTER ]I: Reload for table Id 1 is requested (sorter_transaction.c:2457)
00003128: 2022-11-13T23:49:36 [SORTER ]I: Start collecting changes for table id = 1 (sorter_transaction.c:2332)
00002384: 2022-11-13T23:49:36 [TASK_MANAGER ]I: Start loading table 'schema'.'tableBAC' (Id = 1) by subtask 1. Start load timestamp 0005ED66F74CB5C0 (replicationtask_util.c:755)
00006988: 2022-11-13T23:49:36 [SOURCE_UNLOAD ]I: Table 'schema.tableBAC' is unloaded using the passthrough filter expression 'to_char(AUD_LD_DT,'YYYY') >= '2019'' (endpointshell.c:3800)
00003172: 2022-11-13T23:49:36 [SOURCE_CAPTURE ]I: Start processing online Redo log sequence 774281 thread 1 name /u01/oracle/oradata/odsprod/redo21a.log (oradcdc_redo.c:898)
00003172: 2022-11-13T23:49:37 [ASSERTION ]W: DIRECT INSERT event ITL version is not standard (82) for the captured table 'tableBAC', context '0000001a.93fddcac.00000001.0041.01.0000:774281.52301.16' (oradcdc_parse.c:1094)
00003172: 2022-11-13T23:49:37 [ASSERTION ]W: Cannot parse DIRECT INSERT event of the captured table 'tableBAC', context '0000001a.93fddcac.00000001.0041.01.0000:774281.52301.16' (oradcdc_parse.c:1070)
00003172: 2022-11-13T23:49:37 [ASSERTION ]W: Cannot parse DIRECT INSERT event of the captured table 'tableBAC', context '0000001a.93fddcdf.00000001.00d1.01.0000:774281.52945.16' (oradcdc_parse.c:1070)
00003172: 2022-11-13T23:49:37 [ASSERTION ]W:

Re: Qlik Replicate November 2022 version causing existing tasks to fail

Dana_Baldwin — Mon, 14 Nov 2022 16:03:50 GMT

Hi @desmondchew

I see you have also opened a support case, which is good as we may need to involve our internal support team for resolution.

Thanks,

Dana

Re: Qlik Replicate November 2022 version causing existing tasks to fail

Bill_Steinagle — Mon, 21 Nov 2022 20:42:18 GMT

Hi,

Thank you for the post to the QDI Forums. I would suggest installing the 8.0.23 ODBC Driver for MySQL as noted in the Replicate User Guide. See link below:

https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Google%20Cloud%20MySQL/google_prereq_mysql_general_target.htm

Thanks!

Bill

Re: Qlik Replicate November 2022 version causing existing tasks to fail

Barb_Fill21 — Mon, 28 Nov 2022 12:55:54 GMT

@desmondchew

Thanks for your question. I see you are using the wrong driver. The November 2022 doc states the following:

Install MySQL ODBC Unicode Driver 64-bit version 8.0.30 on the Replicate machine.

Please install ONLY the 8.0.30 release of the driver. This is the driver version we have certified it with.

Hope this helps.

Barb

Re: Qlik Replicate November 2022 version causing existing tasks to fail

desmondchew — Tue, 29 Nov 2022 03:34:09 GMT

We were on QDI version May 2021 latest patch. After we upgrade to November 2022,it failed. We rolled back to May 2021 now.

May 2021 (2021.5.0.1272)