topic CMIS query throws an exception in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274952#M228082 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><SPAN>I am trying to use CMIS query to retrieve list of documents in the repository (Alfresco enterprise 4.0.1) using the following code:</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemIterable&lt;QueryResult&gt; results = util.getSession().query("select cmis:name from cmis:document", false);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(QueryResult hit: results) {&nbsp; </SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(PropertyData&lt;?&gt; property: hit.getProperties()) {</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String queryName = property.getQueryName();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Object value = property.getFirstValue();</SPAN><BR /><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; System.out.println(queryName + ": " + value);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</SPAN><BR /><BR /><SPAN>However, it throws this exception:</SPAN><BR /><BR /><SPAN>Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: Internal Server Error</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:557)</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 eeoc.gov.ecm.util.cmis.CmisUtil.main(CmisUtil.java:155)</SPAN><BR /><BR /><BR /><SPAN>Am I missing something?</SPAN><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>UPDATE: While browsing this forum, I came across a posting where someone recommended to use "</SPAN><STRONG><A href="http://localhost:8080/alfresco/cmisatom" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco/cmisatom</A></STRONG><SPAN>" instead of "</SPAN><STRONG><A href="http://localhost:8080/alfresco/service/cmis" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco/service/cmis</A></STRONG><SPAN>" for ATOMPUB. This how I get a session:</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Map&lt;String, String&gt; parameter = new HashMap&lt;String, String&gt;();</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.USER, userId);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.PASSWORD, password);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.ATOMPUB_URL, ALFRSCO_ATOMPUB_URL);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;parameter.put(SessionParameter.BINDING_TYPE, BindingType.ATOMPUB.value());</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//parameter.put(SessionParameter.REPOSITORY_ID, REPOSITORY_ID);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;List&lt;Repository&gt; repositories = sessionFactory.getRepositories(parameter);</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;session = repositories.get(0).createSession();</SPAN><BR /><BR /><SPAN>After changing the URL to "</SPAN><STRONG><A href="http://localhost:8080/alfresco/cmisatom" rel="nofollow noopener noreferrer">http://localhost:8080/alfresco/cmisatom</A></STRONG><SPAN>" gives a different exception which&nbsp; is:</SPAN><BR /><BR /><STRONG>Exception in thread "main" org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: 092316733 </STRONG><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:557)</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.AbstractIterator.getTotalNumItems(AbstractIterator.java:70)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at org.apache.chemistry.opencmis.client.runtime.util.AbstractIterable.getTotalNumItems(AbstractIterable.java:94)</SPAN><BR /><SPAN>&nbsp;&nbsp;&nbsp;at eeoc.gov.ecm.util.cmis.CmisUtil.main(CmisUtil.java:156)</SPAN></BODY></HTML> Tue, 23 Oct 2012 14:12:44 GMT vinitp 2012-10-23T14:12:44Z CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274952#M228082 Hello,I am trying to use CMIS query to retrieve list of documents in the repository (Alfresco enterprise 4.0.1) using the following code:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ItemIterable&lt;QueryResult&gt; results = util.getSession().query("select cmis:name from cmis:document", false);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for(QueryRes Tue, 23 Oct 2012 14:12:44 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274952#M228082 vinitp 2012-10-23T14:12:44Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274953#M228083 <HTML><HEAD></HEAD><BODY><SPAN>Hey!</SPAN><BR /><BR /><SPAN>Even I am hitting the same exception. Also, the number keeps incrementing every time. <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /> <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN></BODY></HTML> Tue, 30 Oct 2012 09:24:10 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274953#M228083 jeffreydare 2012-10-30T09:24:10Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274954#M228084 <HTML><HEAD></HEAD><BODY><SPAN>check this post</SPAN><BR /><BR /><A href="https://forums.alfresco.com/en/viewtopic.php?f=45&amp;t=45962" rel="nofollow noopener noreferrer">https://forums.alfresco.com/en/viewtopic.php?f=45&amp;t=45962</A><BR /><BR /><SPAN>Its solved mine</SPAN></BODY></HTML> Tue, 30 Oct 2012 09:42:46 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274954#M228084 jeffreydare 2012-10-30T09:42:46Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274955#M228085 <HTML><HEAD></HEAD><BODY><SPAN>yeah, it helped me!</SPAN></BODY></HTML> Fri, 14 Dec 2012 20:42:48 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274955#M228085 rubys00 2012-12-14T20:42:48Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274956#M228086 <HTML><HEAD></HEAD><BODY><SPAN>good to know! thx<img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://connect.hyland.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></SPAN></BODY></HTML> Thu, 07 Feb 2013 10:08:28 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274956#M228086 jkonar 2013-02-07T10:08:28Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274957#M228087 <HTML><HEAD></HEAD><BODY><SPAN>have you got any other ideas? </SPAN></BODY></HTML> Wed, 20 Feb 2013 13:42:58 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274957#M228087 robaczka 2013-02-20T13:42:58Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274958#M228088 <HTML><HEAD></HEAD><BODY><P><A class="" href="https://forums.alfresco.com/en/viewtopic.php?f=45&amp;t=45962" rel="nofollow noopener noreferrer" style="color: #1e88e5; background-color: #ffffff; border: 0px; text-decoration: none; padding: 0px calc(12px + 0.35ex) 0px 0px;" target="_blank">https://forums.alfresco.com/en/viewtopic.php?f=45&amp;t=45962</A>&nbsp;this link is not opening for me. Can anyone please provide the solution?&nbsp;</P></BODY></HTML> Thu, 03 Aug 2017 08:12:44 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274958#M228088 avik84 2017-08-03T08:12:44Z Re: CMIS query throws an exception https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274959#M228089 <HTML><HEAD></HEAD><BODY><P>Please anyone with the solution, please re-post it here.</P></BODY></HTML> Mon, 14 Aug 2017 08:32:25 GMT https://connect.hyland.com/t5/alfresco-archive/cmis-query-throws-an-exception/m-p/274959#M228089 aowian 2017-08-14T08:32:25Z