SAP Knowledge Base Article - Public

3450915 - Career Worksheet - Application Error in Suggested Roles

Symptom

When navigating to the Suggested Roles section of the Career Worksheet an application error is displayed.

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 Job Profile Builder
  • SAP SuccessFactors Succession & Development

Reproducing the Issue

1. Go to Career Development Planning module
2. Go to the Career Worksheet
3. Go to Suggested Roles
4. Application error is received

Cause

The root cause of the issue is likely due to duplicate keys being present in the JDM data for some roles.

To verify if this is the root cause you may follow the steps outlined below.

  1. Go to "Import and Export Data" tool
  2. Select "JdmJpbMappingEntity" for Select Generic Object
  3. Select "No" for Include Dependencies
  4. Select "Yes" for Include Inactive Records
  5. Select "Export"
  6. Go to "Scheduled Job Manager"
  7. Select "View Details" on the latest MDF Data Export job which has "JdmJpbMappingEntity" in the Job Name
  8. Select "Download Status"
  9. Open the JdmJpbMappingEntity.csv file within the zip file
  10. Highlight the "jdmId" column
  11. Select "Conditional Formatting" > "Highlight Cells Rule" > "Duplicate Values" > "Ok"
  12. Highlight the "jdmId" column and select "Sort & Filter" 
  13. In the filter dropdown select "Sort by colour" > "Sort by Cell colour" > "Expand the selection" > "Sort"
  14. If there are records of objectType "Role" with the same jdmId these are the root cause

Resolution

Scenario 1: If the duplicate jdmID's have a value of -1

  1. Go to the Check Tool
  2. Select "System Health"
  3. Select "Job Profile Builder" as the Application
  4. Select all and run the check tool on for "Missing Job Description Manager data reference in the mapping entity" 
  5. Open the results
  6. Run the Quick Fix 

Scenario 2: If the duplicate jdmID's have a value other than -1

  1. Identify the role which is invalid
  2. Ensure the invalid role is not being used or referenced anywhere else in the system
  3. Delete the invalid role

Keywords

Career, Worksheet, Suggested, Roles, Error, Message, Application, System, JDM, JPB, TIH, Jobcode, Duplicate, Keys, Attempted, Merging, Values, Browser , KBA , LOD-SF-TIH-JPB-ADM , Admin Center, Settings, Permissions , LOD-SF-CDP-CW , Career Worksheet , Problem

Product

SAP SuccessFactors HCM Suite all versions ; SAP SuccessFactors Succession & Development all versions