topic Re: An existing task failed with with error A compressed row cannot be parsed for table in Qlik Replicate

An existing task failed with with error A compressed row cannot be parsed for table

desmondchew — Mon, 21 Nov 2022 15:33:07 GMT

We have an existing tasks that load table from Oracle 11g into MySQL 8.0.30. The task failed suddenly with error a compressed row cannot be parsed.

00008856: 2022-11-21T10:29:59:489101 [SORTER ]I: Transaction consistency reached (sorter_transaction.c:313)
00008708: 2022-11-21T10:29:59:489101 [TASK_MANAGER ]I: Starting replication now (replicationtask.c:3299)
00008856: 2022-11-21T10:30:00:660949 [ASSERTION ]W: A compressed row cannot be parsed for table 'SCHEMA.TABLE, context '00000000.00000000.00000000.0000.00.0000:0.0.0' (oradcdc_parse.c:1895)

Re: An existing task failed with with error A compressed row cannot be parsed for table

Dana_Baldwin — Mon, 21 Nov 2022 15:48:59 GMT

Hi @desmondchew

What version of Replicate are you running?

Are you using our log reader or LogMiner?

What type of compression is in use on the source table?

Here is our documented limitations on compression for Oracle source: Supported compression methods ‒ Qlik Replicate

Thanks,

Dana

Re: An existing task failed with with error A compressed row cannot be parsed for table

Bill_Steinagle — Mon, 21 Nov 2022 20:37:55 GMT

Hi,

Thank you for the post to the QDI Forums. The issue is due to the MySQL ODBC driver as you have the 8.0.30 version installed. As per the Replicate User guide you will need to install the 8.0.23 version of the MySQL ODBC driver to correct the condition. As Dana noted if you run into issue after installing the required ODBC Version of the driver a case with the Support Team is next step.

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

Thanks!

Bill

Re: An existing task failed with with error A compressed row cannot be parsed for table

desmondchew — Wed, 23 Nov 2022 01:55:58 GMT

Hi,

We are definitely on ODBC version 8.0.23. The version that you see in the log files comes from the target database which is running on 8.0.30. Please see attached showing the installed ODBC version in replicate server.

Re: An existing task failed with with error A compressed row cannot be parsed for table

Bill_Steinagle — Wed, 23 Nov 2022 12:29:14 GMT

Hi,

Thank you for the reply. Ok so the issue appears to be on the Source side reading from the Redo Log. I would suggest open a case since you confirmed the MySQL ODBC driver is correct.

Thanks!

Bill