OO 10.70 - Purge Debugger Events Not Purging Entirely even though lastXDays = 0

Hi!

OO 10.70

I noticed the my Purge Debugger Events, not clearing up my OO_DEBUGGER_EVENTS table entirely even though I set my lastXDays input param to 0... However, I get some results though like small amount of records deleted (e.g. 12, 2, 1)...
Here are my other settings: maxAmount = 100000 ; delayBetweenRequests = 15

Any advise? because I noticed my Database Consumption in Central keeps on increasing from time to time even though I scheduled my purge flows to run every 15 minutes for Execution and 30 minutes for Debugger...

Thanks in advance...

Dondon

 

 

Parents Reply
  • If the flow is returning -1 for records being deleted, it's probably because a previous run was canceled before it was finished, or because two instances of the flow were executed at the same time..

    The fix for me was to log into the database and clear the row that represented the lock, per:

    DELETE FROM OO_TABLE_LOCKS WHERE NAME = 'PURGE_ALL';
    -- then commit, depending on the DB platform...
    COMMIT;

     

Children