topic Re: delete folder with 30000 files in Alfresco Archive

delete folder with 30000 files

sharik — Sat, 17 Jan 2015 13:01:57 GMT

Hi,We have two folders with approx 30000 files, which we can not open and also can not delete,has anybody any expierience with solving this kind of problem?Is there ascript that we can run to delete this folders?thanks in advance for the helpsharik

Re: delete folder with 30000 files

kavilash23 — Mon, 19 Jan 2015 05:35:25 GMT

Hi,

You can always try to delete the folder from Alfresco Explorer rather than using Share. Alternatively if you have alfresco mapped as a CIFS drive, you can delete the folder from there as well.

Re: delete folder with 30000 files

rjohnson — Mon, 19 Jan 2015 10:20:03 GMT

I suspect you have a multitude of issues here.

In share you can only delete 50 at a time & if you try and delete the folder it will likely timeout and rollback.

Also, if you do succeed then you will end up with 30,000 items in the Trash and the same problem again.

In the assumption you only need to do this once, I can think of 3 possible solutions:-

1. Write a webscript that will find this folder, then for the first 100 child documents add sys:temporary the aspect and delete the document and then stop. Call that webscript manually from a webbrowser 300 times using some external scripting language 300 times. You may be able to delete more than 100 at a time before you run into transaction buffer size issues.
2. Write some Javavscript that will do the same and create a Quartz scheduled job that repeatedly calls it.
3. Write a Java Bean that will do the above but controll the transaction in the bean so you need to run it only once.

For a one off, 1 is probably easier. If you do not add sys:temporary then your 30,000 items will end up in the trash and you then have a problem deleting them from the trash (unless you are already running a trashcan cleaner).

Re: delete folder with 30000 files

brianmark2 — Wed, 17 May 2017 03:18:14 GMT

Hi Sir Sharik _‌,

I also have same problem. Did you have a solution for this? Can you share us the solution?

Thank you

Re: delete folder with 30000 files

brianmark2 — Wed, 17 May 2017 03:22:07 GMT

Hi Sir ,

I am not a developer and I am just a newbie, could you help us or give us a sample script we can follow to solve this (step by step)? and how and where can we insert or add the webscript so we can use it.

Thank you very much.

Re: delete folder with 30000 files

angelborroy — Wed, 17 May 2017 06:01:44 GMT

You can also use a CMIS approach like this https://github.com/keensoft/MassiveDelete

Re: delete folder with 30000 files

brianmark2 — Wed, 17 May 2017 08:42:57 GMT

Thank you Sir I will try it today.

Re: delete folder with 30000 files

brianmark2 — Wed, 17 May 2017 09:55:17 GMT

Sir may I ask where will I add or insert the folder MassiveDelete-master? Can you tell us the path?

Thank you

Re: delete folder with 30000 files

avmcf — Tue, 05 Jun 2018 13:20:49 GMT

Hi Angel thanks for your help, but if possible could you help me in a question a little more complex:

How cam I modify your suggestion for delete nodes based on a custom property, ex: delete nodes with a when property "xyz:cam_delete" is true - or how would sql query to get nodes by the value of any custom property.

Many thanks.

Re: delete folder with 30000 files

angelborroy — Wed, 06 Jun 2018 07:40:26 GMT

Probably this blog post could help you:

https://angelborroy.wordpress.com/2018/05/30/alfresco-counting-more-than-1000-elements/

Re: delete folder with 30000 files

avmcf — Wed, 06 Jun 2018 11:35:35 GMT

thanks