topic The task stopped abnormally replicating Oracle tables in Qlik Replicate

The task stopped abnormally replicating Oracle tables

gm908 — Thu, 17 Oct 2024 21:02:28 GMT

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?

Re: The task stopped abnormally replicating Oracle tables

Dana_Baldwin — Thu, 17 Oct 2024 22:38:25 GMT

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-Release-until/ta-p/2110765

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

Re: The task stopped abnormally replicating Oracle tables

Dana_Baldwin — Thu, 17 Oct 2024 23:06:55 GMT

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

Re: The task stopped abnormally replicating Oracle tables

DesmondWOO — Fri, 18 Oct 2024 02:42:36 GMT

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

Re: The task stopped abnormally replicating Oracle tables

Kent_Feng — Fri, 18 Oct 2024 05:08:10 GMT

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