Error While Running Interface In Demantra

(Doc ID 2259318.1)

Last updated on APRIL 26, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4.1 version, Technical

When attempting to load data using integration interface
the following error occurs.

ERROR
-----------------------
2017-04-24 16:06:51,022 AEST [WFProcess_0] ERROR integration.process:
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLException: Result set already closed
at com.demantra.applicationServer.nupdate.process.ImportDataJavaUpdate.update(ImportDataJavaUpdate.java:458)
at com.demantra.applicationServer.nupdate.process.ImportDataJavaUpdate.updateData(ImportDataJavaUpdate.java:188)
at com.demantra.applicationServer.nupdate.process.AbstractImportDataUpdate.execute(AbstractImportDataUpdate.java:246)
at com.demantra.applicationServer.metaDataObjects.transfer.profiles.QueryProfile.importProfile(QueryProfile.java:1164)
at com.demantra.applicationServer.metaDataObjects.transfer.profiles.IntegrationProfile.importData(IntegrationProfile.java:359)
at com.demantra.applicationServer.metaDataObjects.transfer.Transfer.importData(Transfer.java:503)
at com.demantra.workflow.step.TransferStep.doExecute(TransferStep.java:291)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:944)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:1281)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:662)
at java.lang.Thread.run(Thread.java:745)
Caused by: 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.getDate(Unknown Source)
at org.apache.commons.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:244)
at org.apache.commons.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:244)
at com.demantra.applicationServer.nupdate.process.ImportDataJavaUpdate.fillData(ImportDataJavaUpdate.java:566)
at com.demantra.applicationServer.nupdate.process.ImportDataJavaUpdate.update(ImportDataJavaUpdate.java:393)
... 10 more


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Workflow Manager.
2. Run an workflow with a transfer step.
3. It fails.


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms