Avatar

Correct answer by
Level 3

Hi Vipul Raghav​ ,

I have found the actual problem for which I was looking for details around this cleanup workflow.

Basically, the workflow in our instance used to fail regularly without any details in the logs (xtkworkflowlog). Finally we identified that the session which insert data in xtkworkflowlog table has been timed out.
We have DB idle time out setting as 30 mins, now hypothesis what I have build is that the session which writes data in logs (xtkworkflowlog) is waiting for response from actual workflow task, which if has been running for more than 30 min then due to inactivity - it may be getting idle and thus getting timed out. So when the activity gets completed it gives response to the primary session which was already timed out and thus workflow fails.

So I wanted to understand how wfserver manages the session, I could not find any documentation and would be helpful if someone can help with it.

I have asked separate question for this as well Workflow execution/DB session management

Ankit

View solution in original post