getting JDBC Error in Analytic engine

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.JMSCommunication.jmsEventSendErrorQueueNoProp] 2010-03-02 18:02:14.747 CET ERROR: java.lang.RuntimeException: java.lang.Exception: Maximum message producer create attempts exhausted
(OPTIMIZE) [Analytic Engine v8.0.0.0.JMSCommunication.jmsEventSendErrorQueueNoProp] 2010-03-02 18:02:14.747 CET ERROR: at com.webmethods.optimize.service.external.comm.JMSCommunication$DestinationPublisher.send(JMSCommunication.java:544)
(OPTIMIZE) [Analytic Engine v8.0.0.0.JMSCommunication.jmsEventSendErrorQueueNoProp] 2010-03-02 18:02:14.747 CET ERROR: wraps: java.lang.Exception: Maximum message producer create attempts exhausted
(OPTIMIZE) [Analytic Engine v8.0.0.0.JMSCommunication.jmsEventSendErrorQueueNoProp] 2010-03-02 18:02:14.747 CET ERROR: at com.webmethods.optimize.service.external.comm.JMSCommunication$DestinationPublisher.send(JMSCommunication.java:544)
(OPTIMIZE) [Analytic Engine v8.0.0.0.JMSCommunication.jmsEventSendErrorQueueNoProp] 2010-03-02 18:02:14.747 CET ERROR: wraps: javax.jms.IllegalStateException: [BRM.10.1204] JMS: Connection is closed.
at com.webmethods.jms.impl.WmConnectionImpl.checkState(WmConnectionImpl.java:1230)
at com.webmethods.jms.impl.WmConnectionImpl.createSession(WmConnectionImpl.java:324)
at com.webmethods.optimize.service.external.comm.JMSCommunication$DestinationPublisher.createMessageProducer(JMSCommunication.java:622)
at com.webmethods.optimize.service.external.comm.JMSCommunication$DestinationPublisher.send(JMSCommunication.java:538)
at com.webmethods.optimize.service.external.comm.JMSCommunication$DestinationPublisher.access$200(JMSCommunication.java:504)
at com.webmethods.optimize.service.external.comm.JMSCommunication.doSend(JMSCommunication.java:266)
at com.webmethods.optimize.service.external.comm.JMSCommunication.send(JMSCommunication.java:245)
at com.webmethods.optimize.service.external.comm.JMSCommunication.run(JMSCommunication.java:445)
at java.lang.Thread.run(Thread.java:619)
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:25.169 CET ERROR: Timed out attempting to get database connection for process.work
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:25.169 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.StatementManager.open(StatementManager.java:128)
at com.webmethods.bpo.process.processtracker.TransitionAnalyzerTask.analyzeCompletedInstances(TransitionAnalyzerTask.java:287)
at com.webmethods.bpo.process.processtracker.TimeoutAnalyzer.run(TimeoutAnalyzer.java:285)
at com.webmethods.bpo.process.processtracker.ProcessTracker$TaskExecutionTrigger.runTask(ProcessTracker.java:185)
at com.webmethods.bpo.process.processtracker.ProcessTracker$TaskExecutionTrigger.run(ProcessTracker.java:174)
at java.util.TimerThread.mainLoop(Timer.java:512)
at java.util.TimerThread.run(Timer.java:462)
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:25.169 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:

  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:28.982 CET ERROR: Timed out attempting to get database connection for process.work
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:28.982 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.StatementManager.open(StatementManager.java:128)
    at com.webmethods.bpo.process.processtracker.StagingDataProcessorTask2.processStagingData(StagingDataProcessorTask2.java:187)
    at com.webmethods.bpo.process.processtracker.StagingDataProcessorTask2.run(StagingDataProcessorTask2.java:156)
    at java.lang.Thread.run(Thread.java:619)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:28.997 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:29.216 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:29.216 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.optimize.datamodel.common.DimensionTemporaryStorage.getTempDimensions(DimensionTemporaryStorage.java:93)
    at com.webmethods.optimize.datamodel.common.DimensionTemporaryStorage.getTempDimensions(DimensionTemporaryStorage.java:83)
    at com.webmethods.optimize.datamodel.engine.TemporaryDimensionHandler.process(TemporaryDimensionHandler.java:150)
    at com.webmethods.optimize.datamodel.engine.TemporaryDimensionHandler.processTemporaryDimensions(TemporaryDimensionHandler.java:98)
    at com.webmethods.optimize.datamodel.engine.DimensionBuffer$DimTempTimerTask.run(DimensionBuffer.java:378)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:29.216 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:36.91 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:36.91 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.SCGConnectionManager.getConnection(SCGConnectionManager.java:306)
    at com.webmethods.optimize.kpi.common.KPIStorageGeneric.updateLastKPIReading(KPIStorageGeneric.java:252)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.updateLastKPIReading(KPIAggregator.java:1117)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.processBufferedKPI(KPIAggregator.java:1547)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.processBufferedKPIs(KPIAggregator.java:1498)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.aggregateEventsToKpis(KPIAggregator.java:1026)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.run(KPIAggregator.java:1647)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
    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)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:36.91 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:36.91 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:36.91 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.TransactionWrapper.run(TransactionWrapper.java:49)
    at com.webmethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:79)
    at com.webmethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:250)
    at com.webmethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:225)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:36.91 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:36.91 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:36.91 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.TransactionWrapper.run(TransactionWrapper.java:49)
    at com.webmethods.optimize.monitor.common.MonitorDataAccess$1.run(MonitorDataAccess.java:107)
    at java.lang.Thread.run(Thread.java:619)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:36.91 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:36.91 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:36.91 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.optimize.improve.RuleComplianceAggregator.run(RuleComplianceAggregator.java:157)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:36.91 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:36.91 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:36.91 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.SCGConnectionManager.getConnection(SCGConnectionManager.java:306)
    at com.webmethods.optimize.kpi.common.KPIStorageGeneric.updateLastKPIReading(KPIStorageGeneric.java:252)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.updateLastKPIReading(KPIAggregator.java:1117)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.processBufferedKPI(KPIAggregator.java:1547)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.processBufferedKPIs(KPIAggregator.java:1498)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.aggregateEventsToKpis(KPIAggregator.java:1026)
    at com.webmethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.run(KPIAggregator.java:1647)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
    at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
    at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
    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)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:36.91 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-02 18:02:36.91 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:36.91 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.optimize.monitor.engine.StatsEngine.createStatsAccess(StatsEngine.java:416)
    at com.webmethods.optimize.monitor.engine.StatsEngine.getWeakStatsForInterval(StatsEngine.java:512)
    at com.webmethods.optimize.monitor.engine.StatsEngine.getStatsForInterval(StatsEngine.java:368)
    at com.webmethods.optimize.monitor.engine.StatsEngine.getWeakStats(StatsEngine.java:637)
    at com.webmethods.optimize.monitor.engine.Diagnostics.addReading(Diagnostics.java:65)
    at com.webmethods.optimize.monitor.engine.AnalysisMonitor.addReading(AnalysisMonitor.java:144)
    at com.webmethods.optimize.monitor.engine.MonitorRepository.addReading(MonitorRepository.java:517)
    at com.webmethods.optimize.monitor.engine.MonitorRepository.access$300(MonitorRepository.java:80)
    at com.webmethods.optimize.monitor.engine.MonitorRepository$AddReadingTask.run(MonitorRepository.java:419)
    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)
    (OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-02 18:02:36.91 CET ERROR: Connection pool exhausted: listing all objects holding a handle to a connection:
  • [Process Tracker] Task execution timer
  • Reporting Update
  • Rule Compliance Aggregator
    (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