Analytic Engine stops with StorageRuntimeException

, ,
1

Hi,

We have O4I not working Properly as Analytic Engine falling over. The AE shuts down in 20 minutes with the Exception “StorageRuntimeException:The connection pool has been shutdown: analysis.engine”. But actually there is no problem with the DB and the test connection also successful.
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: Unexpected TimerTask death
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: com.webMethods.bpo.database.StorageRuntimeException: The connection pool has been shutdown: analysis.engine
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: at com.webMethods.bpo.database.SCGConnectionManager.getConnection(SCGConnectionManager.java:184)
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: at com.webMethods.optimize.rules.common.RuleAbstractionLayer.getNumberOfInstancesForRule(RuleAbstractionLayer.java:973)
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: at com.webMethods.optimize.core.MetadataExplorer$UpdateWeightsTask.run(MetadataExplorer.java:446)
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: at java.util.TimerThread.mainLoop(Timer.java:512)
(OPTIMIZE) [Analytic Engine v7.1.2.0.MetadataExplorer$UpdateWeightsTask.UnknownKey] 2012-12-28 05:01:35.792 GMT ERROR: at java.util.TimerThread.run(Timer.java:462)

Any help on this would be really great.

Thanks
RamGopal

2

Are you facing this problem in a fresh installation or older one which was running fine?

Try killing the AE server, and restart it, and see if the ports are in LISTEN state.

Create all optimize related tables on a schema/user. This includes process tracker, operation management etc.,
From MWS, ‘Define Environment’ and deploy it
AE details should be mentioned in WmOptimize package
Optimize broker url should be mentioned in WmPRT package

HTH
-Senthil