SAP Knowledge Base Article - Public

2700634 - Connector failure error connection closed

Symptom

When viewing connector error logs the following fail error can be seen:

org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is java.sql.SQLException: The connection is closed: The connection is closed

Environment

SAP SuccessFactors Learning Management System (LMS)

Reproducing the Issue

Schedule a connector to run when no feed file is present in the targeted location

Cause

When no feed file is present at the scheduled connector run, the logs will show this failure and error.

Resolution

  • This error can be safely ignored as it has no impact other that the failure message within the connector logs and any corresponding connector results report. 
  • Can also ensure the connector is only scheduled to run when a feed file is known to be present if applicable.
  • An enhancement in LRN-41519 is scheduled currently targeted for 1902 to simply not show this message to avoid confusion.

See Also

2375888 - How to avoid LMS Connector connection and performance issues

Keywords

SAP SF LMS Learning success factors connector connectors user error fail failure closed connection Could not roll back JDBC transaction; transaction nested exception , KBA , LOD-SF-LMS-CON , Connectors , Problem

Product

SAP SuccessFactors Learning all versions