Configuration API Getting in Exceptions: Result Set Already Closed (Doc ID 2749155.1)

Last updated on FEBRUARY 08, 2021

Applies to:

Symptoms

On : 12.2.9 version, PLSQL API

When attempting to launch the Configurator Runtime using the jsp in 12.2.9, the following error occurs. The same jsp and setup worked as expected in 12.1.3. This particular process is only used for one model using the Fusion Engine.

The problem most often occurs immediately. There are times that the user can access the Runtime data and make selections. However, then it will error upon Finish generally.

ERROR
-----------------------
java.sql.SQLException: Result set already closed
  at weblogic.jdbc.wrapper.ResultSet.checkResultSet(ResultSet.java:144)
  at weblogic.jdbc.wrapper.ResultSet.preInvocationHandler(ResultSet.java:97)
  at weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.getInt(Unknown Source)
  at oracle.apps.cz.dio.DbRowCacheResultSet.getInt(DbRowCacheResultSet.java:202)
  at oracle.apps.cz.dio.rule.RuleController.loadSeededSignatures(RuleController.java:80)
  at oracle.apps.cz.dio.rule.RuleController.getJSPSignature(RuleController.java:100)
  at oracle.apps.cz.dio.rule.DbRule.getSignature(Unknown Source)
  at oracle.apps.cz.core.ExpressionEvaluator.evaluateJavaSignature(ExpressionEvaluator.java:225)
  at oracle.apps.cz.core.RuntimeNode.evaluateJavaSystemProperty(RuntimeNode.java:1727)
  at oracle.apps.cz.core.RuntimeNode.getJavaSysPropStringValue(RuntimeNode.java:1740)
  at oracle.apps.cz.core.RuntimeNode.evaluateDisplayName(RuntimeNode.java:1582)
  at oracle.apps.cz.core.RuntimeNode.getDisplayName(RuntimeNode.java:506)
  at oracle.apps.cz.core.ComponentInstance.setNameToDefault(ComponentInstance.java:138)
  at oracle.apps.cz.core.Port.reconcileInstances(Port.java:549)
  at oracle.apps.cz.core.Port.(Port.java:97)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch Runtime via jsp
2. Error generally occurs at rendering.

Changes

Cause

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