Table Cleaner Stopped working

[PriyaVerma]

Table Cleaner stopped working, it appears to have timed out. Basically, If table cleaner rule has a query that takes longer than 30 seconds to complete, the entire table cleaner job is stopped and by default, table cleaner waits two days before table cleaner job runs again. 

 So Is there any way to run table cleaner again without having to wait the two days ? 

[AnirudhKumar]

How many records do you have? Just open the table configuration and click Delete Records button.

Or if you want to selectively delete, write a fix script with deleteMultiple().

You don't have to wait 2 days, or use the Table Cleaner at all 😉 

[Dhruv Chandan]

Hi Priya,

Did you got a chance to review the property "glide.db.tablecleaner.chunk_delete_max_time_spent" ?

Link: https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/managing-dat...

Hope this property helps.

Thanks,
Dhruv

[Mark Roethof]

Hi there,

Table Cleaner itself doesnt wait for 2 days. Only that specific rule waits for 2 days, or that's what I thought. Table Cleaner should just run according to the normal interval which is usually 1 hour.

If you want to influence the slow rule attempt:

glide.db.tablecleaner.days_before_slow_rule_reattempt

[PriyaVerma]

But slow rule attempt property will impact all auto flush rules and I do not want that. Is there anything can I do with specific rule so that it can run again ?