SAP Knowledge Base Article - Public

3571732 - Data Import Job Failure in SAP SuccessFactors Time Tracking

Symptom

  • During the import of data, the job fails after approximately 2 hours.
  • The error messages displayed are "org.hibernate.HibernateException: Transaction was rolled back in a different thread!" and "javax.persistence.PersistenceException: org.hibernate.HibernateException: Transaction was rolled back in a different thread!".

Environment

  • SAP SuccessFactors Time Tracking

Reproducing the Issue

  1. Navigate to Import and Export Data.
  2. Select the option to import data.
  3. Choose the Employee Time object for import.
  4. Add the file for import.
  5. Either validate or import the file.

Resolution

  1. Navigate to Import and Export Data.
  2. Select Import Config.
  3. Input Batch Size field, enter 50.
  4. Save the changes.
  5. Test the import again with the adjusted batch size.
  6. If the error persists, consider reducing the number of records per import file to a maximum of 500 as per best practices.

Keywords

SAP SuccessFactors, Time Tracking, Data Import, Job Failure, org.hibernate, Transaction was rolled back, javax.persistence, Import and Export Data, Batch Size. , KBA , LOD-SF-EC-TIM-ABS , Absence error's - Calculations, Deductions, TT&ET , Problem

Product

SAP SuccessFactors Time Tracking all versions