2395166 - Admin searching for users gets no result

SAP Knowledge Base Article - Public

2395166 - Admin searching for users gets no result

Symptom

In our learning instance when an admin goes to search for users (Users > Search) gets no results.

 

Environment

Successfactors Learning

Learning Management System

Reproducing the Issue

  • login to learning.
  • Switch to admin view.
  • Click Users in main menu.
  • Click "Search" button. Wait. No results returned.  
  • Search for any particular user with User ID or Firstname or Lastname, No results returned.

Cause

This happens because of the customization done on the user search selector.

Resolution

We added an extra field to the user record: External ID. To support the field, we modified the default User search selector. If you customized the default User search selector, you do not get the update to include PA_STUDENT.PERSON_ID_EXTERNAL. Add it to avoid errors when searching for user records.

Step 1: Navigate to System Admin > Configration > Search Selectors
Step 2: Find and open the selector name "User"
Step 3: Find selectClause.mainSqlClause
Step 4: Look at the end of the comma separated list of values for selectClause.mainSqlClause for PA_STUDENT.PERSON_ID_EXTERNAL
Step 5: If you cannot find PA_STUDENT.PERSON_ID_EXTERNAL at the end of selectClause.mainSqlClause, add it.

            After you have added PA_STUDENT.PERSON_ID_EXTERNAL, selectClause.mainSqlClause looks like the following. You might have added or removed cells based on your customization and we formatted this sample so that the code would fit on this page.

            Sample Code

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

 

Step 6 : Click Apply Changes.

 

Keywords

Admin searching for users gets no result User Search is blank User Search not resurning any result no result in user search   , KBA , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Problem

Product

SAP SuccessFactors Learning 1608 ; SAP SuccessFactors Learning 1611