Qlik Replicate Encouter a Critical issues with Compressed tables after Oracle July 2024 Patch

[wali]

I have Qlik Replicate version  May 2023 (2023.5.0.771). 

I see the early builds version 2023.11 and 2024. Which one should I apply? 

Please advise. 

[Dana_Baldwin]

Hi @wali 

We are not able to provide a patch for this on version 2023.5. You can upgrade to the patched version of 2023.11 or 2024.5. The one you decide to use depends on the version of the operating system, sources, targets, and drivers that you are using. Please check the release notes here: Release Notes | Qlik Community

Also here is an upgrade guide with a list of things to check: Qlik Replicate Upgrade Best Practices - Qlik Community - 1729651

[wali]

Hi Dana,

Source endpoint is Oracle 19.0.0.0.0 

Oracle Client: 19.3.0.0.0

 Target endpoint: SnowflakeAzure 

OS: Windows 2019 Data Center

[wali]

Hi @Dana_Baldwin 

We are currently using Qlik replicate and Qlik Manager. Please advise what version to upgrade to?

Source endpoint is Oracle 19.0.0.0.0 

Oracle Client: 19.3.0.0.0

 Target endpoint: SnowflakeAzure 

OS: Windows 2019 Data Center

[SushilKumar]

Hello @wali 

Customer is the one who has to decide as per best practice Should go with N-1, As Dana Mentioned Which version you are using also . If you are using 2022.11 they can directly upgrade to 2023.11 or can use 2023.5 

Regards,

Sushil Kumar

[john_wang]

Hello @wali , 

>> Source endpoint is Oracle 19.0.0.0.0 

That means the Oracle 19c July 2024 patch was not installed. You need NOT the special patch for this source database yet. Unless you are planning to install July 2024 patch.

After the July 2024 patch installed, the Oracle version number is 19.24.

Regards,

John.

[wali]

@jon_wang

the Oracle DBA confirmed the Oracle instance is: 19.24, which means the July 2024 patch was installed. Can someone advise what version of Qlik Replicate and Manager I need to upgrade to resolve the issue. All our Production Replication tasks are impacted!

[wali]

@john_wang @SushilKumar @Dana_Baldwin 

the Oracle DBA confirmed the Oracle instance is: 19.24, which means the July 2024 patch was installed. Can someone advise what version of Qlik Replicate and Manager I need to upgrade to resolve the issue. All our Production Replication tasks are impacted! please advise.

Thank you in advance -

[kng]

Hi @wali 

Thanks for the update!!

Please find the below article which provide the link to address the issue raised due to July Oracle patch 2024

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-tasks-crash-due-to-changes-to...

Hope this helps!!

Regards,

Shivananda

[wali]

@SushilKumar 

We did have issue post July 2024 patch that non-of the Replicate task was able to run. I open a support case and per support downloaded.

replicate: 2023.5.0.988 - SP7

manger; 2023.5.0.771

my question is now we are getting compression errors on some tables, what Qlik Replicate and Manager should I down to address this issue. If someone provide me the download link will be much appreciate it.

I can be reach at 703 338-5435 if need to discuss further or opening a sub-1 CASE.