Qlik Replicate tasks crash due to changes to the redo log format after installing Oracle July 2024 patch on Oracle 19

[SwathiPulagam]

Qlik Replicate tasks using Oracle as a Source Endpoint fail after installing the Oracle July 2024 patch. 

All Qlik Replicate versions older than the 2024.5 SP03 release are affected.

Environment

• Qlik Replicate 2024.5 SP02 and below
• Oracle Source Endpoint with Oracle 2024 July patch (version 19.24)

Resolution

Upgrade to Qlik Replicate 2023.11 SP05, or 2024.5 SP03 or later. 

Download the formal builds for 2023.11 and 2024.5 here:

Qlik Replicate 2023.11 SP05: https://files.qlik.com/url/qr2023110860sp05 (expires 1/31/2025)

Qlik Replicate 2024.5 SP03 link: https://files.qlik.com/url/qr2024050563sp03 (expires 1/31/2025)

If you have Qlik Enterprise Manager deployed, upgrade this as well. See Qlik Enterprise Manager fails adding a table to a task with SYS-E-HTTPFAIL, no rest handler for url for download links.

Cause

The Oracle July 2024 patch introduced a change to redo events. Qlik has since provided a fix for Qlik Replicate which parses the redo log correctly. 

Internal Investigation ID(s)

RECOB-8698

Reference:

Oracle Database 19c Release Update July 2024 Known Issues

As a general reminder, all changes to the environment such as operating system patches, endpoint and driver patches, etc. should be tested in lower environments before promoting to production.

[john_wang]

Hello @rekockot ,

This is the early build of Qlik Replicate 2023.5 SP07:

https://files.qlik.com/url/cvwc7qrcvigzpbph

password: pz2utnku

Regards,

John.

[rekockot]

Hi @john_wang,

Thanks for providing the link! I also downloaded the patch for 2023.11 SP05 but the zip file is empty, same thing for the 2023.5 SP07 patch. Have the links expired?

Please advise.

Thanks,

Temi

[MoeyE]

Hi @john_wang ,

Is QR 2023.5 SP07 a fix for the Oracle issue? Thank you.

https://files.qlik.com/url/cvwc7qrcvigzpbph

password: pz2utnku

Regards,

Mohammed

[john_wang]

Hello Mohammed, @MoeyE 

From what I got, Yes, any feedback is appreciated.

Thanks,

John.

[NakulanR]

Hi Support,

I'd just like to confirm whether Replicate 2024.5.0.485 is the latest build of Replicate May 2024. If so, does it address both the Oracle issue mentioned in the above article and the compressed table issue?

Regards,

Nak

[NakulanR]

Hi Support,

Can the build of Replicate May 2023 which resolves this issue please be re-uploaded? The previous FileCloud link is now expired.

Thanks,

Nak

[john_wang]

Hello Nak, @NakulanR 

Here is the latest early build 554 of SP03:

https://files.qlik.com/url/yzqhjpnbmbynx2sb

password: 6mzmiksw

Please take note it's an early build, it cannot be installed in PROD system, the formal release will come soon. 

Regards,

John.

[NakulanR]

Hi @john_wang,

Thanks for sending that, however I would like the latest build of May 2023. The FileCloud link you provided contains May 2024. If it's not too much trouble can you please provide the latest build of May 2023 which addresses this issue.

Regards,

Nak

[john_wang]

Hi Nak, @NakulanR 

This is 2023.11 SP05 early build 848:

https://files.qlik.com/url/mzkecyddre7ujqjg

password: 75kjyurf

Regards,

John.

[wali]

I have Qlik replicate version 2023.5.0.771. Which one of the interim fix I need to apply? we are seeing the same error "compressed table" row access as noted here, after the July oracle Patch.