SAP Knowledge Base Article - Public

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

Symptom

  • Slowness when accessing Picklists in IE
  • Manage data UI is not able to handle the large number of child entries (13k) even 1500 records has performance issues on UI
  • systems is not able to load more Than 1500 Picklist Picklist for display in the Picklist Centre

Environment

SAP SuccessFactors HCM Core - Picklists

Reproducing the Issue

  • Import more than 1500 picklist
  • The selected picklist is too large to open, thus impossible for the system to load immediately. Eventually the loading  times out.
  • The picklist kept on loading and after 5-6 minutes the error pops up saying - Gateway Timeout error.

Cause

Product limitation

Resolution

Product limitation When importing picklist with large number of picklist-values i.e Greater than 1500

This is a known limitation with MDF picklist and Picklist Engineering team are working on the Fix with: XAF-3334

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.

Here is the link on how to guide for MDF picklist Import. here

Keywords

XAF-22539, XAF-23395,XAF-3334,Picklists, limitation with MDF picklist, Import , MDF, Picklist Import , KBA , LOD-SF-EC-MDF , MDF & EC2MDF Migration , LOD-SF-EC-BCI , BCUI & DM Config(XML) , LOD-SF-EC-PER , Person Information , Problem

Product

SAP SuccessFactors HCM Core all versions