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={ }

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={  }

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

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

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

• Inactive mapping between jobe code/job classification and job role
• Duplicated job roles

Inactive mapping between jobe code/job classification and job role

1. Follow the steps in Implementing the Metadata Framework (MDF) - Exporting Object Definitions for the Role-Job Codes object (Ensure Include Inactive Records is set to Yes)
2. Open the file and locate column G jobCodeMappings.status
   
3. Filter the column for all I values
4. Change all I values to A > Save the file
5. Follow the steps in Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using Manage Job Profile Content Import/Export for the Role-Job Codes Type

Duplicated job roles

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

• Implementing and Managing Job Profile Builder - Migrating from Job Description Manager to Job Profile Builder
• Implementing the Metadata Framework (MDF) - Exporting Object Definitions
• Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using Manage Job Profile Content Import/Export

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