SAP Knowledge Base Article - Public

2264127 - ODS Advanced Reporting - Error in rendering component – List Report A duplicate autojoin column found - Validation report error possibility

Symptom

Your query show the following error :

  • [Error rendering List Report component]
  • List Report A duplicate autojoin column found. Table: EC_EMP_JOB_INFO_T(1) to CONFIG_GENERIC_OBJECT_T_GOLocalizedData. Join: 6f87a7f6-42cc-41d3-9e19- cc8fa0b616e5/e0f3af1f-8bae-4eac-8e9b-ffc187e87e89 . You may need to re- upload the report. 

Reproducing the Issue

  1. Open your report showing [Error in rendering]
  2. Edit component
  3. Edit Query
  4. The query show the error [List Report A duplicate autojoin column found]

Or

  1. Go in report designer
  2. Click on your report
  3. Validate your report
  4. This shown [A duplicate autojoin column found. Table: EC_EMP_JOB_INFO_T(1) to CONFIG_GENERIC_OBJECT_T_GOLocalizedData. Join: 6f87a7f6-42cc-41d3-9e19-cc8fa0b616e5/e0f3af1f-8bae-4eac-8e9b-ffc187e87e89 . You may need to re-upload the report.]

Cause

  • Your query was previously saved in a specific ODS/EC configuration including the Label / Code or anything related to EC configuration.
  • The report fail because your ODS / Advanced reporting instance has been updated based on your new Employee Central configuration but your report need to be updated.

Resolution

  1. Select your report
  2. Edit the Query (right click on the component + Edit query).
  3. In this example, the message show duplicate with [MDF_GENERIC_OBJECT_JOB_JUNCTION] (mean Job function field) in [EMP_EC_JOBINFO] mean Job information table.

    FixingDuplicateAutoLink Step 1.png
  4.  Remove the Job family fields and select the new Job Familly name (In this example, you can see previous name was Job familly and new name is now Job Familly [Wings] and we assume this field is called Job Familly Wings also in your Employee Central instance)

    Steps2.jpg
  5. Save your query
  6. Return and the report should work again

    Steps 4.jpg

If this doesn't fix your incident, feel free to open a new incident and contact your support. We will be glad to help you.

 

Keywords

ODS,Advanced Reporting,Error validation,Validation,Report, Duplicate,List Report A duplicate autojoin column found , KBA , LOD-SF-WFA , Workforce Analytics & Planning , Problem

Product

SAP SuccessFactors HCM Core 1511