User Profile Application ‘Unable to process Create message’

Issue:

Unable to add user properties for user profile connection. Getting Unable to process Create message error in the event log and ULS logs.

Error’s in the event log and ULS Logs:

OWSTIMER.EXE (0x075C)            0x0DD4 SharePoint Portal Server User Profiles      9q17     High            UserProfileApplication.SynchronizeMIIS: Failed to configure ILM MA, will attempt during next rerun. Exception: Microsoft.ResourceManagement.WebServices.Faults.ServiceFaultException: Unable to process Put message     at Microsoft.ResourceManagement.WebServices.Client.Resource.Update()     at Microsoft.ResourceManagement.WebServices.ResourceManager.UpdateResource()     at Microsoft.Office.Server.UserProfiles.Synchronization.ILMMAConfiguration.
UpdateSQLConnectionInformation(String server, String databaseName, String user, String domain, SecureString password)     at Microsoft.Office.Server.UserProfiles.UserProfileConfigManager.UpdateILMMA(String databaseServerIlm, String databaseInstanceIlm, String databaseName, String domain, String userName, SecureString password)     at Microsoft.Office.Server.Administration.UserProfileApplication.
SetupSynchronizationService(ProfileSynchronizationServiceInstance profileSyncInstance).       5bb66e24-5242-46d7-9b84-2bb2ff09fdbc

Event ID 3

Description:

.Net SqlClient Data Provider: 266 : UpdateRequestStatusForCompletedActionWorkflows : System.Data.SqlClient.SqlException: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.

Uncommittable transaction is detected at the end of the batch. The transaction is rolled back.

   at Microsoft.ResourceManagement.Utilities.ExceptionManager.ThrowException(Exception exception)

   at Microsoft.ResourceManagement.Data.Exception.DataAccessExceptionManager.

ThrowException(SqlException innerException)

   at Microsoft.ResourceManagement.Data.DataAccess.

UpdateRequestStatusForCompletedActionWorkflows(Int16 maxRequestsToProcess)

   at Microsoft.ResourceManagement.Workflow.PostProcessingManager.Execute()


Event ID 3

Description:

System.Data.DataException: This request has an invalid target: 317C9770-288F-4E63-AD78-BE77B01C3E5D. The invalid target identifier is DE46502C-35B4-4FE7-80A9-07F3F2EA5614.


Steps taken to troubleshoot the issue:

Please note: Before following the steps please take a backup of your Profile and Sync DB.
* Followed the TechNet article to Reset profile synchronization’: http://technet.microsoft.com/en-us/library/ff681014.aspx
* Rebooted the APP sever after the reset and added the Farm account on Sync DB as dbo owner ( Per TechNet article) on SQL server.
* Started the profile synchronization service on APP server.
* Made sure the profile service started successfully without any errors.
* Checked the User profile application and found that the profiles connection got removed automatically (Expected behaviour after the Reset Sync Instance).
* Created a new profile connection successfully without any error (Unable to process Create message )
* After that I am able to edit/modify/update the profile connection without any error J

Additional Information:

Comments

Popular posts from this blog

"There's a configuration problem preventing us from getting your document. If possible, try opening this document in Microsoft Word." Office WebApp Error

"We’re sorry. We ran into a problem completing your request. Please try that again in few minutes." Excel Service SharePoint

Deployment error "The web.config is invalid on this IIS Web Site"