Details

    • Branch Version/s:
      6.2.x
    • Backported to Branch:
      Committed
    • Fix Priority:
      5
    • Similar Issues:
      Show 4 results 

      Description

      Following stack trace happens when conducting search.

      00:04:34,948 ERROR [ajp-bio-8009-exec-10][search_resources_jsp:1507] com.liferay.portal.kernel.search.SearchException: com.liferay.portal.kernel.search.SearchException: com.documentum.fc.common.DfException: A Parser Error (syntax error) 
      has occurred in the vicinity of:  SELECT COUNT(r_object_id) AS num_hits FROM dm_document WHERE ((FOLDER(ID('0bde75d180001952'), DECEND
      com.liferay.portal.kernel.search.SearchException: com.liferay.portal.kernel.search.SearchException: com.documentum.fc.common.DfException: A Parser Error (syntax error) has occurred in the vicinity of:  SELECT COUNT(r_object_id) AS num_hi
      ts FROM dm_document WHERE ((FOLDER(ID('0bde75d180001952'), DECEND
              at com.liferay.portlet.documentlibrary.service.impl.DLAppServiceImpl.search(DLAppServiceImpl.java:2645)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
              at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
              at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:56)
              at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
              at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
              at com.sun.proxy.$Proxy196.search(Unknown Source)
              at com.liferay.portlet.documentlibrary.service.DLAppServiceUtil.search(DLAppServiceUtil.java:2093)
              at org.apache.jsp.html.portlet.document_005flibrary.search_005fresources_jsp._jspService(search_005fresources_jsp.java:1245)
              at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
              at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432)
              at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390)
              at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
              at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749)
              at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:605)
              at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:544)
              at com.liferay.portlet.PortletRequestDispatcherImpl.dispatch(PortletRequestDispatcherImpl.java:331)
              at com.liferay.portlet.PortletRequestDispatcherImpl.include(PortletRequestDispatcherImpl.java:112)
              at com.liferay.portlet.documentlibrary.action.SearchAction.serveResource(SearchAction.java:59)
              at com.liferay.portal.struts.PortletAction.execute(PortletAction.java:131)
              at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
              at com.liferay.portal.struts.PortletRequestProcessor.processActionPerform(PortletRequestProcessor.java:454)
              at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
              at com.liferay.portal.struts.PortletRequestProcessor.process(PortletRequestProcessor.java:246)
              at com.liferay.portlet.StrutsPortlet.serveResource(StrutsPortlet.java:262)
              at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:122)
              at com.liferay.portlet.ScriptDataPortletFilter.doFilter(ScriptDataPortletFilter.java:82)
              at com.liferay.portlet.FilterChainImpl.doFilter(FilterChainImpl.java:116)
              at com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:71)
              at com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:618)
              at com.liferay.portlet.InvokerPortletImpl.invokeResource(InvokerPortletImpl.java:696)
              at com.liferay.portlet.InvokerPortletImpl.serveResource(InvokerPortletImpl.java:462)
              at com.liferay.portlet.PortletContainerImpl._doServeResource(PortletContainerImpl.java:792)
              at com.liferay.portlet.PortletContainerImpl.serveResource(PortletContainerImpl.java:152)
              at com.liferay.portlet.SecurityPortletContainerWrapper.serveResource(SecurityPortletContainerWrapper.java:166)
              at com.liferay.portlet.RestrictPortletContainerWrapper.serveResource(RestrictPortletContainerWrapper.java:166)
              at com.liferay.portal.kernel.portlet.PortletContainerUtil.serveResource(PortletContainerUtil.java:164)
              at com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:364)
              at com.liferay.portal.action.LayoutAction.doExecute(LayoutAction.java:178)
              at com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:79)
              at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
              at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
              at com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:173)
              at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
              at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
              at com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:546)
              at com.liferay.portal.servlet.MainServlet.service(MainServlet.java:523)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:116)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
              at com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:293)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
              at com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:169)
              at com.liferay.portal.servlet.filters.jsoncontenttype.JSONContentTypeFilter.processFilter(JSONContentTypeFilter.java:42)
              at com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:59)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:185)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
              at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDoFilter(InvokerFilterChain.java:204)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:109)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:165)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:165)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.processDirectCallFilter(InvokerFilterChain.java:185)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilterChain.doFilter(InvokerFilterChain.java:96)
              at com.liferay.portal.kernel.servlet.filters.invoker.InvokerFilter.doFilter(InvokerFilter.java:96)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
              at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
              at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:200)
              at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
              at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
              at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
              at java.lang.Thread.run(Thread.java:744)
      Caused by: com.liferay.portal.kernel.search.SearchException: com.documentum.fc.common.DfException: A Parser Error (syntax error) has occurred in the vicinity of:  SELECT COUNT(r_object_id) AS num_hits FROM dm_document WHERE ((FOLDER(ID('0bde75d180001952'), DECEND
              at com.liferay.documentum.repository.DocumentumRepository.search(DocumentumRepository.java:1318)
              at com.liferay.portal.kernel.repository.BaseRepositoryImpl.search(BaseRepositoryImpl.java:340)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
              at java.lang.reflect.Method.invoke(Method.java:606)
              at com.liferay.portal.kernel.bean.ClassLoaderBeanHandler.invoke(ClassLoaderBeanHandler.java:67)
              at com.sun.proxy.$Proxy528.search(Unknown Source)
              at com.liferay.portal.repository.proxy.BaseRepositoryProxyBean.search(BaseRepositoryProxyBean.java:659)
              at com.liferay.portlet.documentlibrary.service.impl.DLAppServiceImpl.search(DLAppServiceImpl.java:2642)
              ... 176 more
      Caused by: com.documentum.fc.common.DfException: A Parser Error (syntax error) has occurred in the vicinity of:  SELECT COUNT(r_object_id) AS num_hits FROM dm_document WHERE ((FOLDER(ID('0bde75d180001952'), DECEND
              at com.documentum.fc.client.impl.docbase.DocbaseExceptionMapper.newException(DocbaseExceptionMapper.java:57)
              at com.documentum.fc.client.impl.connection.docbase.MessageEntry.getException(MessageEntry.java:39)
              at com.documentum.fc.client.impl.connection.docbase.DocbaseMessageManager.getException(DocbaseMessageManager.java:137)
              at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.checkForMessages(NetwiseDocbaseRpcClient.java:305)
              at com.documentum.fc.client.impl.connection.docbase.netwise.NetwiseDocbaseRpcClient.applyForCollection(NetwiseDocbaseRpcClient.java:429)
              at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection$3.evaluate(DocbaseConnection.java:1183)
              at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.evaluateRpc(DocbaseConnection.java:1054)
              at com.documentum.fc.client.impl.connection.docbase.DocbaseConnection.applyForCollection(DocbaseConnection.java:1171)
              at com.documentum.fc.client.impl.docbase.DocbaseApi.exec(DocbaseApi.java:83)
              at com.documentum.fc.client.impl.session.Session.query(Session.java:3281)
              at com.documentum.fc.client.impl.session.SessionHandle.query(SessionHandle.java:2249)
              at com.documentum.fc.client.DfQuery.runQuery(DfQuery.java:164)
              at com.documentum.fc.client.DfQuery.execute(DfQuery.java:208)
              at com.liferay.documentum.repository.DocumentumRepository.search(DocumentumRepository.java:1210)
              ... 185 more
      
      

        Activity

        Hide
        Mark Jin added a comment -

        PASSED Manual Testing using the following steps:

        1. Have the following in portal-ext.properties.
          session.store.password=true
          company.security.auth.type=screenName
          
        2. Run the following command in C:\Program Files (x86)\OpenOffice.org 3\program "soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;".
        3. Navigate to documentum-hook-xxx.war\WEB-INF\classes\ and Edit dfc.properties.
        4. Change localhost to [IPAddress of Documentum VM].
          dfc.docbroker.host[0]=[IPAddress of Documentum VM]
          
        5. Deploy Documentum-Hook-xxxx.war.
        6. Create new user screen name and password fill "barthur".
        7. Give the user Administrator role.
        8. Go to > Control Panel > Server Administration > External Services.
        9. Flag Enabled under 'Enabling OpenOffice integration provides document conversion on functionality.'.
        10. Sign out admin user and Sign in new user "barthur".
        11. Add Document and Media portlet to new page.
        12. Click Add > Repository.
          1. Name: Repository
          2. Description: Documentum
          3. Repository Type: Documentum
          4. Repository: documentum
          5. Cabinet: Wombat Insurance Co
        13. Enter the repository.
        14. Create new folder.
        15. Enter the folder and upload new document file.
        16. Try search the file.

        Reproduced on:
        Tomcat 7.0 + MySQL 5. Portal ee-6.2.x EE GIT ID: 6ca5ac506ed52369cf72b96267d3ecd58cab87ba.
        Plugins 6.2.x EE GIT ID: 117c0a3c558912bf0e0e0ccea8ad71b7a0980293.

        Searching the new file cause exception. See description.

        Fixed on:
        Tomcat 7.0 + MySQL 5. Portal ee-6.2.x EE GIT ID: 6ca5ac506ed52369cf72b96267d3ecd58cab87ba.
        Plugins 6.2.x EE GIT ID: 926aebb43e7748513460766548d843258cd0cc17.

        Able to search the file without any exception.

        Show
        Mark Jin added a comment - PASSED Manual Testing using the following steps: Have the following in portal-ext.properties. session.store.password= true company.security.auth.type=screenName Run the following command in C:\Program Files (x86)\OpenOffice.org 3\program "soffice -headless -accept="socket,host=127.0.0.1,port=8100;urp;". Navigate to documentum-hook-xxx.war\WEB-INF\classes\ and Edit dfc.properties. Change localhost to [IPAddress of Documentum VM] . dfc.docbroker.host[0]=[IPAddress of Documentum VM] Deploy Documentum-Hook-xxxx.war. Create new user screen name and password fill "barthur". Give the user Administrator role. Go to > Control Panel > Server Administration > External Services. Flag Enabled under 'Enabling OpenOffice integration provides document conversion on functionality.'. Sign out admin user and Sign in new user "barthur". Add Document and Media portlet to new page. Click Add > Repository. Name: Repository Description: Documentum Repository Type: Documentum Repository: documentum Cabinet: Wombat Insurance Co Enter the repository. Create new folder. Enter the folder and upload new document file. Try search the file. Reproduced on: Tomcat 7.0 + MySQL 5. Portal ee-6.2.x EE GIT ID: 6ca5ac506ed52369cf72b96267d3ecd58cab87ba. Plugins 6.2.x EE GIT ID: 117c0a3c558912bf0e0e0ccea8ad71b7a0980293. Searching the new file cause exception. See description. Fixed on: Tomcat 7.0 + MySQL 5. Portal ee-6.2.x EE GIT ID: 6ca5ac506ed52369cf72b96267d3ecd58cab87ba. Plugins 6.2.x EE GIT ID: 926aebb43e7748513460766548d843258cd0cc17. Able to search the file without any exception.

          People

          • Assignee:
            Mark Jin
            Reporter:
            Sampsa Sohlman
            Recent user:
            Esther Sanz
            Participants of an Issue:
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:
              Days since last comment:
              1 year, 31 weeks, 2 days ago

              Development

                Structure Helper Panel