2366838 - Users not found after 1608 Upgrade

SAP Knowledge Base Article - Public

2366838 - Users not found after 1608 Upgrade

Symptom

When searching for users, no search results or message that search results have not been found come up for administrators.

Environment

SAP SuccessFactors Learning - b1608 and higher

Reproducing the Issue

On the LMS Admin side attempt to search for Users.

Cause

The User Search Selector has been modified from the default configuration.

Resolution

Modify the User search selector, under System Admin -> Configuration -> Search Selectors -> User. You will need to inspect the User search selector and if the PA_STUDENT.PERSON_ID_EXTERNAL column is not found under selectClause.mainSqlClause, they should add it.

After adding PA_STUDENT.PERSON_ID_EXTERNAL to selectClause.mainSqlClause it will looks like below:

 

selectClause.mainSqlClause=PA_STUDENT.STUD_ID,PA_STUDENT.EMP_STAT_ID,PA_STUDENT.EMP_TYP_ID,PA_STUDENT.FULLTIME,PA_STUDENT.REGULAR_TEMP_ID,PA_STUDENT.JL_ID,PA_STUDENT.JP_ID,PA_STUDENT.DMN_ID,\n PA_STUDENT.ORG_ID,PA_STUDENT.CO_ID,PA_STUDENT.LNAME,PA_STUDENT.FNAME,PA_STUDENT.MI,PA_STUDENT.NOTACTIVE,PA_STUDENT.ADDR,\n PA_STUDENT.CITY,PA_STUDENT.STATE,PA_STUDENT.POSTAL,PA_STUDENT.CNTRY,PA_STUDENT.SUPER,PA_STUDENT.HIRE_DTE,PA_STUDENT.TERM_DTE,\n PA_STUDENT.EMAIL_ADDR,PA_STUDENT.HAS_ACCESS,PA_STUDENT.SELF_REGISTRATION,PA_STUDENT.LOCKED,PA_STUDENT.REGION_ID,\n PA_STUDENT.ROLE_ID,pa_stud_tp.STATUS as PROFILE_STATUS, pa_student_fin_acct.acct_id as ACCOUNT_ID, PA_STUDENT.POS_NUM_ID, PA_STUDENT.NATIVE_DEEPLINK_USER, PA_STUDENT.GAMIFICATION_STUD_ID, PA_STUDENT.PERSON_ID_EXTERNAL

Keywords

1608, User search, blank, No users found , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611