08-29-2018 02:32 AM
Hi,
I have important issue on a client site :
org.quartz.SchedulerException: Job threw an unhandled exception. [See nested exception: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 07290266 Request failed 500 /solr4/alfresco/afts?wt=json&fl=DBID%2Cscore&rows=1000&df=TEXT&start=0&locale=fr_FR&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON]
at org.quartz.core.JobRunShell.run(JobRunShell.java:227)
at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:563)
Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 07290266 Request failed 500 /solr4/alfresco/afts?wt=json&fl=DBID%2Cscore&rows=1000&df=TEXT&start=0&locale=fr_FR&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postQuery(SolrQueryHTTPClient.java:1159)
at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postSolrQuery(SolrQueryHTTPClient.java:1109)
at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:576)
at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:58)
at org.alfresco.repo.search.impl.solr.SolrXPathQueryLanguage.executeQuery(SolrXPathQueryLanguage.java:52)
at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:355)
at org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:159)
at org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:73)
at org.alfresco.repo.search.AbstractSearcherComponent.query(AbstractSearcherComponent.java:60)
at sun.reflect.GeneratedMethodAccessor451.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:79)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at com.sun.proxy.$Proxy22.query(Unknown Source)
at org.alfresco.repo.search.impl.SearchServiceSubSystemDelegator.query(SearchServiceSubSystemDelegator.java:98)
at com.klinck.mc.services.DocumentTypologiqueServiceImpl.createFolderScanOnDocumed(DocumentTypologiqueServiceImpl.java:116)
at com.klinck.mc.jobs.DocumedJobExecuter.execute(DocumedJobExecuter.java:40)
at com.klinck.mc.jobs.DocumedJob$1.doWork(DocumedJob.java:27)
at org.alfresco.repo.security.authentication.AuthenticationUtil.runAs(AuthenticationUtil.java:555)
at com.klinck.mc.jobs.DocumedJob.executeJob(DocumedJob.java:25)
at org.alfresco.schedule.ScheduledJobLockExecuter.execute(ScheduledJobLockExecuter.java:94)
at org.alfresco.schedule.AbstractScheduledLockedJob.executeInternal(AbstractScheduledLockedJob.java:72)
at org.springframework.scheduling.quartz.QuartzJobBean.execute(QuartzJobBean.java:114)
at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
... 1 more
It comes from this code line :
ResultSet rs = searchService.query(storeRef, SearchService.LANGUAGE_XPATH,
"/app:company_home/st:sites/cm:" + coreServices.getDocumedSiteName() + "/cm:documentLibrary");
But the app is installed since 3 months without problem.
It seems to be a corrupt issue :
There is a lot of documents ( > 6000) !!!
How can I solve that ?
Thank's
08-29-2018 03:03 AM
For SOLR 4:
https://docs.alfresco.com/community5.1/tasks/solr-reindex.html
For SOLR 6:
https://docs.alfresco.com/community/tasks/solr-reindex.html
08-29-2018 02:39 AM
Probably the line:
coreServices.getDocumedSiteName()
is including some character not allowed for LANGUAGE_XPATH syntax.
08-29-2018 02:49 AM
Hi,
1) CoresServices :
public String getDocumedSiteName() {
return documedSiteName;
}
and
@Value( "${documed.site.name}" )
private String documedSiteName;
2) alfresco-global.properties :
documed.site.name = klinck
It worked nice before today....
08-29-2018 02:58 AM
If it's a fixed value (I though it was picked dynamically) then it looks like a SOLR index problem.
If the repository is not too big, you can re-build the indexes of SOLR.
08-29-2018 03:00 AM
Thank you ! How can I do that ?
08-29-2018 03:03 AM
For SOLR 4:
https://docs.alfresco.com/community5.1/tasks/solr-reindex.html
For SOLR 6:
https://docs.alfresco.com/community/tasks/solr-reindex.html
05-24-2021 02:20 AM
links don't work.
Can you reply with working ones?
Thanks
05-24-2021 03:38 AM
For Solr 6 try here.
HTH.
Explore our Alfresco products with the links below. Use labels to filter content by product module.