When the Update Item Substitute background job runs, the following error is displayed:
Error processing (Batch # 1) ERROR MESSAGE:(org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL ; SQL state [HY000]; error code ; SAP DBTech JDBC: : transaction rolled back by detected deadlock: search table error . . . .
SAP SuccessFactors Learning
Reproducing the Issue
1. Login to LMS
2. Go to System Admin > Background Jobs
3. Make the following Search criteria:
- Title (contains): substitute
- Status: Failed
4. Click on Search button
5. View the search result
The timeout background settings needs to be extended to avoid this issues moving forward.
Please raise an incident to Product Support so that Support can work with Operations team to set this configuration on the background.
A script to clear the job status may also be needed after the timeout settings is in place to be able to come out of the stuck job.
Update Item Substitute error, transaction rolled back by detected deadlock, Error processing (Batch # 1), ERROR MESSAGE:(org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation, Deadlock detected , KBA , LOD-SF-LMS-CON , Connectors , Problem