SAP Knowledge Base Article - Public

3271583 - Item Title & Description are blank in the System Default language for some Items.

Symptom

Learning items do not show title and description although the data is populated for the locales

Environment

SAP SuccessFactors Learning

Reproducing the Issue

Please note this is random and may not be replicated for all users.

  1. Navigate to LMS Admin system >
  2. Go to Learning Activities > Items >
  3. Search for the affected item >
  4. Note that the title and description are missing for the item, despite the label being populated for the default and other locales.

OR

  1. Navigate to LMS Admin system >
  2. Click on the Recents tab >
  3. Click on the affected item >
  4. Note that the title is missing for the item

Note: If the title is missing for the title it will also be missing for any related classes.

OR

  1. Navigate to LMS Admin system >
  2. Go to Learning Activities > libraries >
  3. Access the library which the affected items are under >
  4. Access the Items tab >
  5. Note that the title and description are missing for the items.

Cause

Note below what is happening exactly when the admin tries to see the item titles and descriptions:

  • There are several thousand items under one library.

  • When an Admin navigates to the library and tries to view the items, the system tries to load all the item's titles and descriptions from the database (DB). For which it is using IN LIST query.

  • The number of IN LIST parameters exceeds the number of parameters that the DB currently supports, and the query fails to load the title and description for the items under this library at first.

  • This failure is recorded as a label value as not found in DB, which is cached in the Learning System App.

  • Afterwards, for any new request made (ITEM Details request or User viewing item on Learning plan), the system will show the Item Title and Description as null, because this is how it is currently cached.

Resolution

Workaround suggested:

  1. Grant the SAP Product Support permission to delete the specific Locale(s) cache(s) in diagnostics app, so Item Tiles and Descriptions will no longer be null due to cache, and display as expected with new requests >
  2. Then, to avoid this scenario from happening again, we advise you to create libraries limited to 10k items >
  3. Also, we do not encourage Admins to visit the Library > Items tab (where the number of items under the library crosses over 10k items), otherwise the cache issue will repeat.

    To avoid this scenario from happening again, we advise you to create libraries limited to 10k items. And to fix the current scenarios, we suggest reaching out to an SAP Certified Partner or SAP Professional Services, which will further advise.

    Keywords

    null, empty, titles, missing, items, locales, cache, diagnostics, description , KBA , LOD-SF-LMS-ITE , Items , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS-OCN , Open Content Network , LOD-SF-LMS , Learning Management System , Problem

    Product

    SAP SuccessFactors Learning all versions