Geting JDBC Connection Pool exception In analytic engine.

, ,
1

Hi All,

i have sucessfully connected database pool and assigne anlatic engines in Define environment about one month back, today i am getting below errror, i have database connction pool and tested database connection it is sucessfully connected, please help me on this.

(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:55.310 CET ERROR: Timed out attempting to get database connection for analysis.engine
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:55.310 CET ERROR: java.sql.SQLException: Connection unavailable
at com.webMethods.sc.database.jdbcpools.alias.JDBCPortableAlias.getConnection(JDBCPortableAlias.java:70)
at com.webMethods.bpo.database.SCGConnectionManager.getConnection(SCGConnectionManager.java:252)
at com.webMethods.bpo.database.BaseStorage.getConnection(BaseStorage.java:33)
at com.webMethods.optimize.timedims.TimeDimStorageJdbcImpl.locateId(TimeDimStorageJdbcImpl.java:150)
at com.webMethods.optimize.timedims.TimeDimStorageJdbcImpl.locateId(TimeDimStorageJdbcImpl.java:125)
at com.webMethods.optimize.event.engine.EventPersistenceBufferTransformer.getTimeFK(EventPersistenceBufferTransformer.java:169)
at com.webMethods.optimize.event.engine.EventPersistenceBufferTransformer.populateForeignKeys(EventPersistenceBufferTransformer.java:206)
at com.webMethods.optimize.event.engine.EventPersistenceBufferTransformer.addEvent(EventPersistenceBufferTransformer.java:98)
at com.webMethods.optimize.core.AbstractEventProvider.addMappedEvent(AbstractEventProvider.java:119)
at com.webMethods.optimize.event.engine.EventMapper.addStructAttribute(EventMapper.java:70)
at com.webMethods.optimize.event.engine.EventMapper.addEvent(EventMapper.java:173)
at com.webMethods.optimize.core.AbstractEventProvider.addDCAEvent(AbstractEventProvider.java:113)
at com.webMethods.optimize.event.engine.EventStackAdapter.access$100(EventStackAdapter.java:34)
at com.webMethods.optimize.event.engine.EventStackAdapter$AddEventTask.run(EventStackAdapter.java:109)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

regards,
anil kumar e

2

Hi,

restart the ProcessAudit, ProcessEngine… in JDBC pools connection/Functional Alias Definitions.

thanks,
Vinod Kumar Ksheersagar

3

Hi Anil,

have you resolved the issue?

even i faced similar Error in nalytic Engine, and i resolved it.

if u need any more help let me know.

thanks,
vinod kumar Ksheersagar