API tools faq
paste
Guest User

Untitled

a guest
Apr 9th, 2015
234
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 14.84 KB | None | 0 0
raw download clone embed print report
  1. <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
  2. <exception>
  3.     <status>FAILURE</status>
  4.     <url>http://localhost:8080/business-central/rest/query/runtime/task?var_pVar=pValue</url>
  5.     <message>IllegalArgumentException thrown with message 'org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: WHERE near line 23, column 1 [SELECT distinct new org.jbpm.services.task.query.TaskSummaryImpl(
  6.        t.id,
  7.        t.name,
  8.        t.description,
  9.        t.taskData.status,
  10.        t.priority,
  11.        t.taskData.actualOwner.id,
  12.        t.taskData.createdBy.id,
  13.        t.taskData.createdOn,
  14.        t.taskData.activationTime,
  15.        t.taskData.expirationTime,
  16.        t.taskData.processId,
  17.        t.taskData.processInstanceId,
  18.        t.taskData.parentId,
  19.        t.taskData.deploymentId )
  20. FROM org.jbpm.services.task.impl.model.TaskImpl t,
  21.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl stakeHolders,
  22.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners,
  23.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrators
  24. , org.jbpm.process.audit.VariableInstanceLog v
  25. WHERE t.archived = 0
  26.  
  27. WHERE v.processInstanceId = t.taskData.processInstanceId
  28. AND (v.id IN (SELECT MAX(ll.id) FROM org.jbpm.process.audit.VariableInstanceLog ll GROUP BY ll.variableId, ll.processInstanceId))
  29. AND ( v.variableId = :A1 AND v.value = :B1 ) )
  30. AND ( ( t.taskData.createdBy.id = :C1
  31.  OR ( stakeHolders.id in :D1 and
  32.   stakeHolders in elements ( t.peopleAssignments.taskStakeholders ) )
  33.  OR ( potentialOwners.id in :D1 and
  34.   potentialOwners in elements ( t.peopleAssignments.potentialOwners ) )
  35.  OR t.taskData.actualOwner.id = :C1
  36.  OR ( businessAdministrators.id in :D1 and
  37.   businessAdministrators in elements ( t.peopleAssignments.businessAdministrators ) ) )
  38. )  ORDER BY t.taskData.processInstanceId]'</message>
  39.     <stackTrace>org.kie.remote.services.rest.exception.KieRemoteRestOperationException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: WHERE near line 23, column 1 [SELECT distinct new org.jbpm.services.task.query.TaskSummaryImpl(
  40.        t.id,
  41.        t.name,
  42.        t.description,
  43.        t.taskData.status,
  44.        t.priority,
  45.        t.taskData.actualOwner.id,
  46.        t.taskData.createdBy.id,
  47.        t.taskData.createdOn,
  48.        t.taskData.activationTime,
  49.        t.taskData.expirationTime,
  50.        t.taskData.processId,
  51.        t.taskData.processInstanceId,
  52.        t.taskData.parentId,
  53.        t.taskData.deploymentId )
  54. FROM org.jbpm.services.task.impl.model.TaskImpl t,
  55.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl stakeHolders,
  56.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners,
  57.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrators
  58. , org.jbpm.process.audit.VariableInstanceLog v
  59. WHERE t.archived = 0
  60.  
  61. WHERE v.processInstanceId = t.taskData.processInstanceId
  62. AND (v.id IN (SELECT MAX(ll.id) FROM org.jbpm.process.audit.VariableInstanceLog ll GROUP BY ll.variableId, ll.processInstanceId))
  63. AND ( v.variableId = :A1 AND v.value = :B1 ) )
  64. AND ( ( t.taskData.createdBy.id = :C1
  65.  OR ( stakeHolders.id in :D1 and
  66.   stakeHolders in elements ( t.peopleAssignments.taskStakeholders ) )
  67.  OR ( potentialOwners.id in :D1 and
  68.   potentialOwners in elements ( t.peopleAssignments.potentialOwners ) )
  69.  OR t.taskData.actualOwner.id = :C1
  70.  OR ( businessAdministrators.id in :D1 and
  71.   businessAdministrators in elements ( t.peopleAssignments.businessAdministrators ) ) )
  72. )  ORDER BY t.taskData.processInstanceId]
  73.     at org.kie.remote.services.rest.exception.KieRemoteRestOperationException.internalServerError(KieRemoteRestOperationException.java:132)
  74.     at org.kie.remote.services.cdi.ProcessRequestBean.doTaskOperation(ProcessRequestBean.java:323)
  75.     at org.kie.remote.services.cdi.ProcessRequestBean.doRestTaskOperation(ProcessRequestBean.java:330)
  76.     at org.kie.remote.services.cdi.ProcessRequestBean$Proxy$_$$_WeldClientProxy.doRestTaskOperation(ProcessRequestBean$Proxy$_$$_WeldClientProxy.java)
  77.     at org.kie.remote.services.rest.ResourceBase.doRestTaskOperation(ResourceBase.java:535)
  78.     at org.kie.remote.services.rest.query.InternalTaskQueryHelper.doQueryAndCreateResultObjects(InternalTaskQueryHelper.java:113)
  79.     at org.kie.remote.services.rest.query.InternalTaskQueryHelper.doQueryAndCreateResultObjects(InternalTaskQueryHelper.java:32)
  80.     at org.kie.remote.services.rest.query.AbstractInternalQueryHelper.queryTaskOrProcInstAndAssociatedVariables(AbstractInternalQueryHelper.java:140)
  81.     at org.kie.remote.services.rest.QueryResourceImpl.queryTasks(QueryResourceImpl.java:65)
  82.     at org.kie.remote.services.rest.QueryResourceImpl$Proxy$_$$_WeldClientProxy.queryTasks(QueryResourceImpl$Proxy$_$$_WeldClientProxy.java)
  83.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  84.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  85.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  86.     at java.lang.reflect.Method.invoke(Method.java:606)
  87.     at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168)
  88.     at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269)
  89.     at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227)
  90.     at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216)
  91.     at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541)
  92.     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523)
  93.     at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125)
  94.     at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
  95.     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
  96.     at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
  97.     at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
  98.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)
  99.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
  100.     at org.kie.remote.services.rest.jaxb.DynamicJaxbContextFilter.doFilter(DynamicJaxbContextFilter.java:48)
  101.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
  102.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
  103.     at org.uberfire.ext.security.server.BasicAuthSecurityFilter.doFilter(BasicAuthSecurityFilter.java:53)
  104.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
  105.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
  106.     at org.uberfire.ext.security.server.SecureHeadersFilter.doFilter(SecureHeadersFilter.java:53)
  107.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
  108.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
  109.     at org.uberfire.ext.security.server.SecurityIntegrationFilter.doFilter(SecurityIntegrationFilter.java:64)
  110.     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)
  111.     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)
  112.     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)
  113.     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)
  114.     at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:420)
  115.     at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
  116.     at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50)
  117.     at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)
  118.     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)
  119.     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)
  120.     at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:419)
  121.     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)
  122.     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
  123.     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:854)
  124.     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653)
  125.     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)
  126.     at java.lang.Thread.run(Thread.java:744)
  127. Caused by: java.lang.IllegalArgumentException: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: WHERE near line 23, column 1 [SELECT distinct new org.jbpm.services.task.query.TaskSummaryImpl(
  128.        t.id,
  129.        t.name,
  130.        t.description,
  131.        t.taskData.status,
  132.        t.priority,
  133.        t.taskData.actualOwner.id,
  134.        t.taskData.createdBy.id,
  135.        t.taskData.createdOn,
  136.        t.taskData.activationTime,
  137.        t.taskData.expirationTime,
  138.        t.taskData.processId,
  139.        t.taskData.processInstanceId,
  140.        t.taskData.parentId,
  141.        t.taskData.deploymentId )
  142. FROM org.jbpm.services.task.impl.model.TaskImpl t,
  143.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl stakeHolders,
  144.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners,
  145.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrators
  146. , org.jbpm.process.audit.VariableInstanceLog v
  147. WHERE t.archived = 0
  148.  
  149. WHERE v.processInstanceId = t.taskData.processInstanceId
  150. AND (v.id IN (SELECT MAX(ll.id) FROM org.jbpm.process.audit.VariableInstanceLog ll GROUP BY ll.variableId, ll.processInstanceId))
  151. AND ( v.variableId = :A1 AND v.value = :B1 ) )
  152. AND ( ( t.taskData.createdBy.id = :C1
  153.  OR ( stakeHolders.id in :D1 and
  154.   stakeHolders in elements ( t.peopleAssignments.taskStakeholders ) )
  155.  OR ( potentialOwners.id in :D1 and
  156.   potentialOwners in elements ( t.peopleAssignments.potentialOwners ) )
  157.  OR t.taskData.actualOwner.id = :C1
  158.  OR ( businessAdministrators.id in :D1 and
  159.   businessAdministrators in elements ( t.peopleAssignments.businessAdministrators ) ) )
  160. )  ORDER BY t.taskData.processInstanceId]
  161.     at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1374)
  162.     at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
  163.     at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:294)
  164.     at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryStringWithParametersInTransaction(JPATaskPersistenceContext.java:415)
  165.     at org.jbpm.services.task.impl.TaskQueryServiceImpl.query(TaskQueryServiceImpl.java:816)
  166.     at org.jbpm.services.task.commands.TaskQueryDataCommand.execute(TaskQueryDataCommand.java:43)
  167.     at org.jbpm.services.task.commands.TaskQueryDataCommand.execute(TaskQueryDataCommand.java:14)
  168.     at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)
  169.     at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
  170.     at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:54)
  171.     at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
  172.     at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:67)
  173.     at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)
  174.     at org.jbpm.services.task.impl.command.CommandBasedTaskService.execute(CommandBasedTaskService.java:139)
  175.     at org.jbpm.kie.services.impl.UserTaskServiceImpl.execute(UserTaskServiceImpl.java:921)
  176.     at org.jbpm.services.cdi.impl.UserTaskServiceCDIImpl$Proxy$_$$_WeldClientProxy.execute(UserTaskServiceCDIImpl$Proxy$_$$_WeldClientProxy.java)
  177.     at org.kie.remote.services.cdi.ProcessRequestBean.doTaskOperation(ProcessRequestBean.java:315)
  178.     ... 52 more
  179. Caused by: org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: WHERE near line 23, column 1 [SELECT distinct new org.jbpm.services.task.query.TaskSummaryImpl(
  180.        t.id,
  181.        t.name,
  182.        t.description,
  183.        t.taskData.status,
  184.        t.priority,
  185.        t.taskData.actualOwner.id,
  186.        t.taskData.createdBy.id,
  187.        t.taskData.createdOn,
  188.        t.taskData.activationTime,
  189.        t.taskData.expirationTime,
  190.        t.taskData.processId,
  191.        t.taskData.processInstanceId,
  192.        t.taskData.parentId,
  193.        t.taskData.deploymentId )
  194. FROM org.jbpm.services.task.impl.model.TaskImpl t,
  195.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl stakeHolders,
  196.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl potentialOwners,
  197.      org.jbpm.services.task.impl.model.OrganizationalEntityImpl businessAdministrators
  198. , org.jbpm.process.audit.VariableInstanceLog v
  199. WHERE t.archived = 0
  200.  
  201. WHERE v.processInstanceId = t.taskData.processInstanceId
  202. AND (v.id IN (SELECT MAX(ll.id) FROM org.jbpm.process.audit.VariableInstanceLog ll GROUP BY ll.variableId, ll.processInstanceId))
  203. AND ( v.variableId = :A1 AND v.value = :B1 ) )
  204. AND ( ( t.taskData.createdBy.id = :C1
  205.  OR ( stakeHolders.id in :D1 and
  206.   stakeHolders in elements ( t.peopleAssignments.taskStakeholders ) )
  207.  OR ( potentialOwners.id in :D1 and
  208.   potentialOwners in elements ( t.peopleAssignments.potentialOwners ) )
  209.  OR t.taskData.actualOwner.id = :C1
  210.  OR ( businessAdministrators.id in :D1 and
  211.   businessAdministrators in elements ( t.peopleAssignments.businessAdministrators ) ) )
  212. )  ORDER BY t.taskData.processInstanceId]
  213.     at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:54)
  214.     at org.hibernate.hql.internal.ast.QuerySyntaxException.convert(QuerySyntaxException.java:47)
  215.     at org.hibernate.hql.internal.ast.ErrorCounter.throwQueryException(ErrorCounter.java:79)
  216.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.parse(QueryTranslatorImpl.java:278)
  217.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:182)
  218.     at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:138)
  219.     at org.hibernate.engine.query.spi.HQLQueryPlan.&lt;init&gt;(HQLQueryPlan.java:104)
  220.     at org.hibernate.engine.query.spi.HQLQueryPlan.&lt;init&gt;(HQLQueryPlan.java:79)
  221.     at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:168)
  222.     at org.hibernate.internal.AbstractSessionImpl.getHQLQueryPlan(AbstractSessionImpl.java:222)
  223.     at org.hibernate.internal.AbstractSessionImpl.createQuery(AbstractSessionImpl.java:200)
  224.     at org.hibernate.internal.SessionImpl.createQuery(SessionImpl.java:1739)
  225.     at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:291)
  226.     ... 66 more
  227. </stackTrace>
  228. </exception>
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!