REP-17273 : Java.sql.SQLException: Could Not Commit With Auto-Commit Set On
(Doc ID 2561391.1)
Last updated on MAY 17, 2023
Applies to:
Oracle Reports Developer - Version 12.2.1.4.0 and laterOracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Symptoms
Reports Job Repository is configured with Database 12.2.0.1 and the below exception occurs when running Reports in a High Availability (HA) environment.
rwserver_diagnostic.log
[WLS_REPORTS] [INCIDENT_ERROR] [REP-17273] [oracle.reports.server] [tid: 709] [userId: ] [ecid: <ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-17273 : java.sql.SQLException: Could not commit with auto-commit set on [[
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1016)
at oracle.reports.utility.DBConnection.handleSQLException(DBConnection.java:240)
at oracle.reports.server.BLOBHelper.removeJob(BLOBHelper.java:714)
at oracle.reports.server.JobStoreDB.writePersistFile(JobStoreDB.java:255)
at oracle.reports.server.JobManager.removeJob(JobManager.java:1846)
at oracle.reports.server.JobManager.limitQueueSize(JobManager.java:1797)
at oracle.reports.server.JobManager.manage(JobManager.java:244)
at oracle.reports.server.IdleThread.run(IdleThread.java:112)
[WLS_REPORTS] [INCIDENT_ERROR] [REP-50125] [oracle.reports.server] [tid: 1092] [userId: <anonymous>] [ecid: <ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-50125 : java.lang.NullPointerException [[
java.lang.NullPointerException
at oracle.reports.server.EngineManager.getIdleEngineIds(EngineManager.java:785)
at oracle.reports.server.JobManager.runCurrentJobs(JobManager.java:1077)
at oracle.reports.server.JobManager.manage(JobManager.java:270)
at oracle.reports.server.IdleThread.run(IdleThread.java:112)
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1016)
at oracle.reports.utility.DBConnection.handleSQLException(DBConnection.java:240)
at oracle.reports.server.BLOBHelper.removeJob(BLOBHelper.java:714)
at oracle.reports.server.JobStoreDB.writePersistFile(JobStoreDB.java:255)
at oracle.reports.server.JobManager.removeJob(JobManager.java:1846)
at oracle.reports.server.JobManager.limitQueueSize(JobManager.java:1797)
at oracle.reports.server.JobManager.manage(JobManager.java:244)
at oracle.reports.server.IdleThread.run(IdleThread.java:112)
[WLS_REPORTS] [INCIDENT_ERROR] [REP-50125] [oracle.reports.server] [tid: 1092] [userId: <anonymous>] [ecid: <ECID>] [APP: reports] [partition-name: DOMAIN] [tenant-name: GLOBAL] REP-50125 : java.lang.NullPointerException [[
java.lang.NullPointerException
at oracle.reports.server.EngineManager.getIdleEngineIds(EngineManager.java:785)
at oracle.reports.server.JobManager.runCurrentJobs(JobManager.java:1077)
at oracle.reports.server.JobManager.manage(JobManager.java:270)
at oracle.reports.server.IdleThread.run(IdleThread.java:112)
Changes
Configured Job Repository with 12cR2 database.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |