The task stopped abnormally replicating Oracle tables

[gm908]

We're attempting to replicate multiple Oracle tables in CDC and the task is suddenly failing. The log doesn't contain any warning, and the job is suspended due to 6 successive unexpected failures when we restart. Is there a way to identify what the issue is?

[Dana_Baldwin]

Hi @gm908 

If you have applied Oracle July 2024 security patch this is a known issue that we have released a patch for, please refer to this article. Patches are available only for version 2023.11 and 2024.5: Qlik Replicate tasks crash due to changes to the r... - Qlik Community - 2475965

You can download them here:

https://files.qlik.com/url/dityjagjqigveh4j
password: s1442g2m

If you are upgrading, please check the release notes for operating system support, source/target endpoint support including version, and versions of the drivers supported.

https://community.qlik.com/t5/Release-Notes/Qlik-Replicate-Release-Notes-November-2023-Initial-Relea...

Start | Qlik Replicate Help user guide for 2023.11

https://community.qlik.com/t5/Release-Notes/Qlik-Replicate-May-2024-Initial-Release/ta-p/2487023

Start | Qlik Replicate Help user guide for 2024.5

[Dana_Baldwin]

@gm908 Please note that after applying the fixed version you most likely will need to start the tasks by timestamp as there may be cached changes on disk with the troublesome transactions. You may want to set apply changes error handling for duplicate records to update the existing record to avoid hitting PK constraints.

[DesmondWOO]

Hi @gm908 ,

Please enable VERBOSE logging on SOURCE_CAPTURE to get more information from log. If the problem persists, I recommend submitting a support ticket.

Regards,
Desmond

[Kent_Feng]

Hi @gm908 

As mentioned, the job is suspended due to 6 successive unexpected failures, did the task crash 6 times and then restart by itself? If so, you may need to address the crash issues.

Please check Debugging Qlik Replicate Crashes to collect dumps and verbose logs first, then open a support ticket.

Thanks

Kent