My Oracle Support Banner

Purging Large Data Fails with "java.sql.SQLException: java.sql.SQLException: Already closed" (Doc ID 2083607.1)

Last updated on AUGUST 19, 2022

Applies to:

Oracle API Gateway - Version and later
Information in this document applies to any platform.


While trying to purge the OAG audit database using the script per document Purging the Reports Database :

the bellow error is encountered:

Connecting to configuration at : federated:file:/<OAG HOME>/apigateway/conf/fed/configs.xml

Purging data older than: <TIMESTAMP>
Purging table: audit_log_sign... deleted 0 rows
Purging table: transaction_data... deleted 0 rows
Purging table: audit_message_payload...Traceback (most recent call last):
File "<OAG HOME>/apigateway/system/lib/jython/", line 139, in main()
File "<OAG HOME>/apigateway/system/lib/jython/", line 139, in main()
File "<OAG HOME>/apigateway/system/lib/jython/", line 135, in main
Purger.purge(connection, int(options.retain[0]), options.retain[1]);
at org.apache.commons.dbcp.PoolableConnection.close(
at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(
at com.vordel.reporting.maintenance.Purger.purge(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(

java.sql.SQLException: java.sql.SQLException: Already closed.


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

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