API tools faq
paste
Advertisement
Guest User

Not a group by

a guest
Sep 25th, 2015
25
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.05 KB | None | 0 0
raw download clone embed print report
  1. 2015-09-25 17:04:04,161 [main|org.jbpm.services.task.persistence.TaskTransactionInterceptor] WARN Could not commit session
  2. javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  3. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) ~[hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
  4. at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) ~[hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
  5. at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:277) ~[hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
  6. at org.hibernate.ejb.criteria.CriteriaQueryCompiler$3.getResultList(CriteriaQueryCompiler.java:254) ~[hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
  7. at org.jbpm.services.task.persistence.TaskQueryCriteriaUtil.createQueryAndCallApplyMetaCriteriaAndGetResult(TaskQueryCriteriaUtil.java:580) ~[jbpm-human-task-jpa-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  8. at org.jbpm.services.task.persistence.TaskQueryCriteriaUtil.doCriteriaQuery(TaskQueryCriteriaUtil.java:221) ~[jbpm-human-task-jpa-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  9. at org.jbpm.services.task.persistence.JPATaskPersistenceContext.doTaskSummaryCriteriaQuery(JPATaskPersistenceContext.java:489) ~[jbpm-human-task-jpa-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  10. at org.jbpm.services.task.impl.TaskQueryServiceImpl.query(TaskQueryServiceImpl.java:633) ~[classes/:na]
  11. at org.jbpm.services.task.impl.TaskQueryServiceImpl.getTasksByVariousFields(TaskQueryServiceImpl.java:589) ~[classes/:na]
  12. at org.jbpm.services.task.commands.GetTasksByVariousFieldsCommand.execute(GetTasksByVariousFieldsCommand.java:241) ~[classes/:na]
  13. at org.jbpm.services.task.commands.GetTasksByVariousFieldsCommand.execute(GetTasksByVariousFieldsCommand.java:43) ~[classes/:na]
  14. at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65) ~[classes/:na]
  15. at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  16. at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:69) ~[jbpm-human-task-jpa-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  17. at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  18. at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) [drools-persistence-jpa-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  19. at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41) [drools-core-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  20. at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:82) [drools-persistence-jpa-6.3.0-SNAPSHOT.jar:6.3.0-SNAPSHOT]
  21. at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40) [classes/:na]
  22. at org.jbpm.services.task.impl.command.CommandBasedTaskService.getTasksByVariousFields(CommandBasedTaskService.java:307) [classes/:na]
  23. at org.jbpm.services.task.query.TaskQueryBuilderLocalTest.testGetTasksByVariousFieldsWithUserGroupCallback(TaskQueryBuilderLocalTest.java:325) [test-classes/:na]
  24. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_25]
  25. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_25]
  26. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
  27. at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
  28. at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:47) [junit-4.11.jar:na]
  29. at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.11.jar:na]
  30. at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:44) [junit-4.11.jar:na]
  31. at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) [junit-4.11.jar:na]
  32. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) [junit-4.11.jar:na]
  33. at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) [junit-4.11.jar:na]
  34. at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:271) [junit-4.11.jar:na]
  35. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:70) [junit-4.11.jar:na]
  36. at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50) [junit-4.11.jar:na]
  37. at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238) [junit-4.11.jar:na]
  38. at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63) [junit-4.11.jar:na]
  39. at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236) [junit-4.11.jar:na]
  40. at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53) [junit-4.11.jar:na]
  41. at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229) [junit-4.11.jar:na]
  42. at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) [junit-4.11.jar:na]
  43. at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) [junit-4.11.jar:na]
  44. at org.junit.runners.ParentRunner.run(ParentRunner.java:309) [junit-4.11.jar:na]
  45. at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:283) [surefire-junit4-2.18.1.jar:2.18.1]
  46. at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:173) [surefire-junit4-2.18.1.jar:2.18.1]
  47. at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153) [surefire-junit4-2.18.1.jar:2.18.1]
  48. at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:128) [surefire-junit4-2.18.1.jar:2.18.1]
  49. at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:203) [surefire-booter-2.18.1.jar:2.18.1]
  50. at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:155) [surefire-booter-2.18.1.jar:2.18.1]
  51. at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103) [surefire-booter-2.18.1.jar:2.18.1]
  52. Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  53. at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  54. at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  55. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  56. at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  57. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:88) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  58. at org.hibernate.loader.Loader.getResultSet(Loader.java:2062) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  59. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1859) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  60. at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1838) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  61. at org.hibernate.loader.Loader.doQuery(Loader.java:906) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  62. at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:348) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  63. at org.hibernate.loader.Loader.doList(Loader.java:2550) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  64. at org.hibernate.loader.Loader.doList(Loader.java:2536) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  65. at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2366) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  66. at org.hibernate.loader.Loader.list(Loader.java:2361) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  67. at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:495) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  68. at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:357) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  69. at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:198) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  70. at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1230) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  71. at org.hibernate.internal.QueryImpl.list(QueryImpl.java:101) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  72. at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:268) ~[hibernate-entitymanager-4.2.20.Final.jar:4.2.20.Final]
  73. ... 46 common frames omitted
  74. Caused by: java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
  75.  
  76. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) ~[ojdbc6.jar:12.1.0.2.0]
  77. at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) ~[ojdbc6.jar:12.1.0.2.0]
  78. at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) ~[ojdbc6.jar:12.1.0.2.0]
  79. at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) ~[ojdbc6.jar:12.1.0.2.0]
  80. at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) ~[ojdbc6.jar:12.1.0.2.0]
  81. at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) ~[ojdbc6.jar:12.1.0.2.0]
  82. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) ~[ojdbc6.jar:12.1.0.2.0]
  83. at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) ~[ojdbc6.jar:12.1.0.2.0]
  84. at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) ~[ojdbc6.jar:12.1.0.2.0]
  85. at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) ~[ojdbc6.jar:12.1.0.2.0]
  86. at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) ~[ojdbc6.jar:12.1.0.2.0]
  87. at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) ~[ojdbc6.jar:12.1.0.2.0]
  88. at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) ~[ojdbc6.jar:12.1.0.2.0]
  89. at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) ~[ojdbc6.jar:12.1.0.2.0]
  90. at bitronix.tm.resource.jdbc.JdbcUncachedPreparedStatementHandle.executeQuery(JdbcUncachedPreparedStatementHandle.java:81) ~[btm-2.1.4.jar:2.1.4]
  91. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_25]
  92. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_25]
  93. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_25]
  94. at java.lang.reflect.Method.invoke(Method.java:483) ~[na:1.8.0_25]
  95. at bitronix.tm.resource.jdbc.BaseProxyHandlerClass.invoke(BaseProxyHandlerClass.java:64) ~[btm-2.1.4.jar:2.1.4]
  96. at com.sun.proxy.$Proxy34.executeQuery(Unknown Source) ~[na:na]
  97. at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:79) ~[hibernate-core-4.2.20.Final.jar:4.2.20.Final]
  98. ... 61 common frames omitted
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!