2400189 - Unable to search for users in LMS

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

Learning Management System Core

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

• 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.

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.

LMS, User Search, PERSON_GUID, Cannot search users, Unable to search users, PA_STUDENT.PERSON_GUID, search selector , KBA , LOD-SF-LMS , Learning Management System , Problem