SAP Knowledge Base Article - Public

3454414 - Job Profile Builder Migration Error: contextError={ com.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: Wrapped Exception: DAOException caught: SQLException caught: IJ031070: Transaction cannot proceed: STATUS_MARKED_ROLLBACK }, formatError={ }

Symptom

When trying to complete the Job Profile Builder migration, the migration job fails with an error:

contextError={ com.successfactors.sca.service.ServiceLegacyRollbackException: Wrapped Exception: Wrapped Exception: DAOException caught: SQLException caught: IJ031070: Transaction cannot proceed: STATUS_MARKED_ROLLBACK }, formatError={  }

Environment

  • SAP SuccessFactors Job Description Manager
  • SAP SuccessFactors Job Profile Builder

Reproducing the Issue

  1. All JDM check tool errors have been resolved
  2. Follow the steps in Implementing and Managing Job Profile Builder - Migrating from Job Description Manager to Job Profile Builder
  3. Navigate to Admin Center > Tools > Scheduled Job Manager
  4. Select the Job Monitor tab
  5. In the Job Type dropdown, select JDM Old to New Sync
  6. Locate the failed job and select View Details
  7. Select Download Status
  8. Error is present in the file

Cause

Duplicated job roles

Resolution

Job Profile Builder data syncs to Job Description Manager, but Job Description Manager does not sync to Job Profile Builder. When a role is created in Provisioning tied to a job code, and then the same role is created in Job Profile Builder tied to the same job code, this results in duplicated roles. This is not supported in Job Profile Builder and will cause the migration to fail. To resolve the issue, the data must be resynced using Job Profile Builder following the below steps:

  1. Log in to SuccessFactors
  2. Export Family data following the steps in Implementing the Metadata Framework (MDF) - Exporting Object Definitions
  3. Export Role data following the steps in Implementing the Metadata Framework (MDF) - Exporting Object Definitions
  4. Do not make any changes to either file
  5. Import Family data following the steps in Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using Manage Job Profile Content Import/Export
  6. Import Role data 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, jdm, migrations, migrating, failures, failing, errors, cannot migrate, roles, duplicating , KBA , LOD-SF-TIH-JPB-MIG , Migration to Job Profile Builder , LOD-SF-TIH-JDM , Job Description Manager , LOD-SF-MDF-IMP , Import and Export Issues , Problem

Product

SAP SuccessFactors HXM Suite 2311