We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

FInding Flow from Active Cluster Transactions

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
  • 2,217 Views
2 REPLIES 2

Maik Skoddow
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

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

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

 

Cheers,

Tai Vu