Demantra workflow error Database internal error:ORA-29273: HTTP request failed
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: