topic Re: Running Tasks Automatically and periodically in Alfresco Archive

Running Tasks Automatically and periodically

jlabuelo — Tue, 02 Jun 2009 08:05:44 GMT

Good Morning allI have a question and hope that someone can help us here. We know that when a node is deleted in Alfresco, it remains in a temporary "space" so it can be recovered if needed, or another cause could be if it has been deleted by mistake.After 3 months using Alfresco we have now 4 GB in

Re: Running Tasks Automatically and periodically

jlabuelo — Thu, 04 Jun 2009 16:02:50 GMT

Hi there

So… non has thought about this situation before? did anybody got this solved with any "periodic" rule or something?… Any ideas will be very welcome!!

Cheers

Re: Running Tasks Automatically and periodically

mabayona — Thu, 04 Jun 2009 17:17:34 GMT

To delete files from a specific folder in the File System you can use the good & old cron.

If you want to do it from inside Alfresco, I can think of two ways of doing it:

1) Web Scripts that can be run using your favorite scheduler (e.g. cron) via a REST interface.
2) Using a jBPM timer + custom advanced workflow to run a javascript task/action that does what you want.

It is simpler to use web scripts although using a jBPM timer is safer and not that difficult to do.

Regards.

Re: Running Tasks Automatically and periodically

jlabuelo — Thu, 04 Jun 2009 17:20:26 GMT

Hey

Thanks for the help… gonna check how this can be implemented and try it

Cheers

Re: Running Tasks Automatically and periodically

mrogers — Thu, 04 Jun 2009 18:46:22 GMT

Or you can use the job scheduler which is how the purge job (which is the thing placing the files out of the way) runs.

http://wiki.alfresco.com/wiki/Content_Store_Configuration

Re: Running Tasks Automatically and periodically

jlabuelo — Fri, 05 Jun 2009 06:55:30 GMT

Thanks a lot for the help mrogers. So Basically from my understanding, if I configure the "contentStoreCleaner" as it is explained in the document you sent us, files after "protectDays" will be moved to the "deletedContentStore" of the application, which normally is the physical file in the OS

contentstore.deleted (C:\Alfresco\alf_data\contentstore.deleted)

so what I must do is configuring the OS to delete the files withing the folder

contentstore.deleted

Basically the timings could be

a) Configure the "contentStoreCleaner" so all files deleted and older than 7 days get deleted and moved the "deletedContentStore"

b) Run the backup of the application

c) set up the OS to run a script to delete the files within C:\Alfresco\alf_data\contentstore.deleted

And after that if I log in the application and go to the "Manage Deleted Content" screen I should only see items deleted in the last 7 days

is it correct the way I am understanding it?…. anything missing from my side?

Thanks once more

Re: Running Tasks Automatically and periodically

jlabuelo — Mon, 29 Jun 2009 16:36:29 GMT

Hi there

Anyone can confirm that my understanding is the right one? Dont wanna start deleting folders in Alfresco and lose everything 🙂

Cheers

Re: Running Tasks Automatically and periodically

_sax — Thu, 09 Jul 2009 14:53:12 GMT

If you just delete files from the filesystem, the corresponding entries in your database are going to get orphaned. That is probably corrupting your installation.
I would opt for a workflow timer, so starting a workflow that is going to run permanently, including a timer task that does find all files older than 7 days via Lucene.
If you alter your workflow you can just stop it from the workflow console or via the tasks done dashlet in My Alfresco and redeploy your new workflow definition.

Re: Running Tasks Automatically and periodically

jlabuelo — Fri, 10 Jul 2009 06:30:40 GMT

Hi Sax

Thanks a lot, that sounds reasonable

Cheers and thanks

Re: Running Tasks Automatically and periodically

jlabuelo — Fri, 21 Aug 2009 09:01:22 GMT

Hi Sax, have a question for you in order to make sure I dont screw everything up 🙂

We are trying to set up a Scheduler Task to remove from the system all the "deleted items" that are still kept in Alfresco after you delete them from their spaces. So we are trying to set it up to access the space where these items are stored and remove them forever. We would like to set it up to be run automatically once a week. The way we did it seems it works, looks for the items with aspect "Archived" and removes them.

Our question is ¿Are we sure these "Archived" aspect is the one that points "ONLY" to the deleted items? ¿Do you know if just searching by this aspect I would get any other item I do not want to delete? ¿Any other alternative to make this task automatic?

Here is the action scheduler we have created

<bean id="programDeleteTrash" class="org.alfresco.repo.action.scheduled.CronScheduledQueryBasedTemplateActionDefinition">
        <property name="transactionMode">
            <value>UNTIL_FIRST_FAILURE</value>
        </property>
        <property name="compensatingActionMode">
            <value>IGNORE</value>
        </property>
        <property name="searchService">
            <ref bean="SearchService"/>
        </property>
        <property name="templateService">
            <ref bean="TemplateService"/>
        </property>
        <property name="queryLanguage">
            <value>lucene</value>
        </property>
        <property name="stores">
            <list>
                <value>archive://SpacesStore</value>
            </list>
        </property>
        <!– Find all nodes that do not have the aspect –>
        <property name="queryTemplate">
           <value>+ASPECT:"{http://www.alfresco.org/model/system/1.0}archived"</value>
        </property>
        <property name="cronExpression">
       <value>0 0 14 ? * SAT</value>
        </property>
        <property name="jobName">
            <value>jobB</value>
        </property>
        <property name="jobGroup">
            <value>jobGroupB</value>
        </property>
        <property name="triggerName">
            <value>triggerB</value>
        </property>
        <property name="triggerGroup">
            <value>triggerGroupB</value>
        </property>
        <!– Inject the scheduler - the trigger will be registered with this scheduler –>
        <property name="scheduler">
            <ref bean="schedulerFactory"/>
        </property>
        <property name="actionService">
            <ref bean="ActionService"/>
        </property>
        <property name="templateActionModelFactory">
            <ref bean="templateActionModelFactory"/>
        </property>
        <property name="templateActionDefinition">
            <ref bean="deleteTrashActionScheduled"/>
        </property>
        <property name="transactionService">
            <ref bean="TransactionService"/>
        </property>
        <property name="runAsUser">
            <value>admin</value>
        </property>
    </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Running Tasks Automatically and periodically

_sax — Fri, 21 Aug 2009 12:10:18 GMT

Hi jlabuelo,

I have to admit, that I never set up such a scheduled action. But what you built seems very reasonable. The archive:// context is supposed to look only through deleted items.
Maybe here http://forums.alfresco.com/en/viewtopic.php?f=7&t=15765 is an approach that brings you to the point even more easily.
There is an extension, that cleans deleted items that were "archived" for x days. But I did not test it and it was made for 2.x, so compatibility with 3.x is not ensured.

Just one note: In the line above the lucene syntax in your action it says <!– Find all nodes that do not have the aspect –> while the search phrase seems to do the opposite: find all nodes with that aspect.

Re: Running Tasks Automatically and periodically

jlabuelo — Sat, 22 Aug 2009 09:54:27 GMT

Hi there

Yes have checked the tool you point me to, however seems that you have to still run it manually. Our aim was to set up something to run every 7 days and remove the deleted items automatically. We have tried it in a test machine with a back up copy of our production system and seems that works fine ( and pretty fast I must say, much faster than using the UI) just wanted to make sure that we are not deleted anything else 😄 (that would be horrible, we would get complains from business all the time!!!).

About the comment… yeah it is because it was a copy/paste from a post we found in the wiki forum… we will modify it right the way!!

Thanks again!

Re: Running Tasks Automatically and periodically

_sax — Tue, 25 Aug 2009 10:34:43 GMT

Glad, you succeeded in it . As being also interested in this topic, I'm happy to find such a practical and working example. Thank you!

Re: Running Tasks Automatically and periodically

mrey — Mon, 31 Aug 2009 08:29:50 GMT

Good morning all.

Using the scheduled action above,it executes for files with aspect "archived", but the problem is that only deletes 180 files, and there are over 800 which are not deleted. All the files have the aspect "archived" and it executes every saturday at 15:00, and it works for 1 minute.

Somebody can help about this problem?.. maybe you Sax?

Thank you all.

Re: Running Tasks Automatically and periodically

_sax — Mon, 31 Aug 2009 14:00:46 GMT

I'm stuck even before. When I integrate the code above in scheduled-action-services-context.xml I get

Caused by: org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'deleteTrashActionScheduled' is defined

referrring to

        <property name="templateActionDefinition">
            <ref bean="deleteTrashActionScheduled"/>
        </property>

But where could this bean be defined? I suppose it is a custom added one.

Re: Running Tasks Automatically and periodically

mrey — Tue, 01 Sep 2009 06:59:25 GMT

Hello

Sorry, the bean was created by us.

This is the code

The code of scheduled-action-services-context.xml

 <bean id="deleteTrash" class="org.incis.model.actions.DeleteTrashActionExecuter" parent="action-executer">
        <property name="nodeService">
            <ref bean="NodeService" />
        </property>
        <property name="nodeArchiveService">
            <ref bean="NodeArchiveService" />
        </property>
    </bean>‍‍‍‍‍‍‍‍

 <bean id="deleteTrashActionScheduled" class="org.alfresco.repo.action.scheduled.SimpleTemplateActionDefinition">
        <property name="actionName">
            <value>deleteTrash</value>
        </property>
        <property name="parameterTemplates">
            <map>
                <entry>
                    <key>
                        <value></value>
                    </key>
                    <value></value>
                </entry>
                
            </map>
        </property>
        
        <property name="templateActionModelFactory">
            <ref bean="templateActionModelFactory"/>
        </property>
        <property name="dictionaryService">
            <ref bean="DictionaryService"/>
        </property>
        <property name="actionService">
            <ref bean="ActionService"/>
        </property>
        <property name="templateService">
            <ref bean="TemplateService"/>
        </property>
    </bean>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The code of DeleteTrashActionExecuter.java

public class DeleteTrashActionExecuter extends ActionExecuterAbstractBase 
{    
   private static Log logger = LogFactory.getLog(DeleteTrashActionExecuter.class); 
    
       public static final String NAME = "Delete_Trash";
   
       private NodeService nodeService;
    private NodeArchiveService nodeArchiveService;
   
    
   
    public void setNodeArchiveService(NodeArchiveService nodeArchiveService)
    {
       this.nodeArchiveService = nodeArchiveService;
    }
    
    public NodeArchiveService getNodeArchiveService()
    {
       return nodeArchiveService;
    }
    
    public void setNodeService(NodeService nodeService)
    {
       this.nodeService = nodeService;
    }
    
    public NodeService getNodeService()
    {
       return nodeService;
    }


   protected void addParameterDefinitions(List<ParameterDefinition> paramList) 
   {
      paramList.add(new ParameterDefinitionImpl("parametro", DataTypeDefinition.TEXT, true, getParamDisplayLabel("parametro")));
   }



   protected void executeImpl(
         Action ruleAction,
         NodeRef actionedUponNodeRef) 
   {
      logger.info("Ejecutandose action automaticamente");
      logger.info("actionedUponNodeRef " + actionedUponNodeRef);
      
      if (this.nodeService.exists(actionedUponNodeRef) == false)
      {
      
return;
        }
      
      getNodeArchiveService().purgeArchivedNode(actionedUponNodeRef);
   }   
    
}‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Could you help us? Thanks you in advance

Re: Running Tasks Automatically and periodically

_sax — Tue, 01 Sep 2009 15:09:46 GMT

Thank you. I actually never imported own java classes. I presume, I need Eclipse and produce a .jar file with it?
That said, your problem actually seems to stem more from an issue wih your installation than your code.
I'll try to reproduce it, though if you can point me to the steps required for using a java class.
If you have a testing system with a duplicate of your installation, is it possible to delete everything manually as admin from the recycle bin?
If not, it shows that there is an installation issue, if it is possible your code comes into focus.