hi all,
today am keep on getting below error in analytic engine. see eror taken error.log file, my database connection databasePool(MWS) is working
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-03 14:14:34.684 CET ERROR: Timed out attempting to get database connection for analysis.engine
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.UnknownKey] 2010-03-03 14:14:34.684 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.jobmanager.JobStorageImpl.getJobsToExecute(JobStorageImpl.java:872)
at com.webMethods.optimize.jobmanager.LoadJobDetailsCommand.execute(LoadJobDetailsCommand.java:16)
at com.webMethods.optimize.jobmanager.JobManagerImpl$CommandProcessingThread.run(JobManagerImpl.java:656)
(OPTIMIZE) [Analytic Engine v8.0.0.0.SCGConnectionManager.scPoolAdaptConnectPoolExhaust] 2010-03-03 14:14:34.684 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.JMSCommunication.jmsEventSendErrorQueueNoProp] 2010-03-03 14:14:41.934 CET ERROR: Queuing events [MonitorChange{monitor=Monitor{monitorId=34, kpiName=Queue Size by Queue, monitorDimensions=[MonitorDimension{dimensionName=‘Queue’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Monitor Readings’}, MonitorDimension{dimensionName=‘InternalMonitorQualifier’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Analytic Engine Internal Queues’}, MonitorDimension{dimensionName=‘AnalyticEngine’, dimensionVersion=1, dimensionAttribute=‘LogicalServerName’, dimensionValue=‘Analytic Engine v8.0.0.0’}], dimensionIDs={Queue=[8], InternalMonitorQualifier=[3], AnalyticEngine=[1]}}, monitorChangeType=add}, MonitorChange{monitor=Monitor{monitorId=32, kpiName=Queue Size by Queue, monitorDimensions=[MonitorDimension{dimensionName=‘Queue’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Process Events’}, MonitorDimension{dimensionName=‘InternalMonitorQualifier’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Analytic Engine Internal Queues’}, MonitorDimension{dimensionName=‘AnalyticEngine’, dimensionVersion=1, dimensionAttribute=‘LogicalServerName’, dimensionValue=‘Analytic Engine v8.0.0.0’}], dimensionIDs={Queue=[7], InternalMonitorQualifier=[3], AnalyticEngine=[1]}}, monitorChangeType=add}, MonitorChange{monitor=Monitor{monitorId=20, kpiName=Queue Size by Queue, monitorDimensions=[MonitorDimension{dimensionName=‘Queue’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Dimensions’}, MonitorDimension{dimensionName=‘InternalMonitorQualifier’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Analytic Engine Internal Queues’}, MonitorDimension{dimensionName=‘AnalyticEngine’, dimensionVersion=1, dimensionAttribute=‘LogicalServerName’, dimensionValue=‘Analytic Engine v8.0.0.0’}], dimensionIDs={Queue=[1], InternalMonitorQualifier=[3], AnalyticEngine=[1]}}, monitorChangeType=add}, MonitorChange{monitor=Monitor{monitorId=22, kpiName=Queue Size by Queue, monitorDimensions=[MonitorDimension{dimensionName=‘Queue’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Events’}, MonitorDimension{dimensionName=‘InternalMonitorQualifier’, dimensionVersion=1, dimensionAttribute=‘Name’, dimensionValue=‘Analytic Engine Internal Queues’}, MonitorDimension{dimensionName=‘AnalyticEngine’, dimensionVersion=1,
regards,
anil kumar e