Error querying user profile

  • 26 April 2018
  • 2 replies
  • 26 views

Badge +6

I am seeing this in most of our workflows that have the Query User Profile action

Error querying user profile. UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.TimeoutException

After this error the WF fails. 

For the workflows that progress past the Query User Profile action, it looks like the action is never evaluated. We use this action to determine the next approver in the approval hierarchy and since its not working we have approvals going as far as the CEO.


2 replies

Badge +6

I saw the following in the ULS logs

UserProfile.RetrieveUser() Exception: Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.TimeoutException
at Microsoft.Office.Server.UserProfiles.ProfileDBCacheServiceClient.GetUserData(UserSearchCriteria searchCriteria)
at Microsoft.Office.Server.UserProfiles.UserProfileCache.GetUserData(UserProfileManager objManager, Nullable`1 recordId, Guid gAcct, String strAcct, Byte[] bSid, String strEmail, Boolean doNotResolveToMasterAccount)

UserProfile.RetrieveUser() Exception: Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.TimeoutException
at Microsoft.Office.Server.UserProfiles.ProfileDBCacheServiceClient.GetUserData(UserSearchCriteria searchCriteria)
at Microsoft.Office.Server.UserProfiles.UserProfileCache.GetUserData(UserProfileManager objManager, Nullable`1 recordId, Guid gAcct, String strAcct, Byte[] bSid, String strEmail, Boolean doNotResolveToMasterAccount)

(http://mysite/_layouts/15/NintexWorkflow/preview.aspx?ListId=b022ae85-3a46-4864-8353-8a5b86f4dbd5&ItemId=5465&InstanceId=028bcbce-2d1e-40b7-80d4-16f5a45879a3): Nintex.Workflow.NWActionExecutionException: Error querying user profile. ---> Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.TimeoutException
at Nintex.Workflow.Activities.QueryUserProfileStoreActivity.Execute(ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run() -
-- End of inner exception stack trace --- (Build:3160)

Microsoft.Office.Server.UserProfiles.UserProfileApplicationNotAvailableException: UserProfileDBCache_WCFLogging :: ProfileDBCacheServiceClient.GetUserData threw exceptionSystem.TimeoutException
at Nintex.Workflow.Activities.QueryUserProfileStoreActivity.Execute(ActivityExecutionContext executionContext)
at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)
at System.Workflow.Runtime.Scheduler.Run()

Userlevel 3
Badge +8

Verify that the User Profile Service is setup and running on your farm

Check that your database indexes are not highly fragmented. You can find scripts on the web for this.

You can increase the timeout period in SQL Server

or in your web.config:

<appSettings> <add key="SqlCommandTimeOut" value="240"/> </appSettings>

but this should be a last resort as there shouldn't be a timeout happening in the first place.

Reply