none
An Unknown Error Has Occurred - Project Server 2010 - Tasks Page

    Question

  • Greetings!   Some of my resources are recieving the error "An Unknown Error has occurred" (in red)  when trying to access their TASKS Page in Project Server 2010.  

    I've researched this error quite a bit and am finding suggestions and answers pretty much all over the board.    Before I have my server people start installing a slew of hot fixes - I want to know if anyone has an idea of the underlying cause for this error.    Since this issue doesn't affect everyone (i.e. I can access my task page), is it possibly related to the actual schedule in which they have assignments?    

    Any help is appreciated.

    Thanks!

    ~Randy 

    Friday, July 06, 2012 6:53 PM

Answers

All replies

  • Hi Randy,

    "An Unknown Error has occurred" is a generic error message.

    Could you please check ULS log?

    All resources experiencing this error all part of same project plan?

    What is the current SP\CU version installed on Server?


    Hrishi Deshpande – Senior Consultant DeltaBahn
    Blog | < | LinkedIn

    Friday, July 06, 2012 8:17 PM
    Moderator
  • Hi Randy,

    As Hrishi said, I would check the ULS logs for the underlying cause. It could be data related, database performance related etc.

    Have you set up the Project Server databae maintenance plans? http://technet.microsoft.com/en-us/library/cc973097.aspx

    I have seen this issue before, in my case it was related to the database indexes / statistics not being updated and you could see a SQL timeout in the ULS logs. Might be worth running the following SQL against the Project Server PWA databases and retesting:

    EXEC SP_updatestats

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Saturday, July 07, 2012 9:13 AM
    Moderator
  • Hi Randy,

    this article is probably about same issue http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/71c3afa0-f1a1-4768-9ba5-ebcd712f4f02

    I had same problem but with only one resource.

    Tomas

    Saturday, July 07, 2012 7:03 PM
  • i have found the solution for this issue, you need to do this:


    in the logs you must search the "exception" and the logs give you a ID, this ID is about the task assignment in the specific resource , so this assignment is corrupt.

    this ID, you need to merge in the SQL server in the project server database, you need to merge ID task with ID Project with ID Resource, so when you identify the ID project and ID resource you can DELETE this assignment in the project from project profesional, because this task has a corrupt assignment, you must delete ONLY FROM project professional.

    This solutión solve this specific problem for this assignment  that IS DIFERENT TO THIS SOLUTION  post of Brian Smith:

    http://blogs.msdn.com/b/brismith/archive/2010/07/02/project-server-2010-an-unknown-error-has-occurred-in-project-center-resource-center-or-tasks.aspx?Redirected=true


    Erick Gutiérrez PMI Membership #ID 2089740 MTCS - Microsoft Project Server Managing Projects



    Monday, April 28, 2014 4:11 PM