FInding Flow from Active Cluster Transactions

Community Alums
Not applicable

‎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.

 

 

Preview file
46 KB
0 Helpfuls
  • 1,302 Views
2 REPLIES 2

Maik Skoddow
Tera Patron
Tera Patron

‎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

0 Helpfuls

Tai Vu
Kilo Patron
Kilo Patron

‎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.

 

KB0817583 - Slowness because of high memory contention when the job 'Flow Engine Event Handler' is running

KB0963437 - Flow Engine Event Handler with job_context null results in additional unnecessary jobs

 

Cheers,

Tai Vu