Query not refreshing on collection

iann — Tue, 26 Oct 2010 21:44:24 GMT

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 effec

Re: Query not refreshing on collection

bremmington — Wed, 27 Oct 2010 07:05:22 GMT

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?

Re: Query not refreshing on collection

iann — Wed, 27 Oct 2010 08:57:35 GMT

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.

Re: Query not refreshing on collection

bremmington — Wed, 27 Oct 2010 09:08:07 GMT

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.

topic Re: Query not refreshing on collection in Alfresco Archive

Query not refreshing on collection

Re: Query not refreshing on collection

Re: Query not refreshing on collection

Re: Query not refreshing on collection