SAP Knowledge Base Article - Public

3601506 - Migrate to Talent intelligence Hub "Runtime Exception,"UNKNOWN","Runtime exception while migration","FAILED","contextError={ com.successfactors.genericobject.app.exception.MDFSQLException: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [***]:

Symptom

When trying to migrate to Talent intelligence Hub, but after performing JDM migration job  fails with an error:

"Runtime Exception,"UNKNOWN","Runtime exception while migration","FAILED","contextError={ com.successfactors.genericobject.app.exception.MDFSQLException: com.sap.db.jdbc.exceptions.BatchUpdateExceptionSapDB: [***]: transaction rolled back by lock wait timeout: TrexColumnUpdate failed on table '*****************_***********_*****_*' with error: transaction rolled back by lock wait timeout: Lock-wait time out exceeded [OWNER=***********, TYPE=RECORD_LOCK, CURRENT_MODE=NON_KEY_EXCLUSIVE, REQUESTED_MODE=NON_KEY_EXCLUSIVE], rc=***(input position -1) }, formatError={  }""  

Environment

  • SAP SuccessFactors Talent Intelligence Hub
  • SAP SuccessFactors Job Description Manager
  • SAP SuccessFactors Job Profile Builder

Reproducing the Issue

  1. Navigate to Admin Center > Tools > Scheduled Job Manager
  2. Select the Job Monitor tab
  3. In the Job Type dropdown, select JDM Old to New Sync
  4. Locate the failed job and select View Details
  5. Select Download Status
  6. Error is present in the file

Cause

Caused due to data issue in competencies .

Resolution

1. Clear the JDM check tool errors.

2. Run the JPB migration job.

Then clear any errors that arise. 

See Also

Keywords

Migrate , TIH , Talent Intelligence Hub , Job Profile Builder , Job Description Management , jpb , jdm, migrations , migrating , errors , cannot migrate , competencies , Job , Runtime Exception, UNKNOWN , FAILED , contextError , successfactors , transaction , rolled back , timeout , table  , Lock-wait time out exceeded , Lock , wait , time out , exceeded , OWNER , TYPE , CURRENT_MODE , REQUESTED_MODE , formatError , KBA , LOD-SF-TIH-JPB-MIG , Migration to Job Profile Builder , Problem

Product

SAP SuccessFactors HCM Core all versions