SAP Knowledge Base Article - Public

3768981 - Keyword filter shows "validation error: keyword phrase is too long to perform the search" when adding users to a class

Symptom

  • When administrators use the Keyword filter to search and add users to a class, the search fails.
  • Error message: "Validation Error"
  • Error details: "Please correct the following errors before proceeding: Keyword phrase is too long to perform the search."

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Open a class (scheduled offering) in the admin area.
  2. Select the option to add participants.
  3. In the Keyword filter, enter an excessively long string or many space‑separated terms (for example, a long sequence of zeros).
  4. Execute the search and observe the validation error.

Cause

  • Working as designed: the keywords are expanded into a search criteria (multiple LIKE conditions across several user-related fields). When the resulting WHERE clause exceeds approximately 4000 characters, validation fails.
  • There is no fixed character or word limit in the input field because the final criteria length depends on how the keywords are parsed and how many fields are searched.

Resolution

  • Shorten the Keyword input by reducing the number of terms and/or using shorter terms so the generated criteria remains under the ~4000‑character limit.
  • If needed, run multiple smaller searches with fewer keywords and add users in batches.
  • Repeat until all intended users are added.

See Also

Keywords

validation error, keyword phrase is too long to perform the search, keyword filter, add participants, class, scheduled offering, user search, search limit, 4000 characters, where clause, like operator, successfactors learning, lms admin, long keyword, expected behavior , KBA , LOD-SF-LMS-SCH , Class - Scheduled Offerings , Problem

Product

SAP SuccessFactors Learning 2605