Wednesday, 25 July 2007

Profile import works but get Error 7888 in the event log

Everytime a profile import is run (full or incremental), everything seems to go through successfully, but there is the following error in the event logs:

Event Type: Error
Event Source: Office SharePoint Server
Event Category: Office Server General
Event ID: 7888
Date: 24/07/2007
Time: 22:00:34
User: N/A
Computer: EP-SP-INDEX01
Description:
A runtime exception was detected. Details follow. Message: Access Denied! Only site admin can access Data Source object from user profile DB.

Techinal Details: System.UnauthorizedAccessException: Access Denied! Only site admin can access Data Source object from user profile DB. at Microsoft.Office.Server.UserProfiles.SRPSite.AdminCheck(String message) at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(IDataRecord rec) at Microsoft.Office.Server.UserProfiles.DataSource._LoadDataSourceDef(String strDSName) at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site, Boolean fAllowEveryoneRead) at Microsoft.Office.Server.UserProfiles.DataSource..ctor(SRPSite site) at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.GetDataSource() at Microsoft.Office.Server.UserProfiles.BDCConnector.RefreshConfiguration(String sspName)

I resolved this by doing the following:
- Go into the Shared Services administration page.
- Click 'Personalization Services Permissions'.
- Add the search service account (in my case this was DOMAIN\sp_search_svc) and give the account 'Manage User Profiles' permissions.

1 comment: