Qlik Replicate Primary key with NULL values in CT tables due to Oracle October 2023 patch

[Michael_Litz]

When Qlik Replicate runs in CDC mode and CT tables are enabled, primary keys are replicated as null values in the CT tables.

Base tables are not affected by this.

The Oracle patch from the 19th of October 2023 changed the redo log format around how they log before images. Qlik has issued a patch (2023.5 SP5) to read the new format correctly.

Resolution

A fix has been provided in Qlik Replicate 2023.5 SP5 and 2023.11 SP1.

Download and install one of the provided patches:

• Qlik Replicate 2023.5 SP05
  
  Public download link: https://files.qlik.com/url/qr2023050701sp05 (expires 5/31/2024)
  
  Once this download link expires, a patch will be made available on the Qlik download page.
  
  
• Qlik Enterprise Manager 2023.5 SP05
  
  Included if you are using Qlik Enterprise Manager to match the version with Qlik Replicate.
  
  Public download link: https://files.qlik.com/url/qem2023050614sp05 (expires 5/31/2024)
  
  Once this download link expires, a patch will be made available on the Qlik download page.

Environment

Qlik Replicate May, version 2023.5.0.516 and earlier.

Qlik Replicate 2023.11.0.159 (GA)

[ibrahim_sandalli]

Hi,

Could we anticipate that this subject has been resolved in version November 2023 SR2 (2023.11.0.468)?

Best Regards,

Ibrahim

[john_wang]

Hello Ibrahim, @ibrahim_sandalli 

Qlik Replicate patches are accumulative , all previous fixes will be included in a newer build.

In you case, as the fix was introduced in 2023.11 SP1, it will be included in 2023.11 SP2 too.

BTW, if you are planning to upgrade Qlik Replicate, we'd like suggest you to upgrade to the latest build, the latest build for 2023.11 is SP4:

https://files.qlik.com/url/qr2023110547sp04 (expires 8/31/2024)

Hope this helps.

John.