Cannot support operations that write to the log file

Hello Everyone,

We’re encountering an issue where some events remain open in SQL, even after the corresponding flag becomes false.

Upon investigation, we found the following errors:
1. "The current transaction cannot be committed and cannot support operations that write to the log file."

2. "Execution Timeout Period Exceeded"

However, after checking the transaction log's max size, we confirmed that it is well within its limit.

Does anyone have insights on how we can resolve this?

Thank you in advance.