SAP Knowledge Base Article - Public

2730494 - Error Message Occurred While Exporting and Importing Adhoc Report From one Instance to Another Instance

Symptom

Error message occurred while Exporting and Import Adhoc Report from one instance to another instance

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP SuccessFactors Employee Central - Adhoc Report

Reproducing the Issue

  1. log in Your Insatnce A
  2. Go to Adhoc Report 
  3. Select Domain: Single / Non-Recurring Compensation (Date Range) 
  4. Added the fields: User/Employee ID (Emp Info) / - Last Name First Name (Pers Info) /- HR Responsible (Job Info) /- Job Relationships /- Name Supervisor /- Legal Entity Legal Entity (Job Info Legal Entity)
  5. Export report and save in Desktop
  6. log in Your Insatnce B
  7. Go to Adhoc Report
  8. Upload  Insatnce B Report file. 
  9. Result: Error message

Example: An error : The Column Pill contains invalid columns.???ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN_ectintBonusPayout_ectintBonusPayout#jobRelationsInfo#8363#hr manager#REL_USER_ID???,

Cause

  • The Report definition to export from one instance to another instance as it is causing mismatch in logical column names which depends upon data model files along with picklist such as: Job Relationships, Home address, e-mail type
  • Picklist option ID in source and Target instance are not the same

214DATA.png

Resolution

Create new report selecting the required columns in target instance. Create new report from scratch  in the target Instance  and the required columns picklist Type: Job Relationships, Home address, e-mail type.

Keywords

ECT-103450, Export, import adhoc report, The Column Pill contains invalid columns, The Column Pill contains invalid columns.???ANALYTICS_LIST_VIEW_BUILDER_SUBDOMAIN,  picklist Type, Job Relationships, Home address, e-mail type. , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors Employee Central all versions