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

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 ?

 

Cause

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

Environment

Policy Server R12.6

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.