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’ : https://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:
- Rename users or change user domains
- Exclude users whose accounts have been disabled
- Remove obsolete users and groups
- Maintain profile schema changes
- Rename a profile synchronization server
- Move the User Profile Synchronization service to a new server
- Reset profile synchronization
- Restrict profile synchronization communication to a specific domain controller
- Adjust profile synchronization time-outs
- Grant Active Directory Domain Services permissions for profile synchronization (SharePoint Server 2010)
Cheers!
Bala