|
|
Find Me
Recently Written
- SharePoint Saturday Columbus Slide Deck Posted
- Speaking at SharePoint Saturday Columbus
- June Microsoft Patch May Break SharePoint
- Wordpress Update Will Mess You Up
- Using the SharePoint 2010 Dialog Platform with Forms Services
- SharePoint Saturday Kansas City Slides
- How to Display RSS Feeds in Windows SharePoint Services (WSS)
- Gmail Knows Me Better Than I Know Myself
- Two Helpful Web Parts for FREE!!!
- The Software You Need – AXIGEN Mail Server
Categories
Archives
Blogroll
Admin
Feb
5
Project Server Errors on User Edit Screen
Filed Under General
At a client recently, I noticed that their Project Server implementation is having some issues with the edit user page throwing errors for certain users. I will try to get a screenshot later and marry it up with this post.
After some research, we were able to determine that one of the Project Server databases had those users checked out to a fictitious users (0000-000000-0000), instead of one of the two normal values, NULL or an actual GUID representing the user that had that record checked out.
We are currently working on a long-term fix, but the quickest way we found to fix the problem immediately was running a simple SQL Query against the Project Server_Production database.
Go to the MSP_RESOURCES table and then run the following SQL:
UPDATE MSP_RESOURCES
SET RES_CHECKOUTBY = NULL
WHERE RES_CHECKOUTBY IS NOT NULL
Once I have an update on how to fix this long-term, I will repost...