Symptom
When rehiring an employee an application error appears which prevents the rehire from completing.
You would receive an application error when rehiring an employee The application error id would be accompanied error: java.lang.IllegalStateException: org.hibernate.exception.GenericJDBCException: could not prepare statement
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
SAP SuccessFactors Employee Central
Reproducing the Issue
- Go to Rehire Inactive Employee
- Select inactive user for rehire
- Fill all required information
- Click Submit
- Application error appears preventing the rehire
- error: java.lang.IllegalStateException: org.hibernate.exception.GenericJDBCException: could not prepare statement
Internal log error:TIMEANDLABOR_JOB_INFO_TIME_ACCOUNT_SAVE_ERROR, time account
Cause
- An application error like this can appear when there is already a future posting for the users time account.
- The system will not be able to delete the absences or accrual which are already posted from time accounts.
- TIME_ACCOUNT_ALREADY_EXIST
Check: TIME_ACCOUNT_ALREADY_EXIST,
- Go to Manage data
- Time Account:
- Closed: NO
This indicates whether or not the account is already closed and can no longer be booked. Typically, time accounts are closed during period-end processing.
Resolution
The TIMEANDLABOR_JOB_INFO_TIME_ACCOUNT_SAVE_ERROR occurs when there is a future posting for a user's time account, preventing the rehire process from completing. To resolve this issue, check the existing time account for the affected user and delete it. After doing so, you can attempt the rehire again, and the error should no longer appear.
Employee Central Support Engineer Team Action:
- Please refer to Internal Memo : Splunk: session ID + Company ID + TimeAccount
Keywords
application error, rehire, hire date correction, TIMEANDLABOR_JOB_INFO_TIME_ACCOUNT_SAVE_ERROR, time account, error: java.lang.IllegalStateException: org.hibernate.exception.GenericJDBCException: could not prepare statement , BOOKING_PERIOD_CANNOT_BE_REDUCED_BY_SYSTEM_DEFAULT, Time Account , TimeAccountValidator ACCOUNT_CREATION , TIME_ACCOUNT_ALREADY_EXIST, timeAccount, externalCode, Error occurred when transitioning the workflow, rehire workflow, rehire , KBA , LOD-SF-EC-HIR-RIE , Rehire Inactive Employee , LOD-SF-EC-TIM-TA , Time Accounts (TAT, TA, TAD) , Problem
SAP Knowledge Base Article - Public