Demantra Solutions - EBS (MOSC)

MOSC Banner

Demantra workflow error Database internal error:ORA-29273: HTTP request failed

edited Jan 21, 2014 3:40AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered
Hi Expert,

CT workflow Run Engine failure, the error information as following, it occurs not every time, it is random, what is the  possible reason?

Process ID: 801901
Schema ID: 1313
Schema name: ’’Run Engine - XXXX’’
Step ID: ’’Step6’’
Step name: ’’RunLinuxFcst_Profile1’’

Error description ’’Database internal error:ORA-29273: HTTP request failed’’

And in Worksheet interface many times CT occurred following error:
2013-12-16 17:21:04,660 CST [DataRunner_4409] ERROR query.run: ODPM-70016: Error loading query from Application Server:org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object com.demantra.applicationServer.appServerExceptions.ApplicationServerException: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setQueryData(QueryDataHandler.java:292) at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setWorksheetData(QueryDataHandler.java:269) at com.demantra.applicationServer.services.queryrun.BaseQueryDataHandler.loadQueryData(BaseQueryDataHandler.java:140) at com.demantra.applicationServer.services.queryrun.QueryDataHandler.loadQueryData(QueryDataHandler.java:148) at com.demantra.applicationServer.services.queryrun.BaseDataRunner.loadQueryData(BaseDataRunner.java:85) at com.demantra.applicationServer.services.queryrun.BaseDataRunner.setData(BaseDataRunner.java:70) at com.demantra.applicationServer.services.queryrun.ExtendedDataRunner.run(ExtendedDataRunner.java:107) at java.lang.Thread.run(Thread.java:662) Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Timeout waiting for idle object at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:104) at com.demantra.applicationServer.pools.JDBCConnectionPool.getConnection(JDBCConnectionPool.java:260) at com.demantra.applicationServer.services.queryrun.StatementHandler.(StatementHandler.java:58) at com.demantra.applicationServer.services.queryrun.LoaderTask.(LoaderTask.java:58) at com.demantra.applicationServer.services.queryrun.LoaderTaskFactory.createQueueTask(LoaderTaskFactory.java:45) at com.demantra.common.queue.QueueTaskFactory.makeObject(QueueTaskFactory.java:29) at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:840) at com.demantra.applicationServer.services.queryrun.QueryDataLoader.loadData(QueryDataLoader.java:74) at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setQueryData(QueryDataHandler.java:287) at com.demantra.applicationServer.services.queryrun.QueryDataHandler.setWorksheetData(QueryDataHandler.java:269) at com.demantra.applicationServer.services.queryrun.BaseQueryDataHandler.loadQueryData(BaseQueryDataHandler.java:140) at com.demantra.applicationServer.services.queryrun.QueryDataHandler.loadQueryData(QueryDataHandler.java:148) at com.demantra.applicationServer.services.queryrun.BaseDataRunner.loadQueryData(BaseDataRunner.java:85) at com.demantra.applicationServer.services.queryrun.BaseDataRunner.setData(BaseDataRunner.java:71) ... 2 more Caused by:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center