Qlik Replicate November 2022 version causing existing tasks to fail

[desmondchew]

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:

[Dana_Baldwin]

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

[Bill_Steinagle]

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_p...

Thanks!

Bill

[Barb_Fill21]

@desmondchew 

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

1. 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

[desmondchew]

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)