https://community.qlik.com/t5/Qlik-Replicate/Replicate-task-finishing-with-error-when-targerting-BigQuery-as/m-p/1719416#M263 <P>Hi,</P><P>Based on the log,<BR />00009500: 2020-06-15T20:00:12 [SORTER ]I: There is no saved state for sorter (sorter.c:530)</P><P>Did you try to resume your task from the timestamp(run-&gt;advanced run options-&gt;Tables are already loaded. Start processing changes from)</P><P>Thanks,<BR />Madhavi</P> Tue, 16 Jun 2020 20:32:54 GMT Madhavi_Konda 2020-06-16T20:32:54Z https://community.qlik.com/t5/Qlik-Replicate/Replicate-task-finishing-with-error-when-targerting-BigQuery-as/m-p/1719022#M255 <DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">Hello folks,&nbsp;</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">&nbsp;</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">I'm attempting to replicate some data to Google BigQuery, but the task keeps failing with the errors below, any clues about it ?&nbsp;</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">&nbsp;</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">Replicate <SPAN>6.6.0.177</SPAN></DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">&nbsp;</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected"><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">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)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00010816: 2020-06-15T20:00:11 [TARGET_APPLY ]I: ODBC driver version: '2.2.3.1000' (ar_odbc_conn.c:612)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00010816: 2020-06-15T20:00:12 [TARGET_APPLY ]I: ODBC driver version: '2.2.3.1000' (ar_odbc_conn.c:612)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00010816: 2020-06-15T20:00:12 [TARGET_APPLY ]I: Target endpoint 'bigquery' is using provider syntax 'BigQuery' (provider_syntax_manager.c:832)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00000992: 2020-06-15T20:00:12 [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 1, status 70005 (replicationtask.c:2938)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00009500: 2020-06-15T20:00:12 [SORTER ]I: There is no saved state for sorter (sorter.c:530)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00009500: 2020-06-15T20:00:12 [SORTER ]I: 'Stop reading when memory limit reached' is set to false (sorter.c:645)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects"><SPAN class="rColor">00010816: 2020-06-15T20:00:12 [TASK_MANAGER ]E: Failed while preparing stream component 'st_0_TGT - BigQuery'. [70005] (subtask.c:825) </SPAN></DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects"><SPAN class="rColor">00010816: 2020-06-15T20:00:12 [TASK_MANAGER ]E: Cannot initialize subtask [70005] (subtask.c:1269) </SPAN></DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects"><SPAN class="rColor">00010816: 2020-06-15T20:00:12 [TARGET_APPLY ]E: Stream component 'st_0_TGT - BigQuery' terminated [70005] (subtask.c:1537) </SPAN></DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00000992: 2020-06-15T20:00:12 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:603)</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects"><SPAN class="oColor">00000992: 2020-06-15T20:00:12 [TASK_MANAGER ]W: Task 'MySQL para BigQuery' encountered a recoverable error (repository.c:5704) </SPAN></DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">00000992: 2020-06-15T20:00:17 [SERVER ]I: Stop server request received internally (server.c:2333)</DIV></DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects textRecordSelected">Best regards !&nbsp;</DIV><DIV class="tvRow ng-binding ng-scope ng-isolate-scope fontEffects">&nbsp;</DIV> Tue, 16 Jun 2020 00:12:34 GMT https://community.qlik.com/t5/Qlik-Replicate/Replicate-task-finishing-with-error-when-targerting-BigQuery-as/m-p/1719022#M255 marcomello 2020-06-16T00:12:34Z https://community.qlik.com/t5/Qlik-Replicate/Replicate-task-finishing-with-error-when-targerting-BigQuery-as/m-p/1719416#M263 <P>Hi,</P><P>Based on the log,<BR />00009500: 2020-06-15T20:00:12 [SORTER ]I: There is no saved state for sorter (sorter.c:530)</P><P>Did you try to resume your task from the timestamp(run-&gt;advanced run options-&gt;Tables are already loaded. Start processing changes from)</P><P>Thanks,<BR />Madhavi</P> Tue, 16 Jun 2020 20:32:54 GMT https://community.qlik.com/t5/Qlik-Replicate/Replicate-task-finishing-with-error-when-targerting-BigQuery-as/m-p/1719416#M263 Madhavi_Konda 2020-06-16T20:32:54Z