Unknown error when saving #ProjectServer Security Group #PS2010 #MSProject #SP2010 #EPM

December 22, 2011 at 5:39 pm | Posted in Administration, Configuration, Customisation, Issue, T-SQL | Leave a comment
Tags: , , ,

I came across this issue on my test instance a while back and never bothered to investigate it or fix it, when trying to save the security group the following error was returned:

The group could not be saved due to the following reason(s):

  • An unknown error has occurred.
  • An unknown error has occurred.

image

After some digging around I remember I did some testing with adding custom permissions, 2 in fact which coincided with the number of unknown errors. The Administrators group did originally have both of these custom permissions enabled. After looking down the list of Global permissions I couldn’t see the two custom permissions so I checked the Published database. Luckily I had the SQL queries saved from when I created the two custom permissions so I knew what Name ID to check for in the database tables. The two custom permissions existed in the MSP_WEB_SECURITY_FEATURES_ACTIONS table but not in the MSP_WEB_CONVERSIONS table as seen below:

image

As I thought, my two custom permission names had been removed from the web conversions table, almost certainly after applying an update for Project Server. The fix is quite simple, just add the custom permission names back into the MSP_WEB_CONVERSTIONS table, my example can be seen below:

image

The security group can now be saved without any errors.

Worth noting if you use custom permissions on your Project Server environment, hopefully that will help anyone seeing this issue. Smile

Advertisements

Leave a Comment »

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: