Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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
Hi @Emily_Liu ,
If the test connection worked then please open a case keeping source_capture in verbose log.
Thanks,
Swathi
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
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