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 | Comments Off on Unknown error when saving #ProjectServer Security Group #PS2010 #MSProject #SP2010 #EPM
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

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

%d bloggers like this: