CmisRuntimeException: When executing query.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2014 11:56 AM
I am trying to invoke a query to get me all the documents in a folder but when I try yo iterate through the result, I get the following CmisRuntimeException (Internal Server Error) without any clue as to what caused it in the log. I would appreciate if I could get some help in resolving this issue.
Below I put the relevant code I used to execute the query: [Please note that I am forced to use Alfresco 3.4a and can not upgrade at the moment.]
In getting the session, I used
Caused by: org.apache.chemistry.opencmis.commons.exceptions.CmisRuntimeException: Internal Server Error at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.convertStatusCode(AbstractAtomPubService.java:452) at org.apache.chemistry.opencmis.client.bindings.spi.atompub.AbstractAtomPubService.post(AbstractAtomPubService.java:570) at org.apache.chemistry.opencmis.client.bindings.spi.atompub.DiscoveryServiceImpl.query(DiscoveryServiceImpl.java:142) at org.apache.chemistry.opencmis.client.runtime.SessionImpl$3.fetchPage(SessionImpl.java:567) 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)
Below I put the relevant code I used to execute the query: [Please note that I am forced to use Alfresco 3.4a and can not upgrade at the moment.]
In getting the session, I used
alfresco/service/cmis
for the ATOMPUB_URL path. try { cmisSession = getCmisSession(); // Get Content Type Definition String contentTypeString = "cmis:document"; ObjectType contentType = cmisSession.getTypeDefinition(contentTypeString); // Get Object Id Property Definition PropertyDefinition<?> objectIdPropDef = contentType.getPropertyDefinitions().get(PropertyIds.OBJECT_ID); String objectIdQueryName = objectIdPropDef.getQueryName(); // Define CMIS Query - Get all document IN_FOLDER //Please note the difference of IN_FOLDER (immediate children) vs IN_TREE (matches any object beneath the folder) String cquery = "SELECT " + objectIdQueryName + " FROM " + contentType.getQueryName() + " WHERE IN_FOLDER('" + folderId + "')"; List<com.XXXX.model.v3.Document> docs = new ArrayList<com.XXXX.model.v3.Document>(); OperationContext oc = new OperationContextImpl(); oc.setMaxItemsPerPage(maxItems); // The second param of query(boolean) if set to true will search all // the previous versions.Alfresco does not support searching older version and only false // is valid (See page 340 Alfresco-3-Web-Services book ItemIterable<QueryResult> results = cmisSession.query(cquery, false , oc); for (QueryResult qResult : results) { //THIS IS THE LINE I GET CMISRUNTIMEEXCEPTION —- String objectId = qResult .getPropertyValueByQueryName(PropertyIds.NAME); Document doc = (Document) cmisSession.getObject(cmisSession .createObjectId(objectId)); docs.add(conversionService .convert( doc, com.XXXX.model.v3.Document.class)); } return docs; } catch (CmisBaseException cmisBE) { throw new ApiBusinessException("Could not retreive documents", cmisBE); }
Labels:
- Labels:
-
Archive
4 REPLIES 4
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2014 03:46 AM
You can check and paste alfresco log here,there might be more error information there

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2014 02:14 PM
Thanks Kaynezhang. See below the partial log if it helps you help me.
,detailMessage=Invalid arguments were presented<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Web Script Status 400 - Bad Request</title> <link rel="stylesheet" href="/alfresco/css/webscripts.css" type="text/css" /> </head> <body> <div> <table> <tr> <td><img src="/alfresco/images/logo/AlfrescoLogo32.png" alt="Alfresco" /></td> <td><span class="title">Web Script Status 400 - Bad Request</span></td> </tr> </table> <br/> <table> <tr><td>The Web Script <a href="%2Falfresco%2Fservice%2Fcmis%2Ftype%2Fcmis%3Adocument%2CP%3Acm%3Atitled">/alfresco/service/cmis/type/cmis:document,P:cm:titled</a> has responded with a status of 400 - Bad Request.</td></tr> </table> <br/> <table> <tr><td><b>400 Description:</b></td><td> Request sent by the client was syntactically incorrect.</td></tr> <tr><td> </td></tr> <tr><td><b>Message:</b></td><td>07280333 Invalid typeId cmis:document,P:cm:titled</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Exception:</b></td><td>org.alfresco.cmis.CMISInvalidArgumentException - Invalid typeId cmis:document,P:cm:titled</td></tr> <tr><td></td><td> </td></tr> <tr><td></td><td>org.alfresco.cmis.mapping.CMISServicesImpl.getTypeDefinition(CMISServicesImpl.java:800)</td></tr> <tr><td></td><td>org.alfresco.repo.cmis.rest.CMISScript.queryType(CMISScript.java:528)</td></tr> <tr><td></td><td>sun.reflect.GeneratedMethodAccessor1687.invoke(Unknown Source)</td></tr> <tr><td></td><td>sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</td></tr> <tr><td></td><td>java.lang.reflect.Method.invoke(Unknown Source)</td></tr> <tr><td></td><td>org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)</td></tr> <tr><td></td><td>org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)</td></tr> <tr><td></td><td>org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8._c0(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js:5)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8.call(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js)</td></tr> <tr><td></td><td>org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)</td></tr> <tr><td></td><td>org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8.call(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8.exec(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js)</td></tr> <tr><td></td><td>org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:472)</td></tr> <tr><td></td><td>org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:190)</td></tr> <tr><td></td><td>org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:981)</td></tr> <tr><td></td><td>org.alfresco.repo.cmis.rest.CMISWebScript.executeScript(CMISWebScript.java:46)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:377)</td></tr> <tr><td></td><td>org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:436)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:466)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:304)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:351)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:188)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)</td></tr> <tr><td></td><td>javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</td></tr> <tr><td></td><td>org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</td></tr> <tr><td></td><td>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</td></tr> <tr><td></td><td>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)</td></tr> <tr><td></td><td>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)</td></tr> <tr><td></td><td>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)</td></tr> <tr><td></td><td>org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)</td></tr> <tr><td></td><td>java.lang.Thread.run(Unknown Source)</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Exception:</b></td><td>org.springframework.extensions.webscripts.WebScriptException - 07280333 Invalid typeId cmis:document,P:cm:titled</td></tr> <tr><td></td><td> </td></tr> <tr><td></td><td>org.alfresco.repo.cmis.rest.CMISScript.queryType(CMISScript.java:532)</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Server</b>:</td><td>Enterprise v3.4.1 (.9 49) schema 4,201</td></tr> <tr><td><b>Time</b>:</td><td>Aug 28, 2014 2:05:25 PM</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Diagnostics</b>:</td><td><a href="/alfresco/service/script/org/alfresco/cmis/type.get">Inspect Web Script (org/alfresco/cmis/type.get)</a></td></tr> </table> </div> </body></html>

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2014 02:46 PM
Thanks Kaynezhang. Here is the alfresco log. Hope it help you help me.
Invalid arguments were presented<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"><html xmlns="http://www.w3.org/1999/xhtml"> <head> <title>Web Script Status 400 - Bad Request</title> <link rel="stylesheet" href="/alfresco/css/webscripts.css" type="text/css" /> </head> <body> <div> <table> <tr> <td><img src="/alfresco/images/logo/AlfrescoLogo32.png" alt="Alfresco" /></td> <td><span class="title">Web Script Status 400 - Bad Request</span></td> </tr> </table> <br/> <table> <tr><td>The Web Script <a href="%2Falfresco%2Fservice%2Fcmis%2Ftype%2Fcmis%3Adocument%2CP%3Acm%3Atitled">/alfresco/service/cmis/type/cmis:document,P:cm:titled</a> has responded with a status of 400 - Bad Request.</td></tr> </table> <br/> <table> <tr><td><b>400 Description:</b></td><td> Request sent by the client was syntactically incorrect.</td></tr> <tr><td> </td></tr> <tr><td><b>Message:</b></td><td>07280334 Invalid typeId cmis:document,P:cm:titled</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Exception:</b></td><td>org.alfresco.cmis.CMISInvalidArgumentException - Invalid typeId cmis:document,P:cm:titled</td></tr> <tr><td></td><td> </td></tr> <tr><td></td><td>org.alfresco.cmis.mapping.CMISServicesImpl.getTypeDefinition(CMISServicesImpl.java:800)</td></tr> <tr><td></td><td>org.alfresco.repo.cmis.rest.CMISScript.queryType(CMISScript.java:528)</td></tr> <tr><td></td><td>sun.reflect.GeneratedMethodAccessor1687.invoke(Unknown Source)</td></tr> <tr><td></td><td>sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</td></tr> <tr><td></td><td>java.lang.reflect.Method.invoke(Unknown Source)</td></tr> <tr><td></td><td>org.mozilla.javascript.MemberBox.invoke(MemberBox.java:155)</td></tr> <tr><td></td><td>org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:243)</td></tr> <tr><td></td><td>org.mozilla.javascript.optimizer.OptRuntime.call1(OptRuntime.java:66)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8._c0(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js:5)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8.call(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js)</td></tr> <tr><td></td><td>org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)</td></tr> <tr><td></td><td>org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8.call(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js)</td></tr> <tr><td></td><td>org.mozilla.javascript.gen.c8.exec(file:/alfapp/tomcat/webapps/alfresco/WEB-INF/classes/alfresco/templates/webscripts/org/alfresco/cmis/type.get.js)</td></tr> <tr><td></td><td>org.alfresco.repo.jscript.RhinoScriptProcessor.executeScriptImpl(RhinoScriptProcessor.java:472)</td></tr> <tr><td></td><td>org.alfresco.repo.jscript.RhinoScriptProcessor.execute(RhinoScriptProcessor.java:190)</td></tr> <tr><td></td><td>org.alfresco.repo.processor.ScriptServiceImpl.executeScript(ScriptServiceImpl.java:282)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryScriptProcessor.executeScript(RepositoryScriptProcessor.java:102)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.AbstractWebScript.executeScript(AbstractWebScript.java:981)</td></tr> <tr><td></td><td>org.alfresco.repo.cmis.rest.CMISWebScript.executeScript(CMISWebScript.java:46)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:86)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer$2.execute(RepositoryContainer.java:377)</td></tr> <tr><td></td><td>org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:381)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:436)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:466)</td></tr> <tr><td></td><td>org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:304)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:351)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:188)</td></tr> <tr><td></td><td>org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)</td></tr> <tr><td></td><td>javax.servlet.http.HttpServlet.service(HttpServlet.java:717)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</td></tr> <tr><td></td><td>org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:58)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)</td></tr> <tr><td></td><td>org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)</td></tr> <tr><td></td><td>org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)</td></tr> <tr><td></td><td>org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)</td></tr> <tr><td></td><td>org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)</td></tr> <tr><td></td><td>org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)</td></tr> <tr><td></td><td>org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)</td></tr> <tr><td></td><td>org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)</td></tr> <tr><td></td><td>java.lang.Thread.run(Unknown Source)</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Exception:</b></td><td>org.springframework.extensions.webscripts.WebScriptException - 07280334 Invalid typeId cmis:document,P:cm:titled</td></tr> <tr><td></td><td> </td></tr> <tr><td></td><td>org.alfresco.repo.cmis.rest.CMISScript.queryType(CMISScript.java:532)</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Server</b>:</td><td>Enterprise v3.4.1 (.9 49) schema 4,201</td></tr> <tr><td><b>Time</b>:</td><td>Aug 28, 2014 2:18:21 PM</td></tr> <tr><td></td><td> </td></tr> <tr><td><b>Diagnostics</b>:</td><td><a href="/alfresco/service/script/org/alfresco/cmis/type.get">Inspect Web Script (org/alfresco/cmis/type.get)</a></td></tr> </table> </div> </body></html>
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-31-2014 10:36 PM
which version opencmis are you using?
which version opencmis extention are you using?
which version opencmis extention are you using?
