Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.
AI OnAI Off
Error when trying to empty the recycle bin
Hi Sam,
Have you tried to run a scheduled job "Automatic Emptying of Trash"? It shouldn't time out.
Oct 24, 2016 11:57
When I tried running the scheduled task, it came up with the following error 'Connect failed'. I've been trying to work out of there is a SQL query that I can run directly on the database, but wanted to make sure that I don't leave loads of orphaned data in the DB.
Oct 24, 2016 12:14
Hi, Sam,
In case of many content items in the recycle bin, I'd suggest going to DB directly (Do back it up first). The timeout can be increased, however, if it's that many items, you'd need to increase it too much and it's valid for any other queries Epi executes.
So, instead, backup and run a SP called editDeleteChilds with page ID of recycle bin (usually 2).
Then, make sure to set up the scheduled job to get executed regularily :)
BR,
Marija
Oct 26, 2016 15:56
Hi Sam,
Agree with Marija but before that it is good idea to run this query " SELECT pkId, COUNT(*) FROM tblWorkPage GROUP BY pkID ORDER BY 2 DESC" and then from the sql result run editDeleteChilds with id of the page .. remember there is argument for editDeleteChilds for ForceDelete which if you pass "1" it will deleted even it is linked!
Oct 27, 2016 6:24
Thanks Marija and Aria for your replies. I've just got my DBA to run the SP and although it did delete some items (around 1000), we are now receiving a constrainst error. When we try and re-run again, no further items are deleted.
Do we need to stop the main episerver service to get this to work?
Nov 02, 2016 14:06
Eric
- Jan 02, 2025 11:36
Could be worth mentioning that, if I remember correct, the scheduler does not delete all items it only deletes items older then a certain number of days. So the trash bin will not be empty. To remove all you need to do it from Edit not run the scheduler. Also If you have deleted a structure you could create a plugin removing all items from the ID of that page. Might be a bit more secure then running a SP directly towards the database.
In our projects we have the same problem from time to time so instead of running an SP we have a plugin removing nodes with large amount of children manually directly from the recycle bin.
In our projects we have the same problem from time to time so instead of running an SP we have a plugin removing nodes with large amount of children manually directly from the recycle bin.
In case anyone comes across this topic, there is an article here on this issue and how to resolve
Sep 27, 2024 16:10
I am having problems emptying the recycle bin in Episerver. I have approximately 16,000 items in the bin, and I receive a timeout error whenever I try and empty this. I have tried on several occasions to do this, but I receive the same error each time.
Is there another way to do this to get around the error?