HELP - URGENT : LuceneQueryParserException: 07290266 Request failed 500

[anakin59490]

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 :

Categories suddenly corrupted 

There is a lot of documents ( > 6000) !!!

How can I solve that ?

Thank's

[angelborroy]

Probably the line:

coreServices.getDocumedSiteName()

is including some character not allowed for LANGUAGE_XPATH syntax.

[anakin59490]

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....

[angelborroy]

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.

[anakin59490]

Thank you ! How can I do that ?

[angelborroy · Accepted solution]

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

[Matteo_Moretti]

links don't work.

Can you reply with working ones?

Thanks

[EddieMay]

Hi @Matteo_Moretti 

For Solr 6 try here.

HTH.