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: [***]:

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

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

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

Caused due to data issue in competencies .

1. Clear the JDM check tool errors.

2. Run the JPB migration job.

Then clear any errors that arise. 

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