The connector job is stuck in the "INIT - Started" status and an error seen in the connector logs for a particular user:
com.sap.db.jdbc.exceptions.SQLTransactionRollbackExceptionSapDB: : transaction rolled back by lock wait timeout: TrexUpdate failed on table 'YOUR_LEARNING_SCHEMA:PA_STUDENT' with error: transaction rolled back by lock wait timeout: Lock-wait time out exceeded
SAP SuccessFactors Learning
Reproducing the Issue
Run the connector and see that its "Status" is stuck in "INIT - Started" for hours, noting the above "Symptom" error in the logs.
Jobs or individual user transactions were stuck in connector node due to database issue.
Open a case with details of the connector runtime & affected user records to have the Database Operations team to address it.
COSD-22156 & INC1578779
sap, sf, lms, user, connector, stuck, INIT - Started, status, init, started, error, fail, view, log, logs, transaction, rolled, back, lock, wait, timeout , KBA , LOD-SF-LMS-CON , Connectors , LOD-SF-LMS , Learning Management System , Problem