Purging Process monitor logs with a cut off date does not delete / purge the logs

Version 1

    Details

    Purging Process monitor logs with a cut off date does not delete / purge the logs  1. Tools >> Logs >> GoldMine Logs 2. Right Click on Process Monitor Logs >> Purge Logs 3. Leave the Cutoff Date as set (by default one month back) or set it to a day in the past e.g. by opening the Calendar lookup >> and selecting the desired date in the past >> Select 4. OK 5. Observe/Verify the Process Monitor   Result: Regardless which date in the past was set as a Cutoff Date the Process Monitor will always report:
    Process Monitor Logs deleted: 0


    Resolution

    [CAUSE]
    - This is RM issue # 153152.

    [WORKAROUND]

    A. Purge ALL Process Monitor Logs 

    This might be the easiest way and can be done within the GoldMine interface but it must be kept in mind that ALL Process Monitor Logs are purged.

    1. Tools >> Logs >> GoldMine Logs
    2. Right Click on Process Monitor Logs >> Purge Logs
    3. Set the Cutoff Date into the future e.g. by opening the Calendar lookup >> right arrow button below Year >> Select
    4. OK
     

    B. Purge Process Monitor Logs via the Microsoft SQL Server back end  
    This workaround is officially not supported but as Process Monitor log data are not contact or other data related, they can be deleted by an experienced Microsoft SQL Server DBA via the back end:  MAKE SURE TO HAVE A FULL RUNNING BACKUP OF THE GOLDMINE DATABASE BEFORE APPLYING ANY STEP OF THE BELOW WORKAROUND!!!  1. In SQL Server Management Studio >> New Query (make sure to be on the appropriate GoldMine database) 2. copy/paste and execute the following query to get a list of Process monitor entries in the SYSLOG table  Select * from SYSLOG where RECTYPE = P' 3. copy/paste and execute the following query to delete all Process monitor entries in the SYSLOG table Delete from SYSLOG where RECTYPE ='P'  if desired adjust and limit the select/deletion query with a ONDATE < Getdate()-amount of desired days (e.g. 365 for all Process Monitor logs older than one year) e.g. Select * from SYSLOG where RECTYPE = P' and ONDATE < Getdate()-365 or
    Delete from SYSLOG where RECTYPE ='P'
    and ONDATE < Getdate()-365