Super Contributor.. patrick-sa Super Contributor..
Super Contributor..
239 views

PPM does not save workplan tasks

Jump to solution

Good day,

 

I'm unable to save tasks in the workplan.Once i make changes in the task status ,say from ready to in progress, the system fails to save with the error shown below.

 

Please advise if anyone has seen this before and how to fix it.

 

 

com.mercury.itg.exceptions.InfrastructureException: org.hibernate.HibernateException: null index column for collection: com.mercury.itg.pm.model.Task.children
GUID=98D28183-769C-A2AE-E67D-EE78DFD81B9C     
Generated Time=2017/04/21-11:58:40.135 SAST
    at com.mercury.itg.pm.persister.BaseTaskPersister.initCostEngineAndBaseLine(BaseTaskPersister.java:572)
    at com.mercury.itg.pm.persister.EditTaskBeanPersister.updateCost(EditTaskBeanPersister.java:548)
    at com.mercury.itg.pm.persister.EditTaskBeanPersister.updateCost(EditTaskBeanPersister.java:494)
    at com.mercury.itg.pm.persister.QuickEditTaskPersister.updateCost(QuickEditTaskPersister.java:129)
    at com.mercury.itg.pm.service.impl.MassApplyService$1.run(MassApplyService.java:452)
    at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:179)
    at com.mercury.itg.pm.service.impl.MassApplyService.updateCost(MassApplyService.java:455)
    at com.mercury.itg.pm.service.impl.MassApplyService.run(MassApplyService.java:426)
    at com.mercury.itg.pm.service.impl.WorkPlanServiceImpl$30.run(WorkPlanServiceImpl.java:1672)
    at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:179)
    at com.mercury.itg.pm.service.impl.WorkPlanServiceImpl.massApply(WorkPlanServiceImpl.java:1675)
    at com.mercury.itg.pm.workplan.web.EditTaskMassApplyAction.doExecute(EditTaskMassApplyAction.java:74)
    at com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:208)

 

Patrick.

0 Likes
1 Solution

Accepted Solutions
Micro Focus Expert
Micro Focus Expert

Re: PPM does not save workplan tasks

Jump to solution

Hi Patrick,

This is cause by a bug in Oracle:  'Bug 18430870 : ADAPTIVE PLAN AND LEFT JOIN GIVE WRONG RESULT'

There are two ways to fix that:

1) Deploy a patch or upgrade to an Oracle version without that bug. See this page for more info

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1526971.aspx

2) If Oracle upgrade is not an option, connect as SYS on the DB, and run
alter system set optimizer_adaptive_features=false;

and that's it. There may be some performance impact for doing that, but from my experience it's not quite noticeable with PPM. Of course we recommend to fix Oracle (option #1), but it's up to you.

 

Kind Regards,

Etienne.

 

0 Likes
3 Replies
Super Contributor.. patrick-sa Super Contributor..
Super Contributor..

Re: PPM does not save workplan tasks

Jump to solution

task error 1.JPG

0 Likes
Micro Focus Expert
Micro Focus Expert

Re: PPM does not save workplan tasks

Jump to solution

Hi Patrick,

This is cause by a bug in Oracle:  'Bug 18430870 : ADAPTIVE PLAN AND LEFT JOIN GIVE WRONG RESULT'

There are two ways to fix that:

1) Deploy a patch or upgrade to an Oracle version without that bug. See this page for more info

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec1526971.aspx

2) If Oracle upgrade is not an option, connect as SYS on the DB, and run
alter system set optimizer_adaptive_features=false;

and that's it. There may be some performance impact for doing that, but from my experience it's not quite noticeable with PPM. Of course we recommend to fix Oracle (option #1), but it's up to you.

 

Kind Regards,

Etienne.

 

0 Likes
Super Contributor.. patrick-sa Super Contributor..
Super Contributor..

Re: PPM does not save workplan tasks

Jump to solution

Thank Etienne,

 

We applied the patch below and this solved our problem.

 

Patch 18430870: ADAPTIVE PLAN FOR QUERY WITH IN-LIST AND LEFT JOIN GIVE WRONG RESULT

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.