SharePoint 2013 - ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.ServiceModel.ProtocolException

Question

Trying to start User Profile Synchronization Service from Central Admin, but get these errors:

Exception occured while connecting to WCF endpoint: System.ServiceModel.ProtocolException: The content type text/html; charset=utf-8 of the response message does not match the content type of the binding (application/soap+msbin1).

UserProfile.RetrieveUser() Exception: Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.ServiceMode. ProtocolException

Exception in ActivityManager.EnsureUserInfo(): Account Name : our farm account, Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.ServiceModel.ProtocolException

UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Configuration.ConfigurationErrorsException: ERR_CONFIG_DB

I have checked the DB permissions for the farm account, and it has owner permissions on the SP_UserProfileSync_Service_DB. I have searched, but don't understand what could cause a protocol exception.

Thanks for any help.

Answer 1

My issue turned out to be related to us hardening our servers and requiring TLS 1.2 on our SharePoint servers. I followed the steps in https://learn.microsoft.com/en-us/sharepoint/security-for-sharepoint-server/enable-tls-and-ssl-support-in-sharepoint-2013.

Please note that step 1.4 - Install SQL Server 2008 R2 Native Client update for TLS 1.2 support is required even if you are on a newer version of SQL Server, such as SQL Server 2012 in our case.

you will see error in ULS logs: UserProfileApplication.SynchronizeMIIS: Failed to configure MIIS post database, will attempt during next rerun. Exception: System.Configuration.ConfigurationErrorsException: ERR_CONFIG_DB

helpful was: https://github.com/microsoft/tigertoolbox/blob/master/tls1.2/CheckClientUpdates.ps1 and https://www.microsoft.com/en-us/download/details.aspx?id=57606 where I had to try every file because they are not documented well, eventually one worked. No reboot is required.

Answer 2

Hi Elsie,
Thank you for your response. The User Profile Service starts, but the User Profile Sync Service does not start because of the issue. The article you suggested did not resolve the issue either.

None of the suggestions in https://vschamarti.wordpress.com/2019/11/15/err_config_db-while-starting-the-upa-synchronization-service-in-sharepoint-2010-2013/ worked either. I am still working on it.

Answer 3

Hi @MARCEL BALCAREK ,

You could check whether your User Profile service starts normally, and check whether FIM starts normally with the correct account in the service. In addition, what version is the database?

Here is a blog you could have a look:
Resolved - Failed to configure MIIS post database
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.