Replicate task finishing with error when targerting BigQuery as Endpoint

[marcomello]

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 ! 

[Madhavi_Konda · Accepted solution]

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