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

Error while editing timesheet

SOLVED
Go to solution
Highlighted
sevcan
Collector

Error while editing timesheet

Hello All,

 

One of the user gets an error when he tries to edit the Lİne details to add a new activity for a Misc. item he added before.  But when he click save. It pops up the below error.

 

  An unknown exception has occurred. Please reload the page you were editing and try again.   The following is a stack trace of the exception:
com.kintana.core.server.RuntimeBaseException:

An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=6934ABD2-4778-E018-C60D-8B564F821F25

It is a very generic error I know. But Do you have any idea of the problem? Other users enter timesheet without problem. It is just this user.

I also attach the server log part that is related with this error. 

 

 

 

Thank you,

 

 

8 REPLIES
dirkf
Honored Contributor
Solution

Re: Error while editing timesheet

Hi Sevcan,

 

1) get the user_id of the user having the problem.

2) Run the following:

 

select ORG_UNIT_ID from krsc_org_unit_members where user_id=(select user_id from knta_users where username='affected_user');

 

If there is more than one org unit id returned, do the following:

 

Assume that the query returns more than one.

Assume as per example we get back 2 records - 101731 and 101732.


One unit will be a valid one, the other possibly (verify) not - does it exist in table "krsc_org_units"? I presume this is the valid record for that user.

If you CAN verify that one OrgUnit is valid, the other is NOT, do the following (else if not sure - LOG A CASE)

1. Please make a backup of table krsc_org_unit_members and delete the record with ID <not_valid_id> via a "delete" sql statement.

 

Let me know if it worked or if you have questions.

 

Best regards,

Dirk

 

- Kudos always welcome -

sevcan
Collector

Re: Error while editing timesheet

Thank you Dirk.

 

That was the solution :)

 

thePITman
Super Collector

Re: Error while editing timesheet

Dirk,

I have the same exact error as the original poster, but the user in question has only 1 org_unit_id listed. What else might cause this error? The user submitted 4 time sheets; 2 worked, and 2 failed.

 

I searched the stack trace error on the forum, and this thread was the only one relating to time sheets. Can you please let me know any other steps I should take to troubleshoot? Or should I begin a new thread for the same error?

dirkf
Honored Contributor

Re: Error while editing timesheet

Hi PITMan,

 

assuming for the minute that it might be the same issue, please have the user reproduce the issue and provide the serverlog that contains the GUID-exception in full length. Best would be to make sure you can find the GUID exception in the log and then sending the whole log-file.

I guess that the four timesheets weren't created all at the same time. Is it known what happened between creating the first two and the other two? I also assume that the user was creating and submitting the timesheet for him- / herself and was not doing that on behalf of a delegation?

 

Best regards,

Dirk

thePITman
Super Collector

Re: Error while editing timesheet

Thank you for the prompt response. The user is submitting the time sheet on his own behalf. However, I learned today that others are having the same issue submitting time sheets. We are still looking into what might be causing it. In the mean time, here is the server log after the user re-tried a few minutes ago.

 

STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.955 EDT: An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=590EA31C-3883-222B-EC48-0CC4067F8E3C
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.955 EDT: nested detail:null
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.956 EDT:


STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.956 EDT: An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=590EA31C-3883-222B-EC48-0CC4067F8E3C
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.956 EDT:  at com.mercury.itg.common.web.ITGExceptionHandler.execute(ITGExceptionHandler.java:125)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.956 EDT:  at com.mercury.itg.common.web.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:53)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.956 EDT:  at com.mercury.itg.servlet.ActionMonitorFilter.doFilter(ActionMonitorFilter.java:84)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.957 EDT:  at com.mercury.itg.servlet.HibernateSessionFilter.doFilter(HibernateSessionFilter.java:88)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.957 EDT:  at com.kintana.core.web.filter.MLUFilter.applyFilter(MLUFilter.java:111)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.957 EDT:  at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.957 EDT:  at com.kintana.core.web.filter.stinger.ValidationFilter.applyFilter(ValidationFilter.java:145)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.957 EDT:  at com.kintana.core.web.filter.stinger.ValidationFilter.doFilter(ValidationFilter.java:80)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.957 EDT:  at com.kintana.core.web.filter.MultipartRequestFilter.applyFilter(MultipartRequestFilter.java:81)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.958 EDT:  at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.958 EDT:  at com.kintana.core.web.filter.ControlFilter.applyFilter(ControlFilter.java:878)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.958 EDT:  at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:1397)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.958 EDT:  at com.mercury.itg.servlet.I18NFilter.doFilter(I18NFilter.java:40)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.958 EDT:  at com.kintana.core.web.filter.Log4jFilter.applyFilter(Log4jFilter.java:51)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT:  at com.kintana.core.web.filter.BaseFilter.doFilter(BaseFilter.java:59)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT: Caused by: java.lang.NullPointerException
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT:  at com.mercury.itg.tm.impl.TaskWorkItemProviderImpl.isApprovalRequiredByProject(TaskWorkItemProviderImpl.java:129)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT:  at com.mercury.itg.tm.impl.TimeSheetLineImpl.submit(TimeSheetLineImpl.java:495)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT:  at com.mercury.itg.tm.impl.TimeSheetLineImpl.doActionInternal(TimeSheetLineImpl.java:417)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT:  at com.mercury.itg.tm.impl.TimeSheetImpl.doActionLines(TimeSheetImpl.java:489)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.960 EDT:  at com.mercury.itg.tm.impl.TimeSheetImpl.submit(TimeSheetImpl.java:567)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.960 EDT:  at com.mercury.itg.tm.impl.TimeSheetImpl.doAction(TimeSheetImpl.java:416)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.960 EDT:  at com.mercury.itg.tm.service.impl.TMServiceImpl.updateTSState(TMServiceImpl.java:741)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.960 EDT:  at com.mercury.itg.tm.service.impl.TMServiceImpl.submitTimeSheet(TMServiceImpl.java:549)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.960 EDT:  at com.mercury.itg.tm.web.ReleaseTimeSheetAction$3.run(ReleaseTimeSheetAction.java:218)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.960 EDT:  at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:200)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.961 EDT:  at com.mercury.itg.tm.web.ReleaseTimeSheetAction.submitTimeSheet(ReleaseTimeSheetAction.java:223)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.961 EDT:  at com.mercury.itg.tm.web.ReleaseTimeSheetAction$1.run(ReleaseTimeSheetAction.java:76)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.961 EDT:  at com.mercury.itg.util.HibernateTemplate.doRun(HibernateTemplate.java:200)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.961 EDT:  at com.mercury.itg.tm.web.ReleaseTimeSheetAction.doExecute(ReleaseTimeSheetAction.java:121)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.961 EDT:  at com.mercury.itg.common.web.BaseAction.execute(BaseAction.java:169)
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.961 EDT:  ... 14 more
STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.962 EDT:
 Filtered Out 95 Stack Trace Lines.

 

thePITman
Super Collector

Re: Error while editing timesheet

We may have found the issue, but not totally sure yet. It appears something may have happened regarding an employee being on the staffing profile and/or project plan, assigned to a task, and then either the person was removed from the staffing profile or the task was removed, or something. The details we don't know, yet. But I'm attaching a screen shot that shows some lines on the time sheet that have clearly been "nulled" out or "deleted" but still appear. If we remove those lines and re-submit the time sheet, it succeeds. (Well, I made myself a delegate for someone and successfully submitted it. Tomorrow the actual users will test removing lines and making sure it still works.)

 

If this is indeed the issue, we'll need to test and play around in a DEV environment to see how exactly those lines become null/deleted, and how we can train project managers to keep it from happening in the future.

dirkf
Honored Contributor

Re: Error while editing timesheet

Hi PITman,

Good to know that you’ve found the issue seemingly. I cannot see what is happening from the logs – an error such as above is not being logged at this time. The only thing I can see is a problem with approving a timesheet, it appears, as we can see here:

STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT: Caused by: java.lang.NullPointerException

STATUS JSESSIONID=632D57DA670FDECF55E42942F24ED21E.PPMPROD,USERNAME=[USER] server:http-0.0.0.0-8080-Processor12:SystemErr:2013/09/04-11:08:56.959 EDT:  at com.mercury.itg.tm.impl.TaskWorkItemProviderImpl.isApprovalRequiredByProject(TaskWorkItemProviderImpl.java:129)

 

The screenshot actually indicates that the tasks that the user was working on as well as the project have been deleted.

Should you still be in doubt or this error occur again on another timesheet, I suggest trying to edit it to get the runtime base exception to the logs and we’ll see from there.

 

Best regards,

Dirk

thePITman
Super Collector

Re: Error while editing timesheet

We are very new and still in the training/implementation phases of using Time Management and Project Management. After thorougly testing this morning we have some new learnings (although they may be common knowledge to more experienced users):

 

  • Whether or not a person is on a Staffing Profile has NO effect on time reporting.
  • A person can only report time to a project if he/she is assigned to a particular task in the Project Plan.
  • If a person is assigned to a task and then creates a time sheet, that task is automatically added to the time sheet. At this point, that task can NOT be deleted, even if the time sheet containing the task has not yet been submitted.
  • The error occurs when a person is assigned to a task, creates a time sheet, and then the whole project is deleted. The tasks then become orphans, the project line shows "null" and the task line shows "-deleted-".

Again, I'm sorry if these are all common knowledge, but we are very new to this. We are actually training our department on 9/9. I do want to stress, though, that we received the same error as the person who started this thread, but for a different reason.

 

Thank you for your help!

//Add this to "OnDomLoad" event