Qlik Replicate and Oracle source endpoint: Task crashes with "task stopped abnormally" due to inaccurate Secret Store Encryption Entries

Kent_Feng · Dec 7, 2023 4:21:45 AM

A Qlik Replicate task using Oracle as a source endpoint crashes during CDC (change data capture) with:

the task stopped abnormally

Task '<TaskName>' was suspended due to 6 successive unexpected failures

The task is set up to use Replicate Log reader with Secret store encryption entries, which is also called the Oracle Wallet encryption key provided by Oracle DBA used to encryption the redo logs.

Upon closer investigation, the task crashes once it detects data changes on the source. It will retry six times before stopping entirely.

Troubleshooting:

To troubleshoot the issue, set up a simple test task from Oracle to NULL with a test table that only has two columns. Then set the source_capture to verbose and review the resulting task logs:

[SOURCE_CAPTURE ]V: BI col 1194 [4]
{EAAAAMuRUdJHnByl3FIhQx4oLeDZZ784J9+jX5FfKjZCx7axRFEYsFHIhlDtQHeinZi0uRM8uRPWgRc3CaoRvoKcZHyQjtqP+Zu9C47tGUwrIltC} (oradcdc_parse.c:340)

The message 'BI col 1194' looks abnormal, as the table only has two columns, the column number in Before Image (BI) should not be as large as 1194. R&D suggested that the encryption value is incorrect.

Resolution:

Change the Oracle Wallet encryption key, then update the source endpoint with the new value:

Open the Oracle Source Endpoint
Go to Advanced
Update Secret store encryption entries with the new Name and Value:

Name: Oracle Wallet encryption key name
Values: Oracle Wallet encryption key value
Resume the task

Environment:

Qlik Replicate All versions
Source: Oracle 19 , instant client 12.2.0.1

Cause & Internal Investigation ID(s):

Jira: QB-23367

Qlik Replicate and Oracle source endpoint: Task crashes with "task stopped abnormally" due to inaccurate Secret Store Encryption Entries