SAP Knowledge Base Article - Public

2973443 - Post picklist migration errors validating reports - Advanced Reporting

Symptom

  • Error rendering list report component in Canvas/ORD reports after picklist migration
  • Some ORD/Canvas reports have validation errors after the picklist migration

Environment

SAP SuccessFactors HXM Suite

Reproducing the Issue

  1. Go to Report Center
  2. Run the canvas report that was working prior to the picklist migration
  3. The error message "Error rendering list report component" will be displayed
  4. Go back to Report Center
  5. Edit the report
  6. Click on Validate Page
  7. Click on Validate
  8. There will be validation errors e.g. Query contains an invalid autolink column ' ' (MEMB_PICKLIST_LABEL)' from table ' ' to table 'AUTO_OBJECT_PICKLIST_MDF_PicklistName'.

Cause

Picklists that have duplicate or different Picklist IDs compared with their Picklist ID prior to the migration are non backward compatible, meaning existing Advanced Reports reference the original Picklist ID, not the new Picklist ID, and will throw validation errors.

Resolution

Existing reports that use these picklists require validation to identify and correct the report to use the new Picklist ID. Also, if any picklist ID is changed (new or legacy), it's required to validate the reports that contained this picklist. Please refer the documents below on how to fix validation errors in the Canvas reports:

Note: New reports created post picklist migration will not have any Picklist Migration related issue.

See Also

Picklist Migration 

Keywords

Error rendering list report component Canvas ORD report picklist migration validation error query contains an invalid autolink colum label , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Problem

Product

SAP SuccessFactors HXM Suite all versions