My Oracle Support Banner

REP-17273 : Java.sql.SQLException: Could Not Commit With Auto-Commit Set On (Doc ID 2561391.1)

Last updated on JULY 11, 2019

Applies to:

Oracle Reports Developer - Version 12.2.1.0.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)

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.