SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Emily_Liu — Fri, 01 Jul 2022 03:32:28 GMT

Help, This task SQL 2019 to SQL 2019 ERROR,Full reload task is normall

0010888: 2022-06-30T15:52:49 [SORTER ]I: Start the task using saved state. Start source from stream position 0000046A:000085D9:0002 and id 1. Confirmed target id is 0, next target id is 1 (sorter.c:386)
00010888: 2022-06-30T15:52:49 [SORTER_STORAGE ]I: Swap files were loaded. Next target id to be assigned is 1. Next swap file id is 1 (transaction_storage.c:178)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: All stream components were initialized (replicationtask.c:2032)
00010888: 2022-06-30T15:52:49 [SORTER ]I: Transaction consistency reached (sorter_transaction.c:212)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: Starting replication now (replicationtask.c:1797)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: Starting subtask #1 (replicationtask_util.c:862)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: Starting subtask #2 (replicationtask_util.c:862)
00032232: 2022-06-30T15:52:49 [SOURCE_CAPTURE ]E: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)
00023832: 2022-06-30T15:52:49 [SOURCE_UNLOAD ]I: NLS configuration sampled: Associated code page=936 (sqlserver_endpoint_imp.c:1823)
00030140: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1346)
00030140: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Going to connect to server VTCNSZXWMSDBP02,5536 database WMS_WD (sqlserver_endpoint_imp.c:1389)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: Starting subtask #3 (replicationtask_util.c:862)
00032232: 2022-06-30T15:52:49 [SOURCE_CAPTURE ]E: Unknown '0' native error detected while SQL_ERROR is flagged / SQLSTATE is not empty. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3661)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: Starting subtask #4 (replicationtask_util.c:862)
00032232: 2022-06-30T15:52:49 [SOURCE_CAPTURE ]E: sqlserver_capture_source_loop(...) encountered an unexpeceted error. [120102] Stream Component recoverable error. (sqlserver_endpoint_capture.c:740)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]E: Task error notification received from subtask 0, thread 0 [120102] Stream Component recoverable error. (replicationtask.c:1872)
00029396: 2022-06-30T15:52:49 [TASK_MANAGER ]I: Task 'NewCDD-TASK' encountered a recoverable error (repository.c:4005)
00032232: 2022-06-30T15:52:49 [SOURCE_CAPTURE ]E: Error executing source loop [120102] Stream Component recoverable error. (streamcomponent.c:1465)
00010888: 2022-06-30T15:52:49 [SORTER ]I: Final saved task state. Stream position 0000046A:000085D9:0002, Source id 1, next Target id 1, confirmed Target id 0 (sorter.c:536)
00032232: 2022-06-30T15:52:49 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_WMSDBP01 [120102] Stream Component recoverable error. (subtask.c:1344)
00019328: 2022-06-30T15:52:49 [SOURCE_UNLOAD ]I: NLS configuration sampled: Associated code page=936 (sqlserver_endpoint_imp.c:1823)
00012476: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1346)
00012476: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Going to connect to server VTCNSZXWMSDBP02,5536 database WMS_WD (sqlserver_endpoint_imp.c:1389)
00032232: 2022-06-30T15:52:49 [SOURCE_CAPTURE ]E: Stream component 'st_0_WMSDBP01' terminated [120102] Stream Component recoverable error. (subtask.c:1509)
00024452: 2022-06-30T15:52:49 [SOURCE_UNLOAD ]I: NLS configuration sampled: Associated code page=936 (sqlserver_endpoint_imp.c:1823)
00022576: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1346)
00022576: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Going to connect to server VTCNSZXWMSDBP02,5536 database WMS_WD (sqlserver_endpoint_imp.c:1389)
00031276: 2022-06-30T15:52:49 [SOURCE_UNLOAD ]I: NLS configuration sampled: Associated code page=936 (sqlserver_endpoint_imp.c:1823)
00023068: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Bulk is set to ignore max row size warnings (sqlserver_endpoint_imp.c:1346)
00023068: 2022-06-30T15:52:49 [TARGET_LOAD ]I: Going to connect to server VTCNSZXWMSDBP02,5536 database WMS_WD (sqlserver_endpoint_imp.c:1389)
00029396: 2022-06-30T15:52:54 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:925)
00029396: 2022-06-30T15:52:54 [TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:925)
00029396: 2022-06-30T15:52:54 [TASK_MANAGER ]I: Subtask #2 ended (replicationtask_util.c:925)
00029396: 2022-06-30T15:52:54 [TASK_MANAGER ]I: Subtask #3 ended (replicationtask_util.c:925)
00029396: 2022-06-30T15:52:54 [TASK_MANAGER ]I: Subtask #4 ended (replicationtask_util.c:925)

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

HOX — Fri, 01 Jul 2022 14:55:10 GMT

Hello Emily

This error is usually seen when the task is timing out on a query to the backup tlogs.
Please open the MSSQL source endpoint, Advanced tab-->Internal parameters and increase executeTimeout from 300 seconds to 900. Save and resume the task.

After saving the internal parameter can you please update us?

Please let us know your thoughts,

Thanks,

Regards,

Jose Perez Torres

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

HOX — Fri, 01 Jul 2022 14:57:18 GMT

Hello Emily,

If the error persists, please open a Case and send us the Package logs with SOURCE_CAPTURE in TRACE

Task settings/ Logging/ Logging Level/ SOURCE_CAPTURE to TRACE save and resume the task

Thanks,

Regards,

Jose Perez Torres

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

SwathiPulagam — Fri, 01 Jul 2022 14:58:22 GMT

Hi @Emily_Liu ,

If the test connection worked then please open a case keeping source_capture in verbose log.

Thanks,

Swathi

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Dana_Baldwin — Wed, 06 Jul 2022 23:55:47 GMT

Hi @Emily_Liu

If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.

Thanks in advance!

Dana

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Bill_Steinagle — Fri, 11 Nov 2022 12:53:15 GMT

Emmily,

Thank you for the post to the QDI Forums. For the SQL Server connection can you check to see if the Connection String and you are using the Listener to do the Connection to this Source?

Thanks!

Bill

topic Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660) in Qlik Replicate

SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)

Re: SqlStat: Can't retrieve exception Information. [120102] Stream Component recoverable error. (sqlserver_log_processor.c:3660)