Return
-
Title
Approval tasks throwing Error: Exception has been thrown by the target of an invocation -
Description
Approval tasks throwing error "Exception has been thrown by the target of an invocation". Verbose logging shows the following details.
"Specified method is not supported.
at ActiveRoles.Service.Workflow.WorkflowObjectSqlQueryBuilder.GetQuotedSqlValue(Object value)at ActiveRoles.Service.Workflow.WorkflowObjectSqlQueryBuilder.b__0(Match m)at System.Text.RegularExpressions.RegexReplacement.Replace(MatchEvaluator evaluator, Regex regex, String input, Int32 count, Int32 startat)at System.Text.RegularExpressions.Regex.Replace(String input, MatchEvaluator evaluator)at ActiveRoles.Service.Workflow.WorkflowObjectSqlQueryBuilder.ParameterCountLimitFallback(SqlCommand command)at ActiveRoles.Service.Workflow.WorkflowObjectSqlQueryBuilder.InternalSearch(WorkflowObjectSearchRequest request, RawFilter filter, Int32 pageSize, Cookie cookie, WorkflowObjectSearchDirection direction, Boolean isReliable)at ActiveRoles.Service.Workflow.WorkflowObjectSqlQueryBuilder.Search(WorkflowObjectSearchRequest request, Boolean isReliable)at ActiveRoles.Service.Workflow.TaskStore.FindTasks(WorkflowTaskSearchRequest request, Boolean isReliable)at ActiveRoles.Service.RequestPrePostProcessorBase.PreProcessRequest(RequestContext context)at ActiveRoles.Service.StaticPolicyList.ProcessRequest(RequestContext context, String handler)" -
Cause
The user is a member of a very large number of groups (including indirect membership). By designer Active Roles will be limitate some queries in the DB with no more than 2000 parameters. -
Resolution
Remove the user experiencing the issue from some group.