SAP Knowledge Base Article - Public

3779101 - Job Profile Builder Role Import Error: Error occurred. java.lang.RuntimeException: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_MARKED_ROLLBACK

Symptom

When importing a role file for job profile builder, the job to process the import fails with an error:

Error occurred. java.lang.RuntimeException: java.sql.SQLException: IJ031070: Transaction cannot proceed: STATUS_MARKED_ROLLBACK

Environment

SAP SuccessFactors Job Profile Builder

Reproducing the Issue

  1. Prepare a Role import file
  2. Log into SuccessFactors
  3. In the global search, type Manage Job Profile Content Import/Export OR Import and Export Data
  4. Browse for your file > Select Import
  5. Navigate to Scheduled Job Manager
  6. Locate the job failed > Select View Details
  7. Error is indicated

Cause

  • Migration to Job Profile Builder has not been completed
  • Using Import and Export Data to import job profile builder files
  • Import contains a duplicate role
  • Invalid locales are not migrated during JDM to JPB migration

Resolution

Migration to Job Profile Builder has not been completed

Some customers have the Job Profile Builder appearance but the system framework is still Job Description Manager. Data becomes fragmented between frameworks causing various discrepancies. This situation applies when the following criteria is met:

  • You can locate Manage Job Profile Builder in global search or Admin Center, and
  • You do not see a job named JDM Old to New Sync in Scheduled Job Manager, or you have a check tool error for Job Profile Builder migration successful. (JPBEnabledAndMigrationCheck) 

A Certified Partner engagement is required to complete the migration and resolve discrepancies. If you do not have a Certified Partner, you can look for one using 2149831 - SAP Professional Services / SAP Certified Partner / SAP Account Management Team [SuccessFactors Cloud].

Using Import and Export Data to import job profile builder files

Job profile builder data should only be imported using Manage Job Profile Content Import/Export as it ensures files are only loaded with incremental updates. This is the only location documented in Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using the Manage Job Profile Content Import/Export Option.

Import contains a duplicate role

By design, Job Profile Builder will not allow a duplicate role to be imported into the system. This is to ensure data integrity and prevent future data issues.

To identify the duplicate role, export the existing data from your system and compare it to the data in your import file. You can reference the steps and best practices in Implementing and Managing Job Profile Builder - Exporting Your Job Profile Data Using Manage Job Profile Content Import/Export.

Invalid locales are not migrated during JDM to JPB migration

In case all JDM and JPB checks are green, still JPB Migration job fails with this error message, make sure to follow below steps:

  1. Go to Check Tool 
  2. Under Migration, choose Job Description manager 
  3. Check Invalid locales are not migrated during JDM to JPB migration (JDMInvalidLocaleExistenceCheck)

In case after rerunning this check it is still red, run Quick Fix. Once this check is green, rerun JPB Migration - 3781355 - Invalid locales are not migrated during JDM to JPB migration (JDMInvalidLocaleExistenceCheck) - Job Description Manager - SAP for Me 

See Also

Keywords

import, STATUS_MARKED_ROLLBACK, IJ031070, Scheduled Job Manager, MDFImportJob, duplicate role, Job Profile Builder, Manage Job Profile Content, job profile import, role import failure, system error while syncing, application error, rollback transaction , KBA , LOD-SF-TIH-JPB , Job Profile Builder , Problem

Product

SAP SuccessFactors Platform all versions