article Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch in Official Support Articles

Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

SwathiPulagam — Wed, 19 Mar 2025 07:42:00 GMT

After applying the Oracle July 2024 patch, the following error will be seen when working with compressed tables:

[ASSERTION ]W: A compressed row cannot be parsed for table (oradcdc_parse.c:2640)

The error leads to missing records.

Only Oracle instances with compressed tables are affected.

Resolution

R&D addressed the compression warning and also another missing insert events.

Fix versions

2023.11 and later
2024.5 and later

Before rolling out the fix in production, always first test in UAT or other pre-release environments.

If you are uncertain whether or not you are using compressed tables, run the following query:

select owner, table_name, COMPRESSION,COMPRESS_FOR from dba_tables where compression='ENABLED'

Cause

Oracle July 2024 Patch with compressed tables.
RECOB-8914 by Qlik.

Environment

Qlik Replicate
Oracle with July 2024 patch

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

kalpesh97 — Tue, 24 Sep 2024 16:49:42 GMT

We are encountering same issue. Two questions:

1. would Qlik 2023.11.724 solve the problem?

2 when would the patch be available for 23.5? You mentioned week 39. Please let us know specific date.

Thank you,

Kalpesh

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

narendersarva — Tue, 24 Sep 2024 16:53:33 GMT

Hi @kalpesh97

Please see below for 2023.5 patch download.

Qlik Replicate tasks crash due to changes to the r... - Qlik Community - 2475965

Thanks
Naren

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

kalpesh97 — Tue, 24 Sep 2024 17:41:25 GMT

Thanks @narendersarva

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

SwathiPulagam — Wed, 25 Sep 2024 12:42:42 GMT

Hi @kalpesh97

Are you encountering the following warning when working with compressed tables after applying the Oracle July 2024 patch?

[ASSERTION ]W: A compressed row cannot be parsed for table (oradcdc_parse.c:2640)

If yes then there is no fix yet available in any Replicate version.

1. would Qlik 2023.11.724 solve the problem?

This patch resolves the Task crash issue that occurs after applying the Oracle July Patch on Oracle instances, but it does not address the compressed table issue.

2 when would the patch be available for 23.5? You mentioned week 39. Please let us know

Mostly by the end of this week.

I recommend opening a support case if you see the above warning message. We will collect the relevant redo log and share it with R&D to confirm if it's the same issue.

Thanks,
Swathi

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

Nicorra — Fri, 27 Sep 2024 16:32:28 GMT

Thanks SwathiPulagam and support for this post
We have the same issue.... and we are more than impatiant to have this fix by the end of this week 39!

Nicolas

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

Sonja_Bauernfeind — Tue, 01 Oct 2024 13:01:02 GMT

Hello @Nicorra

Please check the updated article for the download links of the early build.

Al the best,
Sonja

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

Nicorra — Wed, 02 Oct 2024 15:41:09 GMT

Hi @Sonja_Bauernfeind and @SwathiPulagam

Thanks Qlik Team! We have installed, tested and deployed in Test and then on our Prod the patch It works 100% fine!

Note that In our case we have reloaded all our SAP data from the log stream to make sure no missing records where forgotten. Load without any issue. Monitoring not showing errors like it should be!

Merci / Many thanks!

Nicolas

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

gseckin — Tue, 18 Mar 2025 13:44:46 GMT

Hi, we have same issue and we'll upgrade to this version 2024.5 SP03. This version have fixed for this issue right?

Re: Qlik Replicate Encounters a Critical Issue with Compressed Tables after Oracle July 2024 Patch

Sonja_Bauernfeind — Wed, 19 Mar 2025 11:31:48 GMT

Hello @gseckin

This version would include the fix, yes.

Should you still run into issues I would recommend logging a ticket with support.

All the best,
Sonja