Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.
up vote 0 down vote favorite

I've recently migrated from project 2003 to project 2010, via project 2007. I'm experiencing an issue where users with more than 180 new tasks assigned, experience "an unexpected error has occurred". It seems that a query which is used to display the list of project is taking very long to execute. The query seems to create some temp tables and inserts data into them before executing the query against the table before returning the results. The SharePoint error log has an error "... query timed out". When I extracted the query that produced the time out and executed it on the database server directly, it took over 2 hours to return the results.

I've installed SP1 for project server 2010, but the problem persists.

Things i'd like to try: - Increasing the performance of the sql server: if anyone know's how to speed up query executing where temp tables are involved, it would be of help.

  • Marking all tasks as old (instead of new): Is there some powershell script fragment that I can use to mark a task as old?

EDIT: I'm trying to resolve the "an unexpected error has occurred" message.

share|improve this question
Hey @kurtnelle. Sorry.. but questions specifically about Project Server are off topic. I'm not exactly sure where you would ask this question.. – Kit Menke♦ Sep 15 '11 at 18:33
Hi Kurtnelle, maybe you can try your luck at Server Fault (serverfault.com) or Super User (superuser.com) – Wilson Tan Sep 16 '11 at 7:39
Project server 2010 is a subset of SharePoint! How is it off topic? – kurtnelle Sep 16 '11 at 14:35
Yeah, I think up until now we decided not to include Project Server questions but we didn't really get much input. If you'd like, would you bring it up on Meta? I think you could post here: meta.sharepoint.stackexchange.com/questions/82/… – Kit Menke♦ Sep 16 '11 at 15:06
Humm, I see. Ok, I'll state my case in the discussion. – kurtnelle Sep 16 '11 at 16:32
show 1 more comment

closed as off topic by Kit Menke♦ Sep 15 '11 at 18:29

Questions on SharePoint Stack Exchange are expected to relate to SharePoint within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

Browse other questions tagged or ask your own question.