Uploaded image for project: 'Alfresco One Platform'
  1. Alfresco One Platform
  2. ACE-3230

Solr 4: Alfresco Server Error is returned when executing alfresco/s/api/search/person webscripts

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0
    • Fix Version/s: 5.0
    • Labels:
    • Environment:
      Enterprise v5.0.0 (r88693-b223) schema 8,008.
      Server: QALAB Stack 1 - RHEL 6.5 x64, MySQL v5.6.17, mysql-connector-java-5.1.32-bin.jar, Apache Tomcat v7.0.53, JDK 7 U67 x64, Solr4 search engine.
      Client: Windows 7 SP1 x64, IE 9 x32.

      Description

      Steps to Reproduce

      1. Create any user, e.g. test.
      2. Execute the following webscripts as admin user:
        http://<host>:<port>/alfresco/s/api/search/person.html?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        
        http://<host>:<port>/alfresco/s/search/person.html?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        
        http://<host>:<port>/alfresco/s/api/search/person.atom?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        
        http://<host>:<port>/alfresco/s/search/person.atom?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        
        http://<host>:<port>/alfresco/s/api/search/person.rss?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        
        http://<host>:<port>/alfresco/s/search/person.rss?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        
        http://<host>:<port>/alfresco/s/api/search/person.portlet?q={searchTerms}&p={startPage?}&c={count?}&l={language?}
        

      Observed Result

      Alfresco Server Error is returned:

      An error has occured in the API: /alfresco/s/api/search/person.html.
      It responded with a status of 500 - Internal Error.
      Error Code Information: 500 - An error inside the HTTP server which prevented it from fulfilling the request.
      Error Message: 09200084 Wrapped Exception (with status template): 09200107 Request failed 500 /solr4/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=1000&df=TEXT&start=0&locale=en&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
      Server: Alfresco Enterprise v5.0.0 (r88693-b223) schema 8,008
      Time: Oct 20, 2014 7:11:46 PM
      Click here to view full technical information on the error.
      Exception: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException - 09200107 Request failed 500 /solr4/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=1000&df=TEXT&start=0&locale=en&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
      org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postQuery(SolrQueryHTTPClient.java:616)
      org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.postSolrQuery(SolrQueryHTTPClient.java:559)
      org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:520)
      org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:51)
      org.alfresco.repo.search.impl.solr.SolrSearchService.query(SolrSearchService.java:348)
      org.alfresco.repo.search.SearcherComponent.query(SearcherComponent.java:77)
      sun.reflect.GeneratedMethodAccessor970.invoke(Unknown Source)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      java.lang.reflect.Method.invoke(Unknown Source)
      org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:72)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      com.sun.proxy.$Proxy21.query(Unknown Source)
      org.alfresco.repo.search.impl.SearchServiceSubSystemDelegator.query(SearchServiceSubSystemDelegator.java:126)
      sun.reflect.GeneratedMethodAccessor970.invoke(Unknown Source)
      sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
      java.lang.reflect.Method.invoke(Unknown Source)
      org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:46)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:159)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
      org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
      org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
      org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      com.sun.proxy.$Proxy21.query(Unknown Source)
      org.alfresco.repo.web.scripts.bean.KeywordSearch.search(KeywordSearch.java:187)
      org.alfresco.repo.web.scripts.bean.KeywordSearch.executeImpl(KeywordSearch.java:134)
      org.springframework.extensions.webscripts.DeclarativeWebScript.executeImpl(DeclarativeWebScript.java:235)
      org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
      org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:463)
      org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:454)
      org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:532)
      org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:600)
      org.alfresco.repo.web.scripts.RepositoryContainer.executeScriptInternal(RepositoryContainer.java:380)
      org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:261)
      org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:378)
      org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
      org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:132)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
      org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
      org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
      org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
      org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
      org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
      org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
      org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
      org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
      org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
      org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
      org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
      org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
      org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2378)
      java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      java.lang.Thread.run(Unknown Source)
      Exception: org.springframework.extensions.webscripts.WebScriptException - 09200084 Wrapped Exception (with status template): 09200107 Request failed 500 /solr4/alfresco/alfresco?wt=json&fl=DBID%2Cscore&rows=1000&df=TEXT&start=0&locale=en&alternativeDic=DEFAULT_DICTIONARY&fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON
      org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1126)
      

      Note

      • This webscripts are the part of OpenSearch which has been used in Explorer. Are they also EOL?


      ChristinaSh

        Attachments

          Activity

            People

            • Assignee:
              closedissues Closed Issues
              Reporter:
              alfrescoqa Alfresco QA Team
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: