SAP Knowledge Base Article - Public

3017091 - Leading or trailing space in Referenced Custom Columns

Symptom

  • Certain entities and functions will give error or unexpected results when using a referenced custom column with trailing or leading space.
  • For example, an error is displayed when loading a curriculum from Learning Administration or saving an Assignment Profile rule.

Environment

SAP SuccessFactors Learning

Reproducing the Issue

  1. Have a referenced custom column with an ID having a trailing or leading space.
  2. Attempt to use said custom column in a function or entity and receive an error.

Cause

The referenced custom column ID space causes a vague database return.

Resolution

  • Although the system no longer allows to create custom columns with leading or trailing spaces in the UI, a connector or past option may exist.
  • To correct this, update the custom column ID or records individually or through connectors as needed to remove the leading or trailing space.

See Also

2482435 - Assignment Profile Rules with multiple values do not return results

Keywords

sap, sf, success, factors, lms, learning, reference, referenced, custom, column, columns, field, value, curriculum, new, admin, ui, assignment, profile, error, space, trailing, leading, LRN-11002 , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-ITE , Items , LOD-SF-LMS-USR , User Entity , LOD-SF-LMS-PRO , Programs , LOD-SF-LMS-CUR , Curricula , LOD-SF-LMS-ASP , Assignment Profile , Problem

Product

SAP SuccessFactors Learning all versions