Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,545 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