Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 4.2.4, 5.0.N
    • Fix Version/s: 5.0.1
    • Component/s: ZZ_Archive
    • Labels:
      None
    • Environment:
      Alfresco 5.0.1 (r92880-b32) schema 8019, Oracle Solaris 11.2 x64, Oracle 12c: Ojdbc7.jar (use jdbc:oracle:thin in db_url), Tomcat 7.0.53, JDK 8 U25 x64, Oracle Directory Server 11.1.2

      Description

      1. Install Alfresco Enterprise with WQS module;
      2. Log into Share ,Create any site and Import wcmqs sample data (e.g. Government);
      3. Configure to Quick Start Editorial
      4. Navigate to http://host:8080/wcmqs

        Expected Result:

        Wcmqs site is opened

        Actual Result:

        Error is displayed: Spring Surf has been installed at this location.
        A root page has not been defined.

        catalina.out
        ERROR [org.alfresco.wcm.client.exceptionresolver.RepositoryExceptionResolver] org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException:
        ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
        
        ### The error may exist in alfresco/ibatis/#resource.dialect#/metadata-query-SqlMap.xml
        ### The error may involve alfresco.metadata.query.select_byDynamicQuery-Inline
        ### The error occurred while setting parameters
        ### SQL: select              node.id             as id         from             alf_node node                                                       where              node.type_qname_id <> ?             AND node.store_id = ?                               AND node.transaction_id > ?                                             AND                                                                       EXISTS (select 1 from alf_node_aspects as aspect where aspect.node_id = node.id AND                               aspect.qname_id IN  (  ? , ? , ? ) )                                                                                                AND                                                                                                 node.type_qname_id IN  (  ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )                                                                                                 AND                                                                                                 node.type_qname_id IN  (  ? )
        ### Cause: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
        
        ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
        
        org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException:
        ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
        
        ### The error may exist in alfresco/ibatis/#resource.dialect#/metadata-query-SqlMap.xml
        ### The error may involve alfresco.metadata.query.select_byDynamicQuery-Inline
        ### The error occurred while setting parameters
        ### SQL: select              node.id             as id         from             alf_node node                                                       where              node.type_qname_id <> ?             AND node.store_id = ?                               AND node.transaction_id > ?                                             AND                                                                       EXISTS (select 1 from alf_node_aspects as aspect where aspect.node_id = node.id AND                               aspect.qname_id IN  (  ? , ? , ? ) )                                                                                                AND                                                                                                 node.type_qname_id IN  (  ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )                                                                                                 AND                                                                                                 node.type_qname_id IN  (  ? )
        ### Cause: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
        
        ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
        
                at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:493)
                at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:635)
                at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:179)
                at org.apache.chemistry.opencmis.client.runtime.SessionImpl$5.fetchPage(SessionImpl.java:872)
                at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)
                at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48)
                at org.alfresco.wcm.client.impl.WebSiteServiceImpl.refreshWebsiteCache(WebSiteServiceImpl.java:167)
                at org.alfresco.wcm.client.impl.WebSiteServiceImpl.getWebSiteCache(WebSiteServiceImpl.java:150)
                at org.alfresco.wcm.client.impl.WebSiteServiceImpl.getWebSite(WebSiteServiceImpl.java:117)
                at org.alfresco.wcm.client.interceptor.ApplicationDataInterceptor.preHandle(ApplicationDataInterceptor.java:74)
                at org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:130)
                at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:913)
                at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:851)
                at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:953)
                at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:844)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:620)
                at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:829)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
                at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
                at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:748)
                at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:486)
                at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:411)
                at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:338)
                at org.tuckey.web.filters.urlrewrite.NormalRewrittenUrl.doRewrite(NormalRewrittenUrl.java:213)
                at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:171)
                at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
                at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
                at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:389)
                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
                at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
                at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
                at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
                at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
                at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:315)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
                at java.lang.Thread.run(Thread.java:745)

        AndreiMa

        Attachments

          Structure

            Activity

              People

              • Assignee:
                closedbugs Closed Bugs
                Reporter:
                alfrescoqa Alfresco QA Team (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                7 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 week, 1 day
                  1w 1d

                    Structure Helper Panel