Error "Archived Redo log with the sequence 11361 does not exist"

Tu_Nguyen_JF — Wed, 09 Nov 2022 03:32:09 GMT

Hi,

On Qlik Replicate, I set up a task to migrate data from my Oracle data source Endpoint into Log Stream Endpoint.

Whenever the task starts (or resumes), the progress is smooth with no errors. But, sometimes the task stops by itself (or when I stop manually), and I have to check the log file on Qlik Replicate to look into what had happened.

Here's the log whenever the task stopped:

00006012: 2022-11-09T09:55:43 [SORTER ]I: Final saved task state. Stream position 0000001a.49ecc4c6.00000001.0000.00.0000:11361.13898.16, Source id 1196080, next Target id 411429, confirmed Target id 411425, last source timestamp 1665745235000000 (sorter.c:771)
00001300: 2022-11-09T09:56:01 [SOURCE_CAPTURE ]E: Archived Redo log with the sequence 11361 does not exist, thread 1 [1022318] (oradcdc_thread.c:933)
00001300: 2022-11-09T09:56:01 [SOURCE_CAPTURE ]E: Error executing source loop [1022316] (streamcomponent.c:1919)
00001300: 2022-11-09T09:56:01 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_VIET_01_ORCL_FARMICDB_RDS [1022316] (subtask.c:1396)
00001300: 2022-11-09T09:56:01 [SOURCE_CAPTURE ]E: Stream component 'st_0_VIET_01_ORCL_FARMICDB_RDS' terminated [1022316] (subtask.c:1565)
00003984: 2022-11-09T09:56:02 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:591)
00003984: 2022-11-09T09:56:07 [TASK_MANAGER ]I: Task management thread terminated (replicationtask.c:4382)
00003792: 2022-11-09T09:56:07 [SERVER ]I: Client session (ID 530658983) closed (dispatcher.c:195)
00003792: 2022-11-09T09:56:08 [UTILITIES ]I: The last state is saved to file 'D:\Attunity\Replicate\data\tasks\VIET_SFCDC_01_ORCL_LS_GODIRECT/StateManager/ars_saved_state_000002.sts' at Wed, 09 Nov 2022 02:55:43 GMT (1667962543184312) (statemanager.c:642)
00002796: 2022-11-09T09:56:08 [SERVER ]I: The process stopped (server.c:2520)
00002796: 2022-11-09T09:56:08 [AT_GLOBAL ]I: Closing log file at Wed Nov 09 09:56:08 2022 (at_logger.c:2543)

I'm not sure how to handle this error. Can anyone explain what caused this error and give me a solution?

I have the log file attached in this post.

Re: Error "Archived Redo log with the sequence 11361 does not exist"

lyka — Wed, 09 Nov 2022 03:54:51 GMT

Hello,

Please refer to this article:

https://community.qlik.com/t5/Official-Support-Articles/Replicate-using-Oracle-source-fails-with-missing-redo-log/ta-p/1779064

Hope this helps!

Thanks
Lyka

topic Re: Error "Archived Redo log with the sequence 11361 does not exist" in Qlik Replicate

Error "Archived Redo log with the sequence 11361 does not exist"

Re: Error "Archived Redo log with the sequence 11361 does not exist"