Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
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:
Thanks!
Bill
Thanks for your question. I see you are using the wrong driver. The November 2022 doc states the following:
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
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)