Hi everyone,

I have a PPM workplan and I am trying to change the status one of its tasks.

But when I clicked Save, the original status of the task remained and nothing happened to the change I wanted to do.

I have these error in the serverlog. Kindly help me to check the issue and resolve it? Thank you.

ERROR JSESSIONID=F71534CDC7C2CE00479FBB51FC62DCEF.prod_5,USERNAME=DY_H server:http-nio-8084-exec-29:(ExceptionEngine.java:296):2024/10/03-12:43:24.782 SAST: java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=com.mercury.itg.pm.model.Task.taskInfo,tableName=wp_task_info,tableAlias=taskinfo8_,origin=wp_tasks task7_,columns={task7_.task_info_id,className=com.mercury.itg.pm.model.TaskInfo}}] [select tk from com.mercury.itg.pm.model.Task tk, com.mercury.itg.pm.model.Task t2 inner join tk.workPlan wp inner join fetch tk.workPlan inner join tk.taskInfo ti left outer join tk.parent.taskInfo pi left outer join fetch tk.parent.taskInfo where wp.id = :id and t2.workPlan.id = :id and t2 in (:summaryTasks) and tk.ancestorIdList like t2.ancestorIdList || t2.id || '%' and (tk.taskInfo.taskType = 'L' or tk.taskInfo.taskType = 'M') and (ti.status != 6 and ti.status != 7 and (pi is null or pi.status = 5)) and tk.schedule.scheduledFinish < sysdate and ti.criticalPathTask = 1]
java.lang.IllegalArgumentException: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=com.mercury.itg.pm.model.Task.taskInfo,tableName=wp_task_info,tableAlias=taskinfo8_,origin=wp_tasks task7_,columns={task7_.task_info_id,className=com.mercury.itg.pm.model.TaskInfo}}] [select tk from com.mercury.itg.pm.model.Task tk, com.mercury.itg.pm.model.Task t2 inner join tk.workPlan wp inner join fetch tk.workPlan inner join tk.taskInfo ti left outer join tk.parent.taskInfo pi left outer join fetch tk.parent.taskInfo where wp.id = :id and t2.workPlan.id = :id and t2 in (:summaryTasks) and tk.ancestorIdList like t2.ancestorIdList || t2.id || '%' and (tk.taskInfo.taskType = 'L' or tk.taskInfo.taskType = 'M') and (ti.status != 6 and ti.status != 7 and (pi is null or pi.status = 5)) and tk.schedule.scheduledFinish < sysdate and ti.criticalPathTask = 1]
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:138)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)
at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:757)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:114)
at com.mercury.itg.pm.engine.exception.rules.CriticalPathLateExceptionRule.postProcessSummary(CriticalPathLateExceptionRule.java:263)

Caused by: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=com.mercury.itg.pm.model.Task.taskInfo,tableName=wp_task_info,tableAlias=taskinfo8_,origin=wp_tasks task7_,columns={task7_.task_info_id,className=com.mercury.itg.pm.model.TaskInfo}}] [select tk from com.mercury.itg.pm.model.Task tk, com.mercury.itg.pm.model.Task t2 inner join tk.workPlan wp inner join fetch tk.workPlan inner join tk.taskInfo ti left outer join tk.parent.taskInfo pi left outer join fetch tk.parent.taskInfo where wp.id = :id and t2.workPlan.id = :id and t2 in (:summaryTasks) and tk.ancestorIdList like t2.ancestorIdList || t2.id || '%' and (tk.taskInfo.taskType = 'L' or tk.taskInfo.taskType = 'M') and (ti.status != 6 and ti.status != 7 and (pi is null or pi.status = 5)) and tk.schedule.scheduledFinish < sysdate and ti.criticalPathTask = 1]
at org.hibernate.QueryException.generateQueryException(QueryException.java:120)
at org.hibernate.QueryException.wrapWithQueryString(QueryException.java:103)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:220)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:144)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:112)
at org.hibernate.engine.query.spi.HQLQueryPlan.<init>(HQLQueryPlan.java:73)
at org.hibernate.engine.query.spi.QueryPlanCache.getHQLQueryPlan(QueryPlanCache.java:162)
at org.hibernate.internal.AbstractSharedSessionContract.getQueryPlan(AbstractSharedSessionContract.java:636)
at org.hibernate.internal.AbstractSharedSessionContract.createQuery(AbstractSharedSessionContract.java:748)
... 156 more
Caused by: org.hibernate.QueryException: query specified join fetching, but the owner of the fetched association was not present in the select list [FromElement{explicit,not a collection join,fetch join,fetch non-lazy properties,classAlias=null,role=com.mercury.itg.pm.model.Task.taskInfo,tableName=wp_task_info,tableAlias=taskinfo8_,origin=wp_tasks task7_,columns={task7_.task_info_id,className=com.mercury.itg.pm.model.TaskInfo}}]
at org.hibernate.hql.internal.ast.tree.SelectClause.initializeExplicitSelectClause(SelectClause.java:230)
at org.hibernate.hql.internal.ast.HqlSqlWalker.useSelectClause(HqlSqlWalker.java:1039)
at org.hibernate.hql.internal.ast.HqlSqlWalker.processQuery(HqlSqlWalker.java:807)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:703)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:339)
at org.hibernate.hql.internal.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:287)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:276)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:192)
... 162 more