Hi,
Is there a quick way to check which processes are light processes? I know that light processes don't get logged in outsystems service center. But I'm not looking for that information. I only need to know which processes are light processes because our Service Center > Monitoring > Environment Health is telling us that there are 23 errors on light processes but I have to know which processes are light so I can investigate why they are throwing errors.
Regards,
Bo
Hi @Bo Menick ,
this page describes the condition under which a process gets executed as a light process.
You can query the system tables for a lot of this, i made you a little sample, i haven't tested it, just to give you an idea where to start.
The only thing i couldn't find is how the "Expose Process Entity" choice could be found in the system tables, so the query I made now could still give you some false positives, but I would expect it to narrow down the field considerably.
I would like some feedback if this actually helps any, I don't have any light bpt processes in my personal environment, so didn't test.
Dorine
Hi Dorine,
Thank you for all the information and the example you posted here. I tested the aggregate and it worked perfectly. I looked into the aggregate what you actually did and I get most of it. The only thing that I don't understand is the 4th filter (Espace_Configuration.Name = "BPT.EnableLightProcessExecution"andEspace_Configuration.Val = "True").
Could you explain to me what this one does? I'm not sure but I think an espace has multiple espace configurations? And that you're looking with the combination of espace_configuration.name and val to check if the lightprocessexecution is enabled? Correct me if I'm wrong.
Thanks in advance.
That's exactly it, the option must be enabled at espace level (in service center), and this is stored in the configuration table. An espace has a 1-many with it's possible configurations, so you have to pick out the correct one with the configuration name, and then you can check if it's value is set to True
HI! The "Expose Process Entity " is in the entity "Entity"
The last field in the image.
Regards
Graça
thanks Maria,
it is actually the other direction i mean, what you are showing is about exposing process events on an entity, so you could use it as a trigger to for example launch a process.
But i mean exposing an entity for the process, so you could track and query details of the process, such as it's input parameters. I can't find that as an attribute anywhere. You can of course find the automatically created entity, and it by default has a name derived from the process, but i think you can change that name, so I can't use that.
The"Launch on" entity is the last field from the "Process_Definition" entity
i know, and the ones you can choose from are the entities that have the option "Expose_Process_Events" you are talking about set to true, that part is no problem.
It is the option on the process to expose the process entity (it should be 'No' for light bpt) that i can't find in the metamodel. I could start looking for an entity with some name like "process....." but I think you can change the name of that entity, so that would not be a good way to do it.
Hi Bo Menick ,
In the bellow article you can check in detail how LBPT works.
https://www.outsystems.com/forums/discussion/41063/light-processes-under-the-hood/
Get the PROCESS_DEF_ID of your entity
and using the systems tables
Do an aggregate to extract the processes
filter by PROCESS_DEF_ID
Hope that it helps you
Hi, I know this is an old post, but here's the way I managed to get the same count as the Service Center light events error count:
select * from ossys_BPM_Process_Definition pd inner join ossys_BPM_EVENT e on pd.Id = e.Process_Def_Idwhere e.Error_Count > 0 and pd.Process_Entity_Id is not null and pd.Is_Active=1and e.Dequeue_Time is null