FInding Flow from Active Cluster Transactions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2023 08:28 AM
We have a long running transaction in the Active Cluster Transactions table. I am need help determining what object is running. I can see from the URL it is Flow Engine Event Handler. But I am trying to understand if this is a specific flow or jus the process in general. Acttached is the screen shot of the record.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2023 07:06 PM
Hi @Community Alums
to find the responsible Flow you can go to table sys_flow_context and check the state to identify still running flows. Or you sort by "Runtime" to bring long-running flows to the top of the list.
Maik
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-05-2023 08:08 PM - edited 12-05-2023 08:17 PM
Hi @Community Alums
In the Active Cluster Transaction [v_cluster_transaction] table, there's a field named System ID of the transaction. This field stores the sys_id value of the record in the Transaction Log [syslog_transaction] table.
So let's pull out this field in the list, then copy the sys_id and you can find the record in the Transaction Log. You might have some additional insight there.
KB0963437 - Flow Engine Event Handler with job_context null results in additional unnecessary jobs
Cheers,
Tai Vu