- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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
Views
Replies
Total Likes