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):
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
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 , System Admin, Global Variables, References , Problem