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.