topic Re: Qlik Replicate Encouter a Critical issues with Compressed tables after Oracle July 2024 Patch in Qlik Replicate

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

wali — Wed, 06 Nov 2024 18:34:40 GMT

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.

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

Dana_Baldwin — Wed, 06 Nov 2024 18:40:38 GMT

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

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

wali — Wed, 06 Nov 2024 19:39:04 GMT

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

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

wali — Wed, 06 Nov 2024 20:05:39 GMT

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

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

SushilKumar — Thu, 07 Nov 2024 00:21:52 GMT

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

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

john_wang — Thu, 07 Nov 2024 07:28:23 GMT

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.

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

wali — Thu, 07 Nov 2024 14:01:24 GMT

@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!

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

wali — Thu, 07 Nov 2024 14:03:47 GMT

@john_wang @SushilKumar @Dana_Baldwin

Thank you in advance -

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

kng — Thu, 07 Nov 2024 14:07:11 GMT

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-the-redo-log-format/ta-p/2475965

Hope this helps!!

Regards,

Shivananda

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

wali — Thu, 07 Nov 2024 14:39:18 GMT

@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.

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

john_wang — Thu, 07 Nov 2024 14:42:45 GMT

Hello @wali ,

Thanks for the update.

>> the Oracle DBA confirmed the Oracle instance is: 19.24, which means the July 2024 patch was installed.

Would you please run the SQL and share the result with me?

SELECT * FROM v$version;

>> Can someone advise what version of Qlik Replicate and Manager I need to upgrade to resolve the issue.

Please upgrade to 2024.5 SP03, or 2023.11 SP05, both will be formal released recently. Will keep you posted.

Regards,

John.

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

Dana_Baldwin — Thu, 07 Nov 2024 16:50:26 GMT

Hi @wali

The needed patch is only available in version 2023.11 and 2024.5 per the link above. Please ensure your server operating system, source/target versions and driver versions are supported before you upgrade.

See here for more details on these items: Qlik Replicate Upgrade Best Practices - Qlik Community - 1729651

You can check the release notes here: Release Notes | Qlik Community

And User Guide here (change the version at the top left for the version you are installing): Start | Qlik Replicate Help

Supported server, endpoint and drivers are documented here.

Thanks,

Dana

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

wali — Fri, 08 Nov 2024 16:57:48 GMT

@Dana_Baldwin @john_wang @kng @SushilKumar @Shashi.Holla@qlik.com

Thanks to Shashi's help, I have downloaded Qlik Replicate version: 2023.5.0.1055. while there is no compatible Qlik Manager thus, have to update each task by adding "supportNewV19CompressionFeatures" to each task in order to resolve the issue.

Please let me know when the GA version is available for Replicate and Manager.

Thank you

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

john_wang — Sat, 09 Nov 2024 02:11:42 GMT

Thank you for the update @wali , we will keep you posted on the GA version progress.

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

john_wang — Wed, 13 Nov 2024 14:33:33 GMT

Hello @wali ,

Both 2023.11 SP05 and 2024.5 SP03 patches are formal released. Please check the articile after installing Oracle July 2024 patch to download them.

Thanks,

John.