Quick question; the difference between h_current_state 3 & 4 on h_bpm_instance table please?

[Berto2002]

SELECT * FROM h_bpm_instance
where h_current_state = "4" OR "3"

Is 3 that the BPM is cancelled and 4 Suspended? A link to documentation would be nice but cannot find this in Hornbill Documentation

Both seem to show in the "suspended" section of the Manage Executed Processes and on inspection both types seem to be on a node that is 'waiting' for something (like feedback or priority etc). Autotask config for the open BPM button is to open this URL: https://live.hornbill.com/xxx/admin/app/com.hornbill.servicemanager/manage-executed-processes/![[h_bpm_id]]

When I click the Autotask link I have set-up to open the BPM from the Request, I see this: the BPM is listed in the SUSPENDED category

...but when I click the Managed Executed Process and search, that BPM is not in Suspended, it is in Cancelled/Failed:

The h_current state is 3 in database direct.

So I'm seeking assurance that status '3' is cancelled and wondering why it shows in as Suspended when opening the BPM ID from the Request.

 

[Steve G]

@Berto2002

That's correct, 3 is cancelled and 4 is suspended. The column contains a value of type bpmStateType, documented here: https://docs.hornbill.com/esp-api-api/types/simple/bpmStateType 

The display values listed in the above link match with DB values 0 through to 4. Improving the reportability of the schema (and in turn, the documentation of it) is something that is being discussed internally, but hope this helps for the time being.

Cheers,

Steve

[Berto2002]

Thanks Steve, that's assuring.

On the question of the Autotask URL (https://live.hornbill.com/xxx/admin/app/com.hornbill.servicemanager/manage-executed-processes/![[h_bpm_id]]), we are seeing a 'quirk' that it always opens the BPM ID under the 'path' of "Suspended" (see highlighted above) rather than the actual 'path' for that BPM... is this something to report back for improvement? For example in the case of a BPM ID that is cancelled, the URL should open with the 'path', "Manage Executed Workflows / Cancelled / ..."?

[Steve G]

@Berto2002 Didn't see your post edit until I'd replied  

Yeah that should be reported into the BPM area of the forums, then one of the relevant devs can pick that up for comment.

Cheers,

Steve