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

Error while entering to an existing timesheet

Highlighted
sevcan
Collector

Error while entering to an existing timesheet

Hey,

 

Timesheet started to throw error like following,

 

and the errors in the server log like following

 

  at com.mercury.itg.common.web.ITGExceptionHandler.execute(ITGExceptionHandler.java:126)
at com.mercury.itg.common.web.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:54)
at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:87)
at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:97)
at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:115)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:178)
at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:104)
at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:81)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:904)
at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1462)
at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:46)
at com.kintana.core.web.filter.SchemeBasedRedirectFilter.doFilter(SchemeBasedRedirectFilter.java:64)
at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:56)
at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:68)
Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0
at com.mercury.itg.tm.web.TMWebUtil.getTotalListFromActuals(TMWebUtil.java:164)
at com.mercury.itg.tm.web.TMWebUtil.addToFlatList(TMWebUtil.java:118)
at com.mercury.itg.tm.web.TMWebUtil.getWorkItemFlatList(TMWebUtil.java:83)
at com.mercury.itg.tm.web.EditTimeSheetAction$1.run(EditTimeSheetAction.java:343)
at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:179)
at com.mercury.itg.tm.web.EditTimeSheetAction.doExecute(EditTimeSheetAction.java:498)
at com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:206)

 

Do you have any idea what casued this and how can we fix this?

 

Sev

2 REPLIES
beccak
Acclaimed Contributor

Re: Error while entering to an existing timesheet

I have the same situation going on and no one can tell me how to get the timesheet for this week deleted. 

dirkf
Honored Contributor

Re: Error while entering to an existing timesheet

Hi all,

 

it would be great if you were able to be more specific...

 

When doing what with the timesheet: Trying to open, add  a line, save? What status is the timesheet in?

How many timesheets are affected?

 

There are a couple of issues that could affect this. Most likely, you may have broken time sheet lines and for the most times, you see this on frozen or cancelled timesheets. Check for instance your table 'tm_actuals_effort'

 

To locate correct timesheet lines you can for instance use the following query:

 

select distinct tsl.time_sheet_line_id

from tm_time_sheet_lines tsl,tm_actuals ta

where tsl.time_sheet_line_id=ta.time_sheet_line_id

and ta.actuals_id not in (

select

tae.actuals_id from

tm_actuals_effort tae

)

 

Be aware though that I highly advise creating tickets for this issue, as we may have to delete rows from some tables and I would more like to thoroughly investigate that. I'M just providing the query to give you starters.

 

HOpe this helps you.

Best regards,

dirk

 

//Add this to "OnDomLoad" event