topic Select cmis error in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/select-cmis-error/m-p/283172#M236302 <HTML><HEAD></HEAD><BODY><SPAN>I have the source code:</SPAN><BR /><BR /><PRE class="language-java line-numbers"><CODE><BR />public List getAlfrescoDocuments() {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List documents = new ArrayList();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String myType = "cmis:document";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Session session = getAlfrecoSession();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // get the query name of cmis:objectId<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ObjectType type = session.getTypeDefinition(myType);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PropertyDefinition&lt;?&gt; objectIdPropDef = type.getPropertyDefinitions().get(PropertyIds.OBJECT_ID);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String objectIdQueryName = objectIdPropDef.getQueryName();<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String queryString ="select d.cmis:objectId from cmis:document as d join p:custom:DocumentSigesa as o on d.cmis:objectId = o.cmis:objectId";<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(queryString);<BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // execute query<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemIterable&lt;QueryResult&gt; results = session.query(queryString, false);<BR /> <BR /><BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (QueryResult qResult : results) {<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String objectId = qResult.getPropertyValueByQueryName(objectIdQueryName);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Document doc = (Document) session.getObject(session.createObjectId(objectId));<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; documents.add(doc);<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println("Entra");<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return documents;<BR />&nbsp;&nbsp;&nbsp; }<BR /><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></CODE></PRE><BR /><BR /><BR /><SPAN>But, i get the error:</SPAN><BR /><BR /><BR /><SPAN>Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: 04248255 Request failed 500 /solr/alfresco/cmis?wt=json&amp;amp;fl=DBID%2Cscore&amp;amp;rows=100&amp;amp;df=TEXT&amp;amp;start=0&amp;amp;locale=en_US&amp;amp;fq=%7B%21afts%7DAUTHORITY_FILTER_FROM_JSON&amp;amp;fq=%7B%21afts%7DTENANT_FILTER_FROM_JSON</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:452)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:570)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:142)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:567)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterator.getCurrentPage(AbstractIterator.java:132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.CollectionIterator.hasNext(CollectionIterator.java:48)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at cr.ac.una.cmis.AlfresoService.getAlfrescoDocuments(AlfresoService.java:132)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at cr.ac.una.cmis.Main.main(Main.java:19)</SPAN><BR /><BR /><BR /><SPAN>The problem is the query, but i don see the error, other querys work.</SPAN><BR /><BR /><SPAN>Allam</SPAN><BR /><BR /><BR /></BODY></HTML> Fri, 24 May 2013 15:04:10 GMT allamchz 2013-05-24T15:04:10Z Select cmis error https://connect.hyland.com/t5/alfresco-archive/select-cmis-error/m-p/283172#M236302 I have the source code<IMG id="smileytongue" class="emoticon emoticon-smileytongue" src="https://migration33.stage.lithium.com/i/smilies/16x16_smiley-tongue.png" alt="Smiley Tongue" title="Smiley Tongue" />ublic List getAlfrescoDocuments() {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; List documents = new ArrayList();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String myType = "cmis:document";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Session session = getAlfrecoSession();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; // get the query name of cmis<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" />bjectId&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ObjectType type = session.getTypeDefinition(myType);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Fri, 24 May 2013 15:04:10 GMT https://connect.hyland.com/t5/alfresco-archive/select-cmis-error/m-p/283172#M236302 allamchz 2013-05-24T15:04:10Z Re: Select cmis error https://connect.hyland.com/t5/alfresco-archive/select-cmis-error/m-p/283173#M236303 <HTML><HEAD></HEAD><BODY><SPAN>SELECT cmis<img id="smileysurprised" class="emoticon emoticon-smileysurprised" src="https://connect.hyland.com/i/smilies/16x16_smiley-surprised.png" alt="Smiley Surprised" title="Smiley Surprised" />bjectId FROM cmis:document WHERE IN_FOLDER('folder id')"</SPAN><BR /><BR /><SPAN>this another query does not work</SPAN></BODY></HTML> Fri, 24 May 2013 15:07:47 GMT https://connect.hyland.com/t5/alfresco-archive/select-cmis-error/m-p/283173#M236303 allamchz 2013-05-24T15:07:47Z