SAP Application as a source --Log table issue

suvbin — Wed, 25 Oct 2023 05:38:40 GMT

Hi ,

Getting error stating "2023-10-21 error: Log table was truncated, rowid 5671070873 does not exist (saphana_trigger_based_cdc)"

There are 3 tasks which are in this state. all are only cdc tasks.

Few things i came to know that

-->rowid is like lsn number . so i can resume with this rowid from advance run options.

--> The error 'Log table was truncated, rowid <rowid_number_xxxxx> does not exist', is caused by the fact that Replicate is unable to find the logs when resuming the task. It depends on the Log retention period.

--> and to run the below query --> where to run this query , is it in the source end?

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'.

Here what is the change_event_time we have to specify.

the log retention period is set to 20 days in the source endpoint.

Tried resuming the task. But it failed again. Any possible solutions for this.

Thanks.

Re: SAP Application as a source --Log table issue

boaz_newman — Wed, 25 Oct 2023 07:55:18 GMT

Hello

Please open a support case for this problem.

Thanks

Boaz

Re: SAP Application as a source --Log table issue

suvbin — Fri, 27 Oct 2023 09:22:39 GMT

Got this link from Qlik community. Solved the issue.

https://community.qlik.com/t5/Official-Support-Articles/How-to-RESUME-Hana-trigger-based-CDC-task/ta-p/1835839

topic Re: SAP Application as a source --Log table issue in Qlik Replicate

SAP Application as a source --Log table issue

Re: SAP Application as a source --Log table issue

Re: SAP Application as a source --Log table issue