Project and Portfolio Management Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Error on Resource Usage view in Work Plan

Highlighted
Cat_2
Regular Collector

Error on Resource Usage view in Work Plan

I was looking at the Resource Usage view (within the work plan actions menu for version 8.01) and I modified the filters for a new date range. In the background it threw a OutOfIndex exception and now the Resource Usage view won't come up for that project. Error message is below. Has anyone seen this before? I'm assuming it was just too much data as the project has a very large staffing profile. Is there a way to reset it without restarting the app?

 

Exception Correlation: GUID=A1ADB3C8-829F-348A-D8EC-0FE3DBA64F31

Generated Time=2011/04/04-13:15:43.265 CDT

Server Node Name: HPPPM_Prod

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT: nested detail:String index out of range: 1808

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:

 

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT: An HP internal error has occurred. Please contact HP Project and Portfolio Management support if the problem persists. (KNTA-10023)

 

Exception Correlation: GUID=A1ADB3C8-829F-348A-D8EC-0FE3DBA64F31

Generated Time=2011/04/04-13:15:43.265 CDT

Server Node Name: HPPPM_Prod

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.common.web.ITGExceptionHandler.execute(ITGExceptionHandler.java:123)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.common.web.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:53)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:82)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:79)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:110)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:93)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:66)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:85)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:822)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1307)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:40)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:49)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT: Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: 1808

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.pm.dao.NodeDAO.getWPResourceLoadByFilterCriteria(NodeDAO.java:402)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.rm.rsc.ResourceUtilizationHelper.getWorkplanLoadInternal(ResourceUtilizationHelper.java:404)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.rm.rsc.ResourceUtilizationHelper.getWorkplanLoadInternal(ResourceUtilizationHelper.java:259)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.rm.rsc.ResourceUtilizationHelper.getWorkplanLoad(ResourceUtilizationHelper.java:130)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.rm.rsc.ResourceUtilizationHelper.getWorkplanLoad(ResourceUtilizationHelper.java:126)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.pm.loader.ResourceUsageLoader.getResourcesLoadAndCapacity(ResourceUsageLoader.java:164)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.pm.service.impl.WorkPlanServiceImpl$13.run(WorkPlanServiceImpl.java:763)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:200)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.pm.service.impl.WorkPlanServiceImpl.getResourcesLoadAndCapacity(WorkPlanServiceImpl.java:766)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.pm.workplan.web.ViewResourceUsageAction.doExecute(ViewResourceUsageAction.java:92)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    at com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:162)

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:    ... 14 more

JSESSIONID=7F76E28FC2A56E424B5A2ABE1B9637AE.HPPPM_Prod,USERNAME=sbau server:http-0.0.0.0-8080-Processor20:SystemErr:2011/04/04-13:15:43.265 CDT:

                Filtered Out 101 Stack Trace Lines.

1 REPLY
dirkf
Honored Contributor

Re: Error on Resource Usage view in Work Plan

Hi Cat,

 

there is a defect raised for a similar problem: 'Compare to Workplan' throws an exception when the project associated with the affected Staffing profile has more than 1.000 timesheet lines. While the visible errors are different, the stack trace is identical to the dot.  Thus, this could be a possible relation to Defect QCCR1L39510 http://support.openview.hp.com/selfsolve/document/FID/DOCUMENTUM_QCCR1L39510

 

Another issue could be that with a Staffing Profile which is very large it has a long finish date. You might want to check if the expected finish date of the Staffing Profile exceeds the expected finish date of the project - this will also lead to errors.

 

I would open a support case and do the following to provide data when you open it (add your actions to the description of the case so the support knows what you are providing data for:

- reproduce the problem once more;

- collect kSupport-Output:

- if you see a front-end error, provide a snapshot;

- collect and provide output for the following queries:

 

select * from rsc_staffing_profiles sp where sp.staffing_profile_id=<sp_id>;

select c.* from itg_calendar ic, itg_components c where c.CALENDAR_ID=ic.CALENDAR_ID
order by c.CALENDAR_ID,c.COMPONENT_TYPE_CODE, c.GROUP_NAME,c.COMPONENT_SEQ;

 

Hope this helps at least a bit.

Best regards,

Dirk

//Add this to "OnDomLoad" event