Find process flows which are aborted or queued - database level

Question:

If we want to know the process flow names which are aborted how can we find?

 

Answer:

 

Adeptia stores the status of a process flow in "AU_ACTIVITYSTATUS" column and type of activity in "AU_ACTIVITYTYPE" column of "AU_TRANSACTIONDATA" table.

  1. If you want to get the process flow names which are aborted then you can use below condition in WHERE clause:

AU_ACTIVITYSTATUS = 'ABORTED' AND AU_ACTIVITYTYPE = 'Transaction'

  1. If you want to get the list of process flow names which are in queued state then you can use below condition in WHERE clause:

AU_ACTIVITYSTATUS = 'QUEUED' AND AU_ACTIVITYTYPE = 'Transaction'

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.