Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Timesheet web part: unexpected error has occured RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi All,

    We have a Project Server 2007 SP2 Dec 09 env.

    Few user from my team are not able to create, update their time sheet for a specific periods only. They are getting below error:

    An unexpected error has occurred. Web Parts Maintenance Page; If you have permission you can use this page to temporarily close this web part etc.

    Troubleshoot issues with windows share point services.

    For the same I have gone through with following Brian smith blog.

    http://blogs.msdn.com/b/brismith/archive/2007/03/23/an-unexpected-error-has-occurred-or-unknown-error-in-wss-3-0.aspx?PageIndex=2#comments.

    It says : if timesheets are the problem removing some added task lines might help

    So my first question is that how can I delete the added task lines for the timesheets which I am not able to open or access.

    And is there any hotfix available for this specific issue and other resolutions so that I can proceed further.

    Thanks All

    Sachin Vashishth MCTS
    Wednesday, April 13, 2011 7:43 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Sachin:

    If you have a good idea of which tasks are causing the problem, try going to the Project in question, setting the task level value for the publish field to No. Publish the project. Then set the value back to yes and publish again. Many times this will clear the problem. Otherwise, try navigating to the manage timeheets page and delete the timesheet in question.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Wednesday, April 13, 2011 1:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Gary,

    Thanks for your reply, I have used below query to fetch corrupted tasks.

    USE [ProjectServer_Published]
    SELECT MSP_PROJECTS.PROJ_NAME,
    MSP_ASSIGNMENTS_SAVED.TASK_NAME,
    MSP_RESOURCES.RES_NAME,
    MSP_ASSIGNMENTS_SAVED.ASSN_UID,
    MSP_ASSIGNMENTS_SAVED.PROJ_UID,
    MSP_ASSIGNMENTS_SAVED.TASK_UID,
    MSP_ASSIGNMENTS_SAVED.RES_UID
    FROM MSP_ASSIGNMENTS_SAVED INNER JOIN
    MSP_PROJECTS ON MSP_ASSIGNMENTS_SAVED.PROJ_UID =
    MSP_PROJECTS.PROJ_UID INNER JOIN
    MSP_RESOURCES ON MSP_ASSIGNMENTS_SAVED.RES_UID =
    MSP_RESOURCES.RES_UID
    WHERE (NOT EXISTS
    (SELECT TASK_UID
    FROM MSP_TASKS_SAVED
    WHERE (TASK_UID = MSP_ASSIGNMENTS_SAVED.TASK_UID)))  

    But the tasks which I get after running this script, they are not added or belong to those timesheets.

    Note: But I have found 
    some tasks does not even have task name (means blank or null in RDB) 
    but time entry is there for those tasks in actual work billable column

    So here my question is that, whether those tasks(which have empty task name)
    in timesheet can cause corruption?

    If yes then how can I delete those tasks, pls let me know.
    Sachin Vashishth MCTS



    Thursday, April 21, 2011 11:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    One more thing I found for the task name which are empty, resources are billing hours against Project Name only and Billing Classification(i.e Timesheet Line Classification) without a task name selection.

    So pls tell me can this particular behavior cause corruption.

    Sachin Vashishth MCTS
    Thursday, April 21, 2011 2:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Sachin:

    The system does not tolerate blank task names. Blank summary task names cause major problems.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Thursday, April 21, 2011 3:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Gary,

    As I said rather than doing time entry against additional task(using add line feature) some resources are doing time entry against project name(means they are selecting project name instead of task name), thats why taskname is blank.

    So just let me know adding project instead of task in timesheet can cause this issue? So that I can close this thread with a better understanding about this issue.

     

    Sachin Vashishth MCTS
    Thursday, April 21, 2011 3:35 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    It shouldn't. The system is designed to support this.
    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Friday, April 22, 2011 1:44 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks a ton Gary for all your valueable responses.

    As you said in your fisrt reply: To look for some corrupted tasks and then set "publish = no"  to those tasks.

    So as i said above, i have found 2-3 corrupted tasks  but hardluck none of those belongs to that timesheets.

    And that timesheet does not even have a additional task which does not belong to that timesheet period.

    So kindly let me know from your vast experience in PS, if you know any other reason for this particular behavior.

    So that I can start workin in that direction, please help me.

    Sachin Vashishth MCTS
    Saturday, April 23, 2011 11:39 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Sachin:

    There are probably a number of user behaviors that can cause this, however I do not have a catalog of these. I expect some improvements in this area with SP1, so get that installed as soon as it becomes available.

    Gary Chefetz, MCITP, MCP, MVP msProjectExperts
    Project and Project ServerFAQs
    Project Server Help BLOG
    Monday, April 25, 2011 1:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks Gary,

    I already have PS 2007 SP2 installed with DEC'09 CU applied on it.

    However I am looking for some other reasons, meanwhile if you find something helpful pls let me know.

    Thanks once again.

    Sachin Vashishth MCTS
    Monday, April 25, 2011 1:51 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    If you are still experiencing issues I would contact Microsoft Premier support to get assistance.
    Blog | Facebook | Twitter | Posting is provided "AS IS" with no warranties, and confers no rights.
    Project Server TechCenter | Project Developer Center | Project Server Help | Project Product Page
    Tuesday, April 26, 2011 1:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sachin,

     

    Is your issue resolved ??

    I am facing the same, Let me know resolutions if any.,

     

    Thanks,

    Parag

     

    Thursday, August 4, 2011 10:39 AM