search cancel

Policy Server reports "Bad search filter" error when the operator TRANSLATE is in use in a Response

book

Article ID: 8782

calendar_today

Updated On:

Products

CA Single Sign On Secure Proxy Server (SiteMinder) CA Single Sign On SOA Security Manager (SiteMinder) CA Single Sign-On

Issue/Introduction

We are running Policy Server, this one reports an error when trying to find a user :

 

  Error# '87' during search: 'error: Bad search filter' Search Query = 'TRANSLATE(FILTER(userRoles,'myrole*'),'myrole;','')=*'

 

Why do we have this error ? How can we fix this ?

 

Environment

Policy Server R12.6

Cause

The operators are usually used in Expressions. If you use the operator outside the Expression configuration field, you will see this error.

Resolution

In the Response configuration, instead of using the "User Attribute" as Attribute Kind, use the "Expression" to apply the filter and then use the Operator.