REST-API
lovely-dev.1988 Jul 12, 2014 6:17 PMHello,
I'm using REST-API in order to interact with KIE-WB.
I'm facing a problem when I call http://localhost:8080/jbpm-console/rest/task/query [GET].
Status: 500 Internal Server Error
- Response:
- <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
- <response>
- <status>FAILURE</status>
- <error>org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1, column 855 [select distinct new org.jbpm.services.task.query.TaskSummaryImpl(t.id, t.taskData.processInstanceId, name.shortText,subject.shortText,description.shortText, t.taskData.status, t.priority, t.taskData.skipable, actualOwner,createdBy, t.taskData.createdOn,t.taskData.activationTime,t.taskData.expirationTime, t.taskData.processId,t.taskData.processSessionId, t.subTaskStrategy, t.taskData.parentId ) from org.jbpm.services.task.impl.model.TaskImpl t left join t.taskData.actualOwner as actualOwner left join t.taskData.createdBy as createdBy left join t.subjects as subject left join t.descriptions as description left join t.names as name, org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrator, org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners where t.archived = 0 AND ]</error>
- <stackTrace>java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1, column 855 [select distinct new org.jbpm.services.task.query.TaskSummaryImpl(t.id, t.taskData.processInstanceId, name.shortText,subject.shortText,description.shortText, t.taskData.status, t.priority, t.taskData.skipable, actualOwner,createdBy, t.taskData.createdOn,t.taskData.activationTime,t.taskData.expirationTime, t.taskData.processId,t.taskData.processSessionId, t.subTaskStrategy, t.taskData.parentId ) from org.jbpm.services.task.impl.model.TaskImpl t left join t.taskData.actualOwner as actualOwner left join t.taskData.createdBy as createdBy left join t.subjects as subject left join t.descriptions as description left join t.names as name, org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrator, org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners where t.archived = 0 AND ]
- at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1348)
- at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1289)
- at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:288)
- at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryStringWithParametersInTransaction(JPATaskPersistenceContext.java:403)
- at org.jbpm.services.task.impl.TaskQueryServiceImpl.getTasksByVariousFields(TaskQueryServiceImpl.java:480)
- at org.jbpm.services.task.impl.TaskQueryServiceImpl.getTasksByVariousFields(TaskQueryServiceImpl.java:404)
- at org.jbpm.services.task.commands.GetTasksByVariousFieldsCommand.execute(GetTasksByVariousFieldsCommand.java:108)
- at org.jbpm.services.task.commands.GetTasksByVariousFieldsCommand.execute(GetTasksByVariousFieldsCommand.java:28)
- at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)
- at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
- at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:53)
- at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)
- at org.jbpm.services.task.impl.command.CommandBasedTaskService.execute(CommandBasedTaskService.java:128)
- at org.kie.services.remote.rest.RestProcessRequestBean.doTaskOperationOnDeployment(RestProcessRequestBean.java:98)
- at org.kie.services.remote.rest.RestProcessRequestBean.doTaskOperation(RestProcessRequestBean.java:117)
- at org.kie.services.remote.rest.RestProcessRequestBean$Proxy$_$$_WeldClientProxy.doTaskOperation(RestProcessRequestBean$Proxy$_$$_WeldClientProxy.java)
- at org.kie.services.remote.rest.TaskResource.query(TaskResource.java:157)
- at org.kie.services.remote.rest.TaskResource$Proxy$_$$_WeldClientProxy.query(TaskResource$Proxy$_$$_WeldClientProxy.java)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
- at java.lang.reflect.Method.invoke(Method.java:606)
- at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:155)
- at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:257)
- at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:222)
- at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:211)
- at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:525)
- at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:502)
- at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
- at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
- at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
- at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
- at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.jboss.weld.servlet.ConversationPropagationFilter.doFilter(ConversationPropagationFilter.java:62)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.jboss.solder.servlet.exception.CatchExceptionFilter.doFilter(CatchExceptionFilter.java:65)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.jboss.solder.servlet.event.ServletEventBridgeFilter.doFilter(ServletEventBridgeFilter.java:74)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.jbpm.designer.web.filter.impl.PluggableFilter.doFilter(PluggableFilter.java:70)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.uberfire.security.server.UberFireSecurityFilter.doFilter(UberFireSecurityFilter.java:266)
- at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:280)
- at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
- at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
- at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
- at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:397)
- at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
- at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153)
- at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
- at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
- at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:416)
- at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
- at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368)
- at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
- at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671)
- at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930)
- at java.lang.Thread.run(Thread.java:745)
- Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: null near line 1, column 855 [select distinct new org.jbpm.services.task.query.TaskSummaryImpl(t.id, t.taskData.processInstanceId, name.shortText,subject.shortText,description.shortText, t.taskData.status, t.priority, t.taskData.skipable, actualOwner,createdBy, t.taskData.createdOn,t.taskData.activationTime,t.taskData.expirationTime, t.taskData.processId,t.taskData.processSessionId, t.subTaskStrategy, t.taskData.parentId ) from org.jbpm.services.task.impl.model.TaskImpl t left join t.taskData.actualOwner as actualOwner left join t.taskData.createdBy as createdBy left join t.subjects as subject left join t.descriptions as description left join t.names as name, org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrator, org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners where t.archived = 0 AND ]
- at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
- at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
- at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:276)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:180)
- at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:136)
- at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:101)
- at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:80)
- at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:119)
- at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:214)
- at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:192)
- at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1537)
- at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:285)
- ... 61 more
- </stackTrace>
- </response>
Knowing that I'm working with jBPM-6.0.1, have you please some suggestions ?!.
Cordially Greeting