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:
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:
- 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)
Comments
Post a Comment