Sybase: GetSubTasksByParentTaskId query syntax fails

Five tests

• org.jbpm.services.task.SubTasksLocalTest
  • onSubtaskCompletionAutoCompleteParentStrategy
  • onParentAbortCompleteAllSubTasksStrategy
  • noActionStrategy
• org.jbpm.services.task.query.TaskQueryServiceLocalTest
  • testGetPendingSubTasksByParentWithParentNoTask
  • testGetSubTasksByParentWithParentNoTask

are failing with this exception:

javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not extract ResultSet at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1515) at org.hibernate.query.Query.getResultList(Query.java:132) at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryStringWithParameters(JPATaskPersistenceContext.java:668) at org.jbpm.services.task.persistence.JPATaskPersistenceContext.queryWithParametersInTransaction(JPATaskPersistenceContext.java:480) at org.jbpm.services.task.impl.TaskQueryServiceImpl.getPendingSubTasksByParent(TaskQueryServiceImpl.java:401) at org.jbpm.services.task.commands.GetPendingSubTasksCommand.execute(GetPendingSubTasksCommand.java:54) at org.jbpm.services.task.commands.GetPendingSubTasksCommand.execute(GetPendingSubTasksCommand.java:27) at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:80) at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65) at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:88) at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:49) at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:73) at org.drools.persistence.jta.TransactionLockInterceptor.execute(TransactionLockInterceptor.java:45) at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:39) at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.internalExecute(OptimisticLockRetryInterceptor.java:102) at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:83) at org.drools.persistence.jpa.OptimisticLockRetryInterceptor.execute(OptimisticLockRetryInterceptor.java:44) at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:37) at org.drools.core.runtime.InternalLocalRunner.execute(InternalLocalRunner.java:41) at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:49) at org.jbpm.services.task.impl.command.CommandBasedTaskService.getPendingSubTasksByParent(CommandBasedTaskService.java:434) at org.jbpm.services.task.SubTasksBaseTest.onSubtaskCompletionAutoCompleteParentStrategy(SubTasksBaseTest.java:139) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:26) at org.junit.internal.runners.statements.RunAfters.evaluate(RunAfters.java:27) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:365) at org.apache.maven.surefire.junit4.JUnit4Provider.executeWithRerun(JUnit4Provider.java:273) at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:238) at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:159) at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:384) at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:345) at org.apache.maven.surefire.booter.ForkedBooter.execute(ForkedBooter.java:126) at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:418) Caused by: org.hibernate.exception.GenericJDBCException: could not extract ResultSet at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69) at org.hibernate.loader.Loader.getResultSet(Loader.java:2265) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2028) at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1990) at org.hibernate.loader.Loader.doQuery(Loader.java:949) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:351) at org.hibernate.loader.Loader.doList(Loader.java:2787) at org.hibernate.loader.Loader.doList(Loader.java:2770) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2604) at org.hibernate.loader.Loader.list(Loader.java:2599) at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:505) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1526) at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1538) at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1506) ... 52 more Caused by: com.sybase.jdbc4.jdbc.SybSQLException: Adaptive Server cannot perform the requested action because column 'processInstanceId' is not within the scope of the joined table expression. Check your command for missing or incorrect database objects, variable names, and/or input data. at com.sybase.jdbc4.tds.Tds.processEed(Tds.java:4003) at com.sybase.jdbc4.tds.Tds.nextResult(Tds.java:3093) at com.sybase.jdbc4.jdbc.ResultGetter.nextResult(ResultGetter.java:78) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:289) at com.sybase.jdbc4.jdbc.SybStatement.nextResult(SybStatement.java:271) at com.sybase.jdbc4.jdbc.SybStatement.queryLoop(SybStatement.java:2408) at com.sybase.jdbc4.jdbc.SybStatement.executeQuery(SybStatement.java:2394) at com.sybase.jdbc4.jdbc.SybPreparedStatement.executeQuery(SybPreparedStatement.java:257) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60) ... 67 more