SAP Knowledge Base Article - Public

3051020 - Error upon a User Search Action

Symptom

Post the 1H 2021 (b2105) upgrade, when attempting to search for a user, an error is presented in the results.

  • "Cannot initialize the value object: Invalid column name"

Environment

SAP SuccessFactors Learning - 1H 2021 (b2105)

Reproducing the Issue

  1. Access Learning Administration
  2. Go to People > Users
  3. Search for a User
  4. Error is presented

Cause

Due to customized search selectors, the search query is not working

Resolution

This issue will be fixed with the release of 1H 2021 on Production environments.

Workaround:

  1. Go to System Administration > Configuration > System Configuration
  2. Search for "User" and edit
  3. Take a backup of the current search selector in an external text tool
  4. Search for "selectClause.mainSqlClause="
  5. Add PA_STUDENT.LMS_ORIGIN  and PA_STUDENT.STUD_SYS_GUID
    • Example: "selectClause.mainSqlClause=PA_STUDENT.LMS_ORIGIN,PA_STUDENT.STUD_SYS_GUID" to the beginning of the clause but make sure to leave everything else the same
  6. Apply Changes

Keywords

search, selector, error, column, names, 1h 2021, release, update, upgrade, user, cannot, lms, sf, unable, invalid, , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Known Error

Product

SAP SuccessFactors Learning 2105