Query not refreshing on collection

[iann]

When adding new pages into a quick start site they're not appearing until I delete the CMIS query from the collection, save it, and then re-edit the collection properties adding the original query back in - this then results in the new pages appearing.

Changing the refresh value doesn't have an effect - it seems to be ignored.

[bremmington]

Ian

I've tried this out with a couple of the asset collections in WQS, and I'm not seeing that behaviour - it's working as expected. Is this an asset collection that you have created or one that was installed as part of the Quick Start? Would you be able to find the asset collection node using the Node Browser and let me know what the values are for the "isDynamic" property and the "refreshAt" property?

[iann]

Hi Brian,

All of the collections are the ones that come with Quick Start, an exception is being thrown as detailed below:

09:28:00,675 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean#7433c78b threw an unhandled Exception:
org.springframework.scheduling.quartz.JobMethodInvocationFailedException: Invocation of method 'run' on target class [class org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor] failed; nested exception is java.lang.NullPointerException
   at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:273)
   at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:86)
   at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
   at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
Caused by: java.lang.NullPointerException
   at org.alfresco.cmis.mapping.ObjectTypeIdProperty.buildLuceneEquality(ObjectTypeIdProperty.java:106)
   at org.alfresco.cmis.search.CmisFunctionEvaluationContext.buildLuceneEquality(CmisFunctionEvaluationContext.java:174)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.functions.LuceneEquals.addComponent(LuceneEquals.java:62)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneFunctionalConstraint.addComponent(LuceneFunctionalConstraint.java:58)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneConjunction.addComponent(LuceneConjunction.java:70)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneQuery.buildQuery(LuceneQuery.java:106)
   at org.alfresco.repo.search.impl.querymodel.impl.lucene.LuceneQueryEngine.executeQuery(LuceneQueryEngine.java:177)
   at sun.reflect.GeneratedMethodAccessor450.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
   at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
   at $Proxy119.executeQuery(Unknown Source)
   at org.alfresco.cmis.search.CMISQueryServiceImpl.query(CMISQueryServiceImpl.java:128)
   at org.alfresco.repo.search.impl.lucene.LuceneAlfrescoSqlQueryLanguage.executQuery(LuceneAlfrescoSqlQueryLanguage.java:80)
   at org.alfresco.repo.search.impl.lucene.ADMLuceneSearcherImpl.query(ADMLuceneSearcherImpl.java:511)
   at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:78)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.util.WebassetCollectionHelper.refreshCollection(WebassetCollectionHelper.java:128)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor$1$1.execute(DynamicCollectionProcessor.java:150)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:372)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:252)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor$1.doWork(DynamicCollectionProcessor.java:107)
   at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:508)
   at org.alfresco.module.org_alfresco_module_wcmquickstart.jobs.DynamicCollectionProcessor.run(DynamicCollectionProcessor.java:102)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.springframework.util.MethodInvoker.invoke(MethodInvoker.java:273)
   at org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean$MethodInvokingJob.executeInternal(MethodInvokingJobDetailFactoryBean.java:264)
   … 3 more
09:28:00,679 ERROR [org.quartz.core.ErrorLogger] Job (DEFAULT.org.springframework.scheduling.quartz.MethodInvokingJobDetailFactoryBean#7433c78b threw an exception.

[bremmington]

OK. This indicates that one or more of the queries have been edited incorrectly. In this particular case, a CMIS query has an error in it near a test for equality similar to "cmisbjectTypeId=D:abc:xyz". This error is causing the asset collections to not be updated on schedule.