SAP Knowledge Base Article - Public

2657291 - Error Message Occurred While Importing More Than 1500 Picklist Records

Symptom

  • Slowness when accessing Picklists.
  • Manage data UI is not able to handle the large number of child entries
  • System is not able to load more than 1500 Picklist to display on the Picklist Center.

Environment

  • SAP SuccessFactors Employee Central
  • SAP SuccessFactors HXM Suite
  • Metadata Framework (MDF)

Reproducing the Issue

  1. Import more than 1500 picklist.
  2. The selected picklist is too large to open, thus impossible for the system to load immediately. Eventually the loading makes the session to  time-out.
  3. The picklist keep loading and after some minutes an error pops up saying - Gateway Timeout error.

Resolution

Workaround:

  1. Go to Import and Export Data.
  2. Select Generic Object for "Picklist Values".
  3. Set Yes for Dependencies.
  4. Set Yes for All data record.
  5. Export the "Picklist Values".
  6. In the exported Excell file, Identify your picklist type.
  7. Make your changes and save
  8. Import back into the system.

Guide for Creating MDF Picklists Using MDF Import .

See Also

KBA 2727186 - How to view a picklist with more than 200 entries

Keywords

XAF-22539, XAF-23395, XAF-3334, Picklists, limitation with MDF picklist, Import , MDF, Picklist Import , KBA , LOD-SF-EC-JRL , Job Relationships , LOD-SF-EC-BCI , Manage Business Configuration (BCUI) & Data Models (XML) , LOD-SF-EC-PER , Person Data (All Person Data Types) , Problem

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM suite all versions