SAP Application as a source --Log table issue

[suvbin]

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.

[boaz_newman]

Hello

Please open a support case for this problem.

Thanks

Boaz

[suvbin]

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