Share via


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:

Cheers!

Bala