SAP Knowledge Base Article - Public

2760446 - Failure error in LMS Admin performing random actions with custom search selector enabled

Symptom

  • Environment has custom search selector(s) enabled
  • Admins navigating and performing random actions in the LMS receive the following error referencing the PV CUST_COLUMN table(s):
    SearchSelectorPVerror.png

Environment

SAP SuccessFactors Learning Management System (LMS)

Cause

DB upgrades during 1811 versions require optimized line added to modified or custom search selectors.

Resolution

Reach out to SF Support to define the optimized line needed; for example, the Component selector mainSqlFromHana line should be modified to read:

mainSqlFromHana=PV_COURSE INNER JOIN PA_I18N_LOCALIZED_LABEL I18N_LOCALIZED_LABEL ON I18N_LOCALIZED_LABEL.locale_id = '$DATA_LOCALIZED_COLUMN$' and PV_COURSE.CPNT_TITLE = I18N_LOCALIZED_LABEL.label_id LEFT OUTER JOIN PV_CPNT_CUST_COLUMN on PV_COURSE.CPNT_ID=PV_CPNT_CUST_COLUMN.CPNT_ID and PV_COURSE.CPNT_TYP_ID=PV_CPNT_CUST_COLUMN.CPNT_TYP_ID and PV_COURSE.REV_DTE = PV_CPNT_CUST_COLUMN.REV_DTE LEFT OUTER JOIN pa_cpnt_user ON pa_cpnt_user.cpnt_typ_id = PV_COURSE.cpnt_typ_id and pa_cpnt_user.cpnt_id=PV_COURSE.cpnt_id and pa_cpnt_user.rev_dte=PV_COURSE.rev_dte LEFT OUTER JOIN PA_USRRF_CPNT ON PA_CPNT_USER.USER_VALUE = PA_USRRF_CPNT.USER_ID AND PA_CPNT_USER.COL_NUM = PA_USRRF_CPNT.COL_NUM LEFT OUTER JOIN PA_I18N_LOCALIZED_LABEL I18N_LOCALIZED_LABEL2 ON I18N_LOCALIZED_LABEL2.locale_id = '$DATA_LOCALIZED_COLUMN$' AND I18N_LOCALIZED_LABEL2.label_id = PA_USRRF_CPNT.USER_DESC LEFT OUTER JOIN PA_OCN_COURSE on PV_COURSE.OCN_COURSE_SYS_GUID = PA_OCN_COURSE.COURSE_SYS_GUID

See Also

  • 2545256 - User search from Admin side results in Communication Error
  • 2321185 - Time Out error or performance issue when trying to open a record in a customer's instance (Internal CS access only)
  • LRN-51289

Keywords

 SAP SF Learning LMS Failure error message admin admins navigating random different intermittent actions CUST_COLUMN PV table PV_CPNT_CUST_COLUMN activities perform , KBA , LOD-SF-LMS-ADM , Admin Tools , Problem

Product

SAP SuccessFactors Learning 1811