2534529 - Reference Custom Columns in the LMS error when attempting to remove the value and save

SAP Knowledge Base Article - Public

2534529 - Reference Custom Columns in the LMS error when attempting to remove the value and save

Symptom

  • When an Admin attempts to remove the value of a Custom Column that is set as a reference and drop down pick lists are disabled, an error is thrown when the record is saved:
Failure: [FaultEvent fault=[RPC Fault faultString="com.plateausystems.elms.framework.snapshot.api.SnapshotException : com.plateausystems.elms.util.helper.ElmsCreateException: java.sql.SQLException: ORA-20001: PKG_TRIGGER.PT_BIU_CPNT_USER: invalid USER_ID - parent key not found (PA_USRRF_CPNT)
ORA-06512: at "INSTANCE_SCHEMA.PKG_TRIGGER", line 720
ORA-06512: at line 1
  • The error only occurs if dropDownEnabled is set to false under System Admin > Configuration > Search Selectors

Environment

  • SAP SuccessFactors Learning Management System (LMS)
  • Release b1708

Reproducing the Issue

  1. Logon to LMS Admin
  2. Navigate to a Record that has a reference field that is a custom column setup for it
  3. Ex: Learning > Item > Item_1234
  4. Click "View All" to expand the Extended Summary of the record
  5. Scroll down to the referenced custom column and clear the value
  6. Click Save
  7. Note the error pop-up:
    ReferenceError.jpg

Cause

This has been identified as a defect under LRN-23476

Resolution

This issue has been corrected in release 1711

Workaround:

  1. Logon to LMS Admin
  2. Navigate to System Admin > Configuration > Search Selectors
  3. Find "Custom Column Component Reference" and click the Edit icon
    • Note: "Component" is specifc to Item Records, if the reference field you are having an issue with is on another record type, edit that search selector
  4. Find the "dropDownEnabled" entry
  5. Set this from false to true
  6. Save changes
    dropDownEnabled.jpg

See Also

User Assistance Guide for Search Selectors

Keywords

SF SuccessFactors Learning LMS custom column reference delete del remove clear take out value error failure exception unable cannot save picker pick list select box , KBA , LOD-SF-LMS-ITE , LMS Items , LOD-SF-LMS , SuccessFactors Learning , LOD-SF-LMS-COR , LMS Core - Items, Catalog, Curricula , Bug Filed

Product

SAP SuccessFactors Learning 1705