Profile Manager Profile Corruption Resolution

The Problem
I uploaded the com.apple.Safari.plist to profile manager.

Immediately after that – I was no longer able to load the device groups page and received;
”A Server Error Has Occurred” and to “Contact my system administrator if the problem persists”.

The Configuration Profile was corrupted.

There is a postgressql database that stores all the profiles.

You need to manually delete the profile for the device group

1. Open up Terminal.app

2. Command to list all of the tables (This is just an option to see the Table layout and not really necessary):

sudo psql -h "/Library/Server/ProfileManager/Config/var/PostgreSQL" -U _devicemgr -d devicemgr_v2m0 -c "\dt"

3. Command to list all profiles so you can find the corrupt one:

sudo psql -h "/Library/Server/ProfileManager/Config/var/PostgreSQL" -U _devicemgr -d devicemgr_v2m0 -c "select * from profiles"

4. Find the id of the profile that you believe to be the culprit and delete it with the following command (Look in the first column and replace the 15 in this example):

sudo psql -h "/Library/Server/ProfileManager/Config/var/PostgreSQL" -U _devicemgr -d devicemgr_v2m0 -c "delete from profiles where id=15"