SAP Knowledge Base Article - Public

2581149 - Compensation : Error message Logic While Importing lookup table

Symptom

Lookup tables return a very user friendly message when there are duplicates in the table data.

e.g. Table Data1

Input Output
abcd 1
ABC 2
ABC 3

Error message: Data entry line 4 is a duplicate of line 3.

However if the same duplicate entry is in a different case then error message doesn't help identifying the problem.

e.g. Table Data2

Input Output
abcd 1
ABC 2
abc 3

Error message: File empty or format invalid.

Environment

Successfactors Compensation

Reproducing the Issue

  1. Login as Admin > Admin Center > Compensation Home >A ction for all plans.
  2. All Plans > lookup tables >Create Look up Table > Import CSV with Sample data as shown in Data Table1 > Observe Error Message.
  3. Now Import CSV using sample data as Data Table2 > Notice that error message doesn't clearly shows what's wrong.

Cause

  • This is because in case 1 validation is done before sending the data to DB whereas for second scenario validation is done at Database level.
  • As per product design generic message "File empty or format invalid." is thrown for all errors thrown at Database level.

Resolution

  • Please Use case insenstive data for input values to avoid this error.
  • Alternatively if there is a business need to have meaningful message then please submit it as an idea in customer community.
  • Steps to Submit an idea are outlined in this article.

PS: Support Engineers may refer to internal note for jira reference where Engineering has confirmed this behavior.

Keywords

error message look up table duplicate , KBA , LOD-SF-CMP-ADM , Admin Tools, Settings, Permissions , Problem

Product

SAP SuccessFactors Compensation all versions ; SAP SuccessFactors HCM Core 1711