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
- Navigate to Admin Center > Tools > Scheduled Job Manager
- Select the Job Monitor tab
- In the Job Type dropdown, select JDM Old to New Sync
- Locate the failed job and select View Details
- Select Download Status
- 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
- Implementing and Managing Job Profile Builder - Migrating from Job Description Manager to Job Profile Builder
- Using Check Tool for Job Description Manager and Job Profile Builder
- Implementing and Managing Job Profile Builder - Importing New Job Profile Content Using Manage Job Profile Content Import/Export
- Checks for Job Profile Builder
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