Symptom
When trying to complete the JDM to JPB migration, the migration fails with an error:
contextError={ com.successfactors.sca.ServiceApplicationException: com.successfactors.jdmng.JDAccessException: com.successfactors.sca.ServiceApplicationException: Failed to execute and process SQL query }, formatError={ }
Environment
- SAP SuccessFactors Job Profile Builder
- SAP SuccessFactors Job Description Manager
Reproducing the Issue
- Log in to system
- Navigate to Admin Center > Scheduled Job Manager
- In the Job Type dropdown, select JDM Old to New Sync
- Select View Details
- See error
Cause
Active roles are missing en_US translations
Resolution
Job Profile Builder requires en_US translations to be maintained for all active roles so these must be populated before attempting the migration. Please follow the below steps:
- Export roles following the steps in Implementing and Managing Job Profile Builder - Exporting Your Job Profile Data Using Manage Job Profile Content Import/Export
- Ensure en_US translations are populated for all active roles
- Import the roles with the new translations following the steps in Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using Manage Job Profile Content Import/Export
See Also
- Implementing and Managing Job Profile Builder - Exporting Your Job Profile Data Using Manage Job Profile Content Import/Export
- Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using Manage Job Profile Content Import/Export
- Implementing and Managing Job Profile Builder - Migrating from Job Description Manager to Job Profile Builder
Keywords
success factors, sf, sfsf, jpb, cannot migrate, migrations, migrating, failed, errors, warnings, incomplete, not completed, incomplete, jdm , KBA , LOD-SF-TIH-JPB-MIG , Migration to Job Profile Builder , LOD-SF-TIH-JDM , Job Description Manager , Problem