My Oracle Support Banner

Enterprise Command Center (ECC) 'Payables Command Center Data Load' Getting Stuck for AP Module (- DataSet ap-trx) (Doc ID 3025404.1)

Last updated on SEPTEMBER 20, 2024

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.11 and later
Information in this document applies to any platform.

Symptoms


On a recently deployed environment, the Enterprise Command Center (ECC) Full Data Load appears to be stuck for AP module, more specifically on the ap-trx dataset.
The sqlplans and logs for this specific ap-trx load do not seem to be written until this task completes or fails, but that is going on for a very long time and does not complete. As a result, the Admin team was cancelling that - but when retrying, the same behavior would be seen.

Errors seen in the logs (ecc-web-2024-04-16.log - from $ECC_BASE/Oracle/quickInstall/log ) - were rather for the connection closed as result of cancelling the long running tasks:

2024-04-16 00:43:31.842 [pool-14-thread-2] ERROR o.e.i.u.s.i.DataLoadControllerServiceImpl$ActionWrapper - ## SQL Plan Generation ## --> Exception while fetching the session id for audit request 20294
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.createClob(PhysicalConnection.java:7317) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.OracleConnectionWrapper.createClob(OracleConnectionWrapper.java:1355) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.PooledConnection.createClob(PooledConnection.java:862) ~[com.bea.core.datasource6.jar:12.2.1.4]
at weblogic.jdbc.wrapper.Connection.createClob(Connection.java:1156) ~[com.bea.core.datasource6.jar:12.2.1.4]
at oracle.ecc.index.update.services.impl.SQLPlanGeneratorServiceImpl.generateQuerySessionDtls(SQLPlanGeneratorServiceImpl.java:181) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.SQLPlanGeneratorServiceImpl.getSqlPlanRS(SQLPlanGeneratorServiceImpl.java:153) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.SQLPlanGeneratorServiceImpl.generateSQLPlanStatisticsRS(SQLPlanGeneratorServiceImpl.java:808) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl$ActionWrapper.generateInterimSQLPlanStatistics(DataLoadControllerServiceImpl.java:2697) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl$ActionWrapper.lambda$addJoinPoint$0(DataLoadControllerServiceImpl.java:2668) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_381]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_381]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_381]
at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_381]
...

2024-04-16 11:13:32.865 [pool-14-thread-2] ERROR o.e.i.u.s.i.DataLoadControllerServiceImpl$ActionWrapper - ## SQL Plan Generation ## --> Exception while fetching the session id for audit request 20294
java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.createClob(PhysicalConnection.java:7317) ~[ojdbc8.jar:19.3.0.0.0]
at oracle.jdbc.OracleConnectionWrapper.createClob(OracleConnectionWrapper.java:1355) ~[ojdbc8.jar:19.3.0.0.0]
at weblogic.jdbc.wrapper.PooledConnection.createClob(PooledConnection.java:862) ~[com.bea.core.datasource6.jar:12.2.1.4]
at weblogic.jdbc.wrapper.Connection.createClob(Connection.java:1156) ~[com.bea.core.datasource6.jar: 12.2.1.4 ]
at oracle.ecc.index.update.services.impl.SQLPlanGeneratorServiceImpl.generateQuerySessionDtls(SQLPlanGeneratorServiceImpl.java:181) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.SQLPlanGeneratorServiceImpl.getSqlPlanRS(SQLPlanGeneratorServiceImpl.java:153) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.SQLPlanGeneratorServiceImpl.generateSQLPlanStatisticsRS(SQLPlanGeneratorServiceImpl.java:808) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl$ActionWrapper.generateInterimSQLPlanStatistics(DataLoadControllerServiceImpl.java:2697) [ecc-ir-1.0.0.jar:na]
at oracle.ecc.index.update.services.impl.DataLoadControllerServiceImpl$ActionWrapper.lambda$addJoinPoint$0(DataLoadControllerServiceImpl.java:2668) [ecc-ir-1.0.0.jar:na]
at java.util.concurrent.CompletableFuture$AsyncRun.run(CompletableFuture.java:1640) ~[na:1.8.0_381]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[na:1.8.0_381]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[na:1.8.0_381]
at java.lang.Thread.run(Thread.java:750) ~[na:1.8.0_381]

...



The steps to replicate the issue would be:

1. Complete and validate the ECC setup as per "Installing Oracle Enterprise Command Center Framework, Release 12.2 V11 (Doc ID 2991097.1)" ;
2. Start the Full Data Load jobs for that specific AP module (either from EBS - Concurrent Programs or for troubleshooting purpose from ECC Developer page);
3. Monitor and check the results / logs of the tasks started.


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
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.