This is going to be a short but extremely useful post about how to get your Audiences compiled if it gets stuck. If your audience compilation gets stuck it is really hard to get it going again. Restarting the User Profile Service won’t do it. Trying to start it via the Central Admin UI won’t do it. Short of recreating the User Profile Service you are going to have to dive into your SQL Server and run an ORGLE stored procedure called orgle_job_stop. For some serious and disturbing laughs look up orgle on the internet. Just be prepared for some disturbing images J
This stored procedure is found in the User Profile Service database (probably Profile DB) and you will need the partition ID (a GUID) which can be found in a lot of places but I simply open the UserProfileValue table and look at any record. Copy that value so you can run the stored procedure
Execute orgle_job_stop ‘0C37852B-34D0-418E-91C6-2AC25AF4BE5B’, NULL
The NULL is required. I hope you never have to run this, but if you do you will be very thankful. Once you have run this you can restart your audience compilation and it should finish in less time than it took to run this stored procedure.
#sharepoint #UserProfiles #Audiences