SAP Knowledge Base Article - Preview

2351618 - SQLException: Could not commit/rollback with auto-commit set on - SAP EIS

Symptom

A SAP Enterprise Inventory and Service-Level Optimization (EIS) model fails, and the following error messages are reported in the application log:

  • Caused by: com.sap.sql.exception.OpenSQLException: Could not commit with auto-commit set on
  • Caused by: java.sql.SQLException: Could not commit with auto-commit set on

 OR

  • Caused by: java.sql.SQLException: Could not rollback with auto-commit set on

 OR

  • EDT ERROR DataLoaderGatewayWorkerThread com.smartops.demand_intelligence.core.DimComputationTask execute Connection object com.sap.sql.jdbc.direct.DirectConnection@38f2d4bc has already been closed because of a fatal connection error.
    com.sap.sql.log.OpenSQLException: Connection object com.sap.sql.jdbc.direct.DirectConnection@38f2d4bc has already been closed because of a fatal connection error.
    at com.sap.sql.log.Syslog.createAndLogOpenSQLException(Syslog.java:83)


Read more...

Environment

  • SAP Enterprise Inventory and Service-Level Optimization (EIS).
  • Oracle 12c.

Product

SAP Enterprise Inventory and Service-Level Optimization all versions

Keywords

SmartOps, EIS, EIO, MIPO, Oracle 12c, jdbc, autocommit, opensql, sql, dim, directconnection, connection, direct, load, failed, database , KBA , 12 , SCM-EIS , SAP Enterprise Inventory and Service-Level Optimization , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.