mssql_execute_log_lsn_peeper(...) failed upon SQLExecute with LSN

[gopikrishnanS]

Hi All,

In my project using Qlik Data integration here as Source; Sql server, Target: snowflake

After full load of the DB. Iam getting the below errror. Kindly share your suggestions as soon as possible.

Task is running (sorter.c:714)

00008272: 2024-05-09T09:08:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:08:48.357. Last LSN scanned: 00234240:0000621e:0005. #scanned events: 4. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:10:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:08:48.357. Last LSN scanned: 00234240:0000621e:0005. #scanned events: 0. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:12:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:08:48.357. Last LSN scanned: 00234240:0000621e:0005. #scanned events: 0. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:14:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:13:49.073. Last LSN scanned: 00234240:00006221:0005. #scanned events: 4. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:16:52 [SOURCE_CAPTURE ]I: Throughput monitor: Last DB time scanned: 2024-05-09T10:13:49.073. Last LSN scanned: 00234240:00006221:0005. #scanned events: 0. (sqlserver_log_utils.c:4994)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: mssql_execute_log_lsn_peeper(...) failed upon SQLExecute with LSN parameters '0x00234240:00006221:0005','0x00234240:00006221:0005' [1020102] (sqlserver_log_queries.c:840)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: Encountered an unexpeceted error. Aborting... [1020102] (sqlserver_endpoint_capture.c:785)

00016960: 2024-05-09T09:18:42 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1020102 (replicationtask.c:3520)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: Error executing source loop [1020102] (streamcomponent.c:1942)

00008272: 2024-05-09T09:18:42 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_REGISBERMUDA_TEST- Financeapp1 [1020102] (subtask.c:1433)

00008272: 2024-05-09T09:18:42 [SOURCE_CAPTURE ]E: Stream component 'st_0_REGISBERMUDA_TEST- Financeapp1' terminated [1020102] (subtask.c:1602)

00016960: 2024-05-09T09:18:42 [TASK_MANAGER ]W: Task 'Regis BDA Qlik Replication' encountered a recoverable error (repository.c:6049)

00016528: 2024-05-09T09:18:42 [SORTER ]I: Final saved task state. Stream position 00234240:00006221:0005, Source id 170, next Target id 1, confirmed Target id 0, last source timestamp 1715260428863000 (sorter.c:781)

00016960: 2024-05-09T09:18:42 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:591)

[Dana_Baldwin]

Hi @gopikrishnanS 

This message means the LSN that the task needs to continue without missing data cannot be found in the online TLOG or backup TLOG. By default, the endpoint will look for it in both. What is your retention period for the backup TLOG?

Thanks,

Dana

[Heinvandenheuvel]

This is a Replicate specific question, not Enterprise Manager.

If you need more help then search the Replicate forum first. If still more help is needed then create a fresh topic there and include feedback on Dana's suggestion.

https://community.qlik.com/t5/Qlik-Replicate/bd-p/qlik-replicate-discussions

[SushilKumar]

Hello @gopikrishnanS 

Thanks for reaching out to Qlik via Qlik Community Support page. Such issue requires through analysis of TASK Settings/ ENDPOINT configuration, hence request you to reach out to technical Support via a case and provide Diagnostics package.

Please refer to Replicate https://community.qlik.com/t5/Knowledge/How-to-collect-Diagnostics-Package-from-Qlik-Replicate/ta-p/...

Regards,

Sushil Kumar

[DesmondWOO]

Hi @gopikrishnanS ,

We haven't heard from you for a few days. If problem persists, please enable verbose logging on SOURCE_CAPTURE to obtain more information about the error, and submit a support ticket to us.

Regards,
Desmond