Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.