Remove SugarBPM Processes

Does anyone have the SQL queries for removing SugarBPM process instances. I thought i had them but am unable to find them.

It would be nice if this was able to be done in the Data Archiver like  discussed: Data archiver: remove records older than x days

Parents
  • Hi John,

    Thanks for asking this.

    In Damien's post, the main challenge was not that the data can't be hard-deleted in the Data Archiver, but that there was not a dynamic filter, so a user would have to manually come in and change the before date in the filter and rerun it each time.

    I recommend using Data Archiver for your stated purpose, as it is doable there.

    Regards,
    Patrick McQueen
    Director, SugarCRM Support

  • Hello Patrick,

    Can you ensure us that all the related tables records' would be deleted as well as the pmse_inbox table ?

    We are facing an issue with one of our customer, pmse_inbox is 29Gb gross, pmse_bpm_flow 36 Gb...

    I have no solution than deleting the data step by step.

    Thanks for your feedback.

    Best regards,

    Enes

  • Hi ,

    My understanding of the Data Archiver functionality when 'pmse_Inbox' is the selected module is that it cleans up the following tables at a minimum:

    pmse_inbox
    pmse_bpm_flow
    pmse_bpm_thread

    There is an enhancement (90933) to change the label from 'pmse_Inbox' to a label more appropriate to indicate it has a wider application than the pmse_inbox table. 

    Chris

Reply Children
No Data