long running transaction(s) are active. prompt in oracle db

[GOVINDARAMTEKKAR97]

Hi @ismailsimsek , I have successfully able to cdc through oracle database through debezium and iceberg and get parquet files into s3 bucket.
But while updating the data in tables I am getting prompt that is

##Offset SCN 4724827 has not changed in 25 mining session iterations. This indicates long running transaction(s) are active. Commit SCNs {1=5263894}.

I am not getting this prompt resulting can not get data in when I update data in tables.
Can you help me on this issue
Regards,
Govinda

[ismailsimsek]

@GOVINDARAMTEKKAR97 this is debezium related, could you post it there? you could post it to https://debezium.zulipchat.com

[GOVINDARAMTEKKAR97]

Hi @ismailsimsek , I have already added this issue but not getting solution, due you have any solution for that or need to add some parameter in application.properties files .
Please let me know if possible .
Regards,
Govinda

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.