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 ONE Support launchpad (Login required).

Search for additional results

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