A lot of "Process Management Change Case did not receive an ID" log appearing ...

Hi Enes Saridogan,

Thank you for asking this question.

This challenge is correlated to Issue 85751. This Issue will be fixed in 13.0.0

When this symptom occurs, this query to find out which process is orphaning flow rows:
SELECT pro_id a, count(*) b FROM `pmse_bpm_flow` where cas_id is null GROUP BY a ORDER BY b DESC;

This query to delete them:
DELETE FROM `pmse_bpm_flow` where cas_id is null;

The processes associated with the results should be reviewed. If you would like assistance reviewing them, I recommend filing a support case and our team can help you further.

Regards,
Patrick McQueen
Director, SugarCRM Support

Hi Enes Saridogan,

Thank you for asking this question.

This challenge is correlated to Issue 85751. This Issue will be fixed in 13.0.0

When this symptom occurs, this query to find out which process is orphaning flow rows:
SELECT pro_id a, count(*) b FROM `pmse_bpm_flow` where cas_id is null GROUP BY a ORDER BY b DESC;

This query to delete them:
DELETE FROM `pmse_bpm_flow` where cas_id is null;

The processes associated with the results should be reviewed. If you would like assistance reviewing them, I recommend filing a support case and our team can help you further.

Regards,
Patrick McQueen
Director, SugarCRM Support

Hello Patrick McQueen,

Thanks for the feedback. I just ran the query on the database and we have more than 21 millions of orphan records : 

I think the hard delete like you wrote would cause me a timeout, I have to be more specific I think, or find another approach.

pmse_inbox and pmse_bpm_flow are more thant 65Gb gross :/