I have noticed that for some reason ‘enddatetime’ column in the BPASession table is NULL for some records.
Shouldn't ‘enddatetime’ column be always set to some value at the application level whenever the process stopped/completed/terminated or is pending for some reason?
A robot execution without an end date is definitely creating confusion, a process/robot execution has to come to an end, irrespective if its happy path or unhappy path.
As per the BPAStatus table, the process execution should have one of the status mentioned in the BPAStatus during the lifecycle of the process execution.
A execution/session not having an enddate while it is running make sense, but if I don't see an instance of the execution/session in control room as running/pending, then the expectation is that the session has attended some status, whether it completed/terminated/stopped/exception there should be an enddate, that's gives clarity, not having enddate gives an impression that the session/execution still has life.