Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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