Symantec Access Management

  • Private Community
 View Only
Back to discussions
Expand all | Collapse all

Tech Tip : CA Single Sign-On : Policy Server reports "Bad search filter" error when the operator TRANSLATE is in use in a Response

  • 1.  Tech Tip : CA Single Sign-On : Policy Server reports "Bad search filter" error when the operator TRANSLATE is in use in a Response

    Broadcom Employee
    Posted Dec 04, 2017 02:59 AM

    Issue:


    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.

     

    KB : TEC1845165