Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
marcomello
Employee
Employee

Replicate task finishing with error when targerting BigQuery as Endpoint

Hello folks, 
 
I'm attempting to replicate some data to Google BigQuery, but the task keeps failing with the errors below, any clues about it ? 
 
Replicate 6.6.0.177
 
00010816: 2020-06-15T20:00:10 [TARGET_APPLY ]I: Going to connect to ODBC connection string: DRIVER=Simba ODBC Driver for Google BigQuery;OAuthMechanism=0;Email=;KeyFilePath=C:\Program Files\Attunity\Replicate\data\tasks\MySQL para BigQuery\10816.json;Catalog=qdidemo; (odbc_endpoint_imp.c:2761)
00010816: 2020-06-15T20:00:11 [TARGET_APPLY ]I: ODBC driver version: '2.2.3.1000' (ar_odbc_conn.c:612)
00010816: 2020-06-15T20:00:12 [TARGET_APPLY ]I: ODBC driver version: '2.2.3.1000' (ar_odbc_conn.c:612)
00010816: 2020-06-15T20:00:12 [TARGET_APPLY ]I: Target endpoint 'bigquery' is using provider syntax 'BigQuery' (provider_syntax_manager.c:832)
00000992: 2020-06-15T20:00:12 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 1, status 70005 (replicationtask.c:2938)
00009500: 2020-06-15T20:00:12 [SORTER ]I: There is no saved state for sorter (sorter.c:530)
00009500: 2020-06-15T20:00:12 [SORTER ]I: 'Stop reading when memory limit reached' is set to false (sorter.c:645)
00010816: 2020-06-15T20:00:12 [TASK_MANAGER ]E: Failed while preparing stream component 'st_0_TGT - BigQuery'. [70005] (subtask.c:825)
00010816: 2020-06-15T20:00:12 [TASK_MANAGER ]E: Cannot initialize subtask [70005] (subtask.c:1269)
00010816: 2020-06-15T20:00:12 [TARGET_APPLY ]E: Stream component 'st_0_TGT - BigQuery' terminated [70005] (subtask.c:1537)
00000992: 2020-06-15T20:00:12 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:603)
00000992: 2020-06-15T20:00:12 [TASK_MANAGER ]W: Task 'MySQL para BigQuery' encountered a recoverable error (repository.c:5704)
00000992: 2020-06-15T20:00:17 [SERVER ]I: Stop server request received internally (server.c:2333)
Best regards ! 
 
Labels (1)
1 Solution

Accepted Solutions
Madhavi_Konda
Support
Support

Hi,

Based on the log,
00009500: 2020-06-15T20:00:12 [SORTER ]I: There is no saved state for sorter (sorter.c:530)

Did you try to resume your task from the timestamp(run->advanced run options->Tables are already loaded. Start processing changes from)

Thanks,
Madhavi

View solution in original post

1 Reply
Madhavi_Konda
Support
Support

Hi,

Based on the log,
00009500: 2020-06-15T20:00:12 [SORTER ]I: There is no saved state for sorter (sorter.c:530)

Did you try to resume your task from the timestamp(run->advanced run options->Tables are already loaded. Start processing changes from)

Thanks,
Madhavi