2400189 - Unable to search for users in LMS

SAP Knowledge Base Article - Public

2400189 - Unable to search for users in LMS

Symptom

Not possible to search for users in the LMS environment, the search does not return values or does returns an error message.

Environment

Learning Management System Core

Reproducing the Issue

  1. Navigate to the Learning Administration> Users > Users
  2. Perform a search without any filters
  3. The search does not return any results

Cause

  • There might be errors on the search selector configuration.
  • Sometimes the releases create new tables, those tables need to be in the search selector configuration, the system automatically adds them to the default configuration. If you customized your user search selector configuration, the new table/s will have to be inserted for the search to work.

Resolution

  1. Navigate to the Learning Administration > System Admin > Configuration > Search Selector
  2. Find and edit "User"
  3. Find the following line (it might be slightly different if your configuration is customized): 

    • 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.JOB_TITLE,PA_STUDENT.GAMIFICATION_STUD_ID,PA_STUDENT.PERSON_ID_EXTERNAL

  4. Add the new table/s at the end of this line using a comma between tables - (for the case of the release b1611 the new table is: PA_STUDENT.PERSON_GUID)
  5. Using the example of the release b1611, after adding the table, the line will look like this:

    • 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.JOB_TITLE,PA_STUDENT.GAMIFICATION_STUD_ID,PA_STUDENT.PERSON_ID_EXTERNAL,PA_STUDENT.PERSON_GUID

Note: You only need to add the new table ('PA_STUDENT.PERSON_GUID' for b1611) in the at the end of the line. You do not need to change all the line from this KBA on your User Search Selector, however, if you have your configuration customized, and just adding the new table/s does not work, you can save a backup of your actual configuration and copy the whole line in this KBA into your configuration in order to test.

We recommend that you always perform a backup copy of this settings before edditing. To do it, simple copy all the text and paste on a text editor.

Keywords

User Search Cannot search users Unable to search users 1611 release user search , KBA , LOD-SF-LMS , SuccessFactors Learning , Problem

Product

SAP SuccessFactors Learning 1611