topic Error in WCMQS in Alfresco 4.0.a in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/error-in-wcmqs-in-alfresco-4-0-a/m-p/251830#M204960 <HTML><HEAD></HEAD><BODY><SPAN>Hello!</SPAN><BR /><BR /><SPAN>I tried a fresh install of Alfresco 4.0.a with WCM-QS module. I import the website example ("Finance") but the site does not work - it gives error on web page.</SPAN><BR /><BR /><SPAN>In logs I get this error:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>Oct 14, 2011 10:38:39 AM org.apache.solr.common.SolrException log<BR />SEVERE: org.apache.chemistry.opencmis.commons.exceptions.CmisInvalidArgumentException: Type unsupported in CMIS queries: t<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.search.CMISQueryParser.buildColumns(CMISQueryParser.java:1030)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.opencmis.search.CMISQueryParser.parse(CMISQueryParser.java:140)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.solr.AlfrescoSolrDataModel.parseCMISQueryToAlfrescoAbstractQuery(AlfrescoSolrDataModel.java:1037)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.solr.query.CmisQParserPlugin$CmisQParser.parse(CmisQParserPlugin.java:245)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.search.QParser.getQuery(QParser.java:131)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.handler.component.QueryComponent.prepare(QueryComponent.java:89)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.handler.component.SearchHandler.handleRequestBody(SearchHandler.java:174)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.handler.RequestHandlerBase.handleRequest(RequestHandlerBase.java:131)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.core.SolrCore.execute(SolrCore.java:1316)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.servlet.SolrDispatchFilter.execute(SolrDispatchFilter.java:338)<BR />&nbsp;&nbsp;&nbsp;at org.apache.solr.servlet.SolrDispatchFilter.doFilter(SolrDispatchFilter.java:241)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<BR />&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)<BR />&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)<BR />&nbsp;&nbsp;&nbsp;at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:619)<BR /><BR />2011-10-14 10:38:39,479&nbsp; ERROR [extensions.webscripts.AbstractRuntime] [http-8080-39] Exception from executeScript - redirecting to status template error: 09140006 Wrapped Exception (with status template): 09140274 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 09140273 Request failed 500 /solr/alfresco/cmis?q=select+f.cmis%3AobjectId%2C+w.ws%3AhostName%2C+w.ws%3AhostPort%2C+t.cm%3Adescription+from+cmis%3Afolder+as+f++join+ws%3Awebsite+as+w++on+w.cmis%3AobjectId+%3D+f.cmis%3AobjectId++join+cm%3Atitled+as+t++on+t.cmis%3AobjectId+%3D+f.cmis%3AobjectId&amp;wt=json&amp;fl=*%2Cscore&amp;rows=2147483647&amp;df=TEXT&amp;start=0&amp;locale=en_US&amp;fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON<BR /> org.springframework.extensions.webscripts.WebScriptException: 09140006 Wrapped Exception (with status template): 09140274 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 09140273 Request failed 500 /solr/alfresco/cmis?q=select+f.cmis%3AobjectId%2C+w.ws%3AhostName%2C+w.ws%3AhostPort%2C+t.cm%3Adescription+from+cmis%3Afolder+as+f++join+ws%3Awebsite+as+w++on+w.cmis%3AobjectId+%3D+f.cmis%3AobjectId++join+cm%3Atitled+as+t++on+t.cmis%3AobjectId+%3D+f.cmis%3AobjectId&amp;wt=json&amp;fl=*%2Cscore&amp;rows=2147483647&amp;df=TEXT&amp;start=0&amp;locale=en_US&amp;fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:884)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:393)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:388)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:462)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:500)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:316)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:352)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:189)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)<BR />&nbsp;&nbsp;&nbsp;at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:465)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<BR />&nbsp;&nbsp;&nbsp;at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)<BR />&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)<BR />&nbsp;&nbsp;&nbsp;at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)<BR />&nbsp;&nbsp;&nbsp;at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)<BR />&nbsp;&nbsp;&nbsp;at java.lang.Thread.run(Thread.java:619)<BR />Caused by: org.alfresco.scripts.ScriptException: 09140274 Failed to execute script 'classpath*:alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js': 09140273 Request failed 500 /solr/alfresco/cmis?q=select+f.cmis%3AobjectId%2C+w.ws%3AhostName%2C+w.ws%3AhostPort%2C+t.cm%3Adescription+from+cmis%3Afolder+as+f++join+ws%3Awebsite+as+w++on+w.cmis%3AobjectId+%3D+f.cmis%3AobjectId++join+cm%3Atitled+as+t++on+t.cmis%3AobjectId+%3D+f.cmis%3AobjectId&amp;wt=json&amp;fl=*%2Cscore&amp;rows=2147483647&amp;df=TEXT&amp;start=0&amp;locale=en_US&amp;fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:195)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:1107)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.cmis.rest.CMISWebScript.executeScript(CMISWebScript.java:46)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)<BR />&nbsp;&nbsp;&nbsp;… 25 more<BR />Caused by: org.alfresco.repo.search.impl.lucene.LuceneQueryParserException: 09140273 Request failed 500 /solr/alfresco/cmis?q=select+f.cmis%3AobjectId%2C+w.ws%3AhostName%2C+w.ws%3AhostPort%2C+t.cm%3Adescription+from+cmis%3Afolder+as+f++join+ws%3Awebsite+as+w++on+w.cmis%3AobjectId+%3D+f.cmis%3AobjectId++join+cm%3Atitled+as+t++on+t.cmis%3AobjectId+%3D+f.cmis%3AobjectId&amp;wt=json&amp;fl=*%2Cscore&amp;rows=2147483647&amp;df=TEXT&amp;start=0&amp;locale=en_US&amp;fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrQueryHTTPClient.executeQuery(SolrQueryHTTPClient.java:328)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrQueryLanguage.executeQuery(SolrQueryLanguage.java:49)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.search.impl.solr.SolrCMISQueryServiceImpl.query(SolrCMISQueryServiceImpl.java:93)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.management.subsystems.SubsystemProxyFactory$1.invoke(SubsystemProxyFactory.java:65)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<BR />&nbsp;&nbsp;&nbsp;at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<BR />&nbsp;&nbsp;&nbsp;at $Proxy137.query(Unknown Source)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.cmis.rest.CMISScript.query(CMISScript.java:653)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<BR />&nbsp;&nbsp;&nbsp;at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<BR />&nbsp;&nbsp;&nbsp;at java.lang.reflect.Method.invoke(Method.java:597)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.optimizer.OptRuntime.call2(OptRuntime.java:76)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c21._c0(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js:67)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c21.call(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c21.call(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)<BR />&nbsp;&nbsp;&nbsp;at org.mozilla.javascript.gen.c21.exec(file:/opt/alfresco-4.0.a/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/queries.post.cmisquery.js)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:483)<BR />&nbsp;&nbsp;&nbsp;at org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:191)<BR />&nbsp;&nbsp;&nbsp;… 30 more<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Error is all about executing a query:</SPAN><BR /><PRE class="language-none line-numbers"><CODE>select f.cmis:objectId,<BR />w.ws:hostName,<BR />w.ws:hostPort,<BR />t.cm:title,<BR />t.cm:description,<BR />w.ws:webAppContext,<BR />w.ws:siteConfig<BR />from cmis:folder as f join ws:website as w on w.cmis:objectId = f.cmis:objectId join cm:titled as t on t.cmis:objectId = f.cmis:objectId<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>and if I try to execute it using CMIS Workbench it gives error also - it seems that the problems are fields title and description, which are part of an aspect. Without them the query executes just fine. Is there something missing in WCMQS regarding support for aspects in Alfresco?</SPAN></BODY></HTML> Fri, 14 Oct 2011 09:41:50 GMT dmihelj 2011-10-14T09:41:50Z Error in WCMQS in Alfresco 4.0.a https://connect.hyland.com/t5/alfresco-archive/error-in-wcmqs-in-alfresco-4-0-a/m-p/251830#M204960 Hello!I tried a fresh install of Alfresco 4.0.a with WCM-QS module. I import the website example ("Finance") but the site does not work - it gives error on web page.In logs I get this error<IMG id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />ct 14, 2011 10:38:39 AM org.apache.solr.common.SolrException logSEVERE: org.apache.chemistry.opencmis.commons Fri, 14 Oct 2011 09:41:50 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-wcmqs-in-alfresco-4-0-a/m-p/251830#M204960 dmihelj 2011-10-14T09:41:50Z Re: Error in WCMQS in Alfresco 4.0.a https://connect.hyland.com/t5/alfresco-archive/error-in-wcmqs-in-alfresco-4-0-a/m-p/251831#M204961 <HTML><HEAD></HEAD><BODY><SPAN>Unfortunately this is due to a fault that was introduced very recently in our CMIS implementation. I have raised a bug report in Jira (ALF-10816), and it is being worked on now. The fix for this will be included in 4.0.b which we're hoping to release next week.</SPAN><BR /><BR /><SPAN>Apologies for the inconvenience that this causes.</SPAN></BODY></HTML> Fri, 14 Oct 2011 10:33:28 GMT https://connect.hyland.com/t5/alfresco-archive/error-in-wcmqs-in-alfresco-4-0-a/m-p/251831#M204961 bremmington 2011-10-14T10:33:28Z