User Profile changes cannot be committed - Event 5188 (SharePoint Server 2010)

 

Applies to: SharePoint Server 2010

Alert Name:   User Profile changes cannot be committed

Event ID: 5188

Summary:   Users can edit properties in their own profiles, as allowed by the administrator. This event is logged when these changes made by the user (or by another process that has authority to update the profile) cannot be committed to the database.

Symptoms:   One or more of the following symptoms might appear:

  • Users get an error that their changes cannot be applied.

  • The following event appears in the event log: Event ID: 5188 Event Description: There was an error saving the user profile for user '<User ID>'. The exception was: <Exception>.

Cause:   One or more of the following might be the cause:

  • The database server is unreachable because of network connectivity issues.

  • The database server is not responding because network connections are overloaded, or memory — and, hence, the commit request — is encountering a time out.

  • The database server is down because of additional issues with the server, such as disk failure.

Resolution:   Verify that the database server is running and available

  1. On the database server, in the Services snap-in, verify that the SQL Server (MSSQLSERVER) service is running.

Resolution:   Verify connectivity between the database server and the farm

  1. Log on to Microsoft SQL Server Management Studio as the account provided in the error details, click Connect, and then click Database Engine.

  2. Type the server name provided in the error details, and then click Connect.

Resolution:   Verify that the database server is not low on resources

  1. On the database server, verify that the server has sufficient RAM memory and disk space.