Hi All,
when i start the Analytic Engine, in Analytic Error logs i can able to see below Error messages, and because of this my Dimension not available in KPI Hierarchies.
wM version is: 7.1.2
Analytic Engine: 7.1.2
OS : windows 2003 Server.
Database: Oracle 9i.
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: com.wm.dd.jdbc.base.BaseBatchUpdateException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “WEIGHT_FACT”: invalid identifier
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:42.459 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: com.wm.dd.jdbc.base.BaseBatchUpdateException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “PERSISTENCEQUAL_DIM”: invalid identifier
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 10:59:53.225 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: com.wm.dd.jdbc.base.BaseBatchUpdateException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “CONNECTION_STAT_FACT”: invalid identifier
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:03.272 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2009-11-30 11:00:13.632 IST ERROR: Aborting transaction due to exception