The task failed after resuming from a stop.

Titus — Sun, 24 Mar 2024 15:52:48 GMT

Hi ,
We experiancing below error after resuming stopped task manually. we are using SAP application as the source and Microsoft Azure Sql database as target.

[SOURCE_CAPTURE ]E: Log table was truncated, rowid 723822 does not exist [1024208] (saphana_trigger_based_cdc_log.c:1427)

Could you please help on this issue.

Thanks,
Titus

Re: The task failed after resuming from a stop.

DesmondWOO — Mon, 25 Mar 2024 02:05:52 GMT

Hi @Titus ,

Thank you for reaching out to Qlik Community.

Your error message means the row id does not exist anymore because the log table was truncated already. Could you can verify the row id by running following query:

SELECT 'V1:'||MIN("$rowid$")||':'||MAX("$rowid$")||':0:'||MIN("$rowid$") AS "STREAM POSITION" from "$SCHEMA$"."attrep_cdc_log" WHERE "CHANGE_EVENT_TIME" >= 'YYYY-MM-DD HH:MM:SS';

If the row id does not exist anymore, you should either reload the table or resume the task from the available row id.

Regards,
Desmond

topic Re: The task failed after resuming from a stop. in Qlik Replicate

The task failed after resuming from a stop.

Re: The task failed after resuming from a stop.