Starting Workflow on a schedule

srowsell — Fri, 23 Aug 2013 16:05:40 GMT

I have been trying this for a while, and gotten to the point I will describe below.The following is a script which I intend to have run on a schedule (more on that below). For debugging purposes I have also set it up as a rule which runs when I want it to run, but the end result is to have it run o

Re: Starting Workflow on a schedule

srowsell — Mon, 09 Sep 2013 18:53:19 GMT

After trying this for a while, I can re-phrase my problem.

When I give the queryTemplate property a value that exists, such as:

    <property name="queryTemplate">
    <value>PATH:"/app:company_home"</value>
    </property>‍‍‍

the scheduled action runs, or at least tries to run. I get the following as an error:


13:58:00,638 ERROR [freemarker.runtime] Template processing error: "No nodes selected"

No nodes selected
The problematic instruction:
———-
==> ${selectSingleNode('workspace://SpacesStore', 'lucene', 'PATH:"/app:company_home/app:dictionary/app:scripts/cm:findExpiringContracts.js"' )} [on line 1, column 1 in string://fixed]
———-

Java backtrace for programmers:
———-
freemarker.template.TemplateModelException: No nodes selected
   at org.alfresco.repo.action.scheduled.FreeMarkerWithLuceneExtensionsModelFactory$QueryForSingleNodeFunction.exec(FreeMarkerWithLuceneExtensionsModelFactory.java:180)
   at freemarker.core.MethodCall._getAsTemplateModel(MethodCall.java:93)
   at freemarker.core.Expression.getAsTemplateModel(Expression.java:89)
   at freemarker.core.Expression.getStringValue(Expression.java:93)
   at freemarker.core.DollarVariable.accept(DollarVariable.java:76)
   at freemarker.core.Environment.visit(Environment.java:221)
   at freemarker.core.Environment.process(Environment.java:199)
   at freemarker.template.Template.process(Template.java:237)
   at org.alfresco.repo.template.FreeMarkerProcessor.processString(FreeMarkerProcessor.java:260)
   at org.alfresco.repo.processor.TemplateServiceImpl.processTemplateString(TemplateServiceImpl.java:208)
   at org.alfresco.repo.processor.TemplateServiceImpl.processTemplateString(TemplateServiceImpl.java:227)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:601)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:245)
   at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:211)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:164)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy110.processTemplateString(Unknown Source)
   at org.alfresco.repo.action.scheduled.SimpleTemplateActionDefinition.getAction(SimpleTemplateActionDefinition.java:196)
   at org.alfresco.repo.action.scheduled.CronScheduledQueryBasedTemplateActionDefinition.getAction(CronScheduledQueryBasedTemplateActionDefinition.java:262)
   at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition$1$2.execute(AbstractScheduledAction.java:563)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:259)
   at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition$1.runTransactionalAction(AbstractScheduledAction.java:557)
   at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition$1.doWork(AbstractScheduledAction.java:426)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:529)
   at org.alfresco.repo.action.scheduled.AbstractScheduledAction$JobDefinition.execute(AbstractScheduledAction.java:392)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

If I look at the following link (from the person who pointed me in this direction in the first place):

http://4lch3mi5t.wordpress.com/2012/07/26/scheduled-custom-action-alfresco/

the advice given is that the problematic instruction isn't finding the node from my javascript file – which definitely exists, and is a javascript file (so sayeth the Node Browser) – because I'm using Solr rather than Lucene. My production server is using Solr, though, and I'd rather not rebuild the thing just to get this to work. As it is, I have the following as a workaround:

1. Windows Task Scheduler executes a batch file, which contains the line "start http://blahblahblah/ScheduledAction.aspx"
2. This runs a web application, which runs the following web script: modifyProperty (with a nodeRef passed in the querystring)
3. The web script alters the description of the file associated with that nodeRef by passing in the current date
4. Altering this file triggers a rule which executes a script which does what I want it to do

(At this point the crossbow fires, severing the rope which is holding up the anvil, causing the anvil to plummet onto the seesaw, which will launch a net a the Roadrunner…)

So, am I barking up the right tree with respect to the necessity to use a Solr query rather than a Lucene query? If so, what would be the right Solr query?

topic Starting Workflow on a schedule in Alfresco Archive

Starting Workflow on a schedule

Re: Starting Workflow on a schedule