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.