SAP Knowledge Base Article - Public

3433792 - Job Profile Builder Migration Error: contextError={ com.successfactors.sca.ServiceApplicationException: com.successfactors.jdmng.JDAccessException: com.successfactors.sca.ServiceApplicationException: Failed to execute and process SQL query }, formatError={ }

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

  1. Log in to system
  2. Navigate to Admin Center > Scheduled Job Manager
  3. In the Job Type dropdown, select JDM Old to New Sync
  4. Select View Details
  5. 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:

  1. Export roles following the steps in Implementing and Managing Job Profile Builder - Exporting Your Job Profile Data Using Manage Job Profile Content Import/Export
  2. Ensure en_US translations are populated for all active roles
  3. 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

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

Product

SAP SuccessFactors HXM Suite 2311