Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Enterprise Platforms
- Alfresco
- Alfresco Archive
- Re: CmisRuntimeException: When executing query.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
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
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?
Related Content
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
