SAP Knowledge Base Article - Public

3282970 - Edit Learning History search returns an application error

Symptom

When admin is trying to perform a search under Manage User Learning > Edit Learning History, an application error is presented even though the relevant search selector config file is not customized.

Error message = The straight column name [column_name] is not present in the projectionwith original orderBy [s.LNAME, s.FNAME, a.COMPL_DTE]

Example screenshot:


Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Go to Manage User learning
  2. Edit Learning History
  3. Search 
  4. Error is presented

Cause

When SearchSelectorSortingAtEnd is set to 'true' on the backend, some use cases in the select query were not considered by the code logic.

Resolution

Engineering created a code correction and this will be fixed in b2305 as part of LRN-138883.

In the meantime, if you are experiencing the same behaviour, please submit a ticket to LOD-SF-LMS-ADM component by referencing this KBA and ask Support to modify the SearchSelectorSortingAtEnd value from 'true' to 'false' in your tenant.

Keywords

edit learning history, application error, search, searchSelectorSortingAtEnd, LRN-138883 , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , Problem

Product

SAP SuccessFactors Learning 2205 ; SAP SuccessFactors Learning 2211