question

MARCELBALCAREK-7675 avatar image
0 Votes"
MARCELBALCAREK-7675 asked ElsieLu-MSFT commented

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

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.



















office-sharepoint-server-administration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BalcarekMarcel-1863 avatar image
0 Votes"
BalcarekMarcel-1863 answered ElsieLu-MSFT commented

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://docs.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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Glad to hear that and thanks for sharing! :)

0 Votes 0 ·
ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered

Hi @MARCELBALCAREK-7675 ,

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?
118639-51.jpg

118681-52.jpg

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.


51.jpg (10.4 KiB)
52.jpg (12.4 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MARCELBALCAREK-7675 avatar image
0 Votes"
MARCELBALCAREK-7675 answered MARCELBALCAREK-7675 edited

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.