Hi ,

I am trying to create a simple KPI which calculates averageSalary of employeesbased on the Region.I created a Process and logged the salary and Region field and uploaded the process. Then I ran 2-3 instances of that process and craeted an Event map for that and defined Dimensions,facts and Hierarchies etc… Then I created a KPI and deployed the EventMap created for that process successfully.

Then I added the process and KPI under Administrator->Business->BusinessOverview link. after that I fired around 15 instances of that process and i could see all the instances under Monitoring->Business->PocessInstances.

But i could not my any KPI inside Monitoring->Business->BuisnessOverview.

I could see only systen generated KPIs not the one defined by me i.e. ‘AvgSalaryByRegion’…

can anyone please help me…?

Did i miss anything…?

I can’t find any error in your steps. Just to check, in your EventMap can you see any unassociated? I had a similar problem and appears an unassociated, then I associated that event and created the KPI inside this, then works.
Regards.

Yes, I could saw unassociated and associated it with Event map and created KPI inside that…but still not able to see under MWS->Monitoring screen

If you not forgot deploy the event is very strange. This is the kind of problem make us crazy. Let me think (I’m tired now) If something smart appear in my mind I’ll tell you. Anyway, take it easy, in this forum we have too many people to can help.

Please, chek if in your dimension you have defined the same field that you want to messure and that field is inside the publishable document of your process.

That field must be defined in your Designer too check in “Properties>Logged Fields”

Hi I am doing everyhting whatever you are telling…

I am getting folowing error in Analytical Engine Log file:-

(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: Unable to perform query: sql: SELECT BAM_FACT_ANALYTI_V1.Weight_FACT, ‘1’ AS Weight_FACT_INTERVAL, ‘1’ AS Weight_FACT_COUNT,BAM_DIM_ANALYTI_V1.LogicalServerName_COL AS BAM_DIM_ANALYTI_V1_Analyt,BAM_DIM_ANALYTI_V1.BAM_DIM_ANALYTI_V1_id,BAM_FACT_ANALYTI_V1.entry_time AS TIME,BAM_DIM_INTERNA_V1.Name_COL AS BAM_DIM_INTERNA_V1_Intern,BAM_DIM_INTERNA_V1.BAM_DIM_INTERNA_V1_id FROM BAM_DIM_INTERNA_V1,BAM_FACT_ANALYTI_V1,BAM_DIM_ANALYTI_V1 WHERE BAM_FACT_ANALYTI_V1.Analytic_Engine_DIM = BAM_DIM_ANALYTI_V1.BAM_DIM_ANALYTI_V1_id AND BAM_FACT_ANALYTI_V1.InternalMonitor_DIM = BAM_DIM_INTERNA_V1.BAM_DIM_INTERNA_V1_id AND BAM_FACT_ANALYTI_V1.ENTRY_TIME < ? AND BAM_FACT_ANALYTI_V1.ENTRY_TIME >= ?, bind variables: [1283884200000, 1283883900000] for EventQuery{dimensionalPath=HierarchySetting{dimensionName=‘InternalMonitorQualifier’, dimensionVersion=1, dimensionAttributeName=‘Name’, children=‘[HierarchySetting{dimensionName=‘AnalyticEngine’, dimensionVersion=1, dimensionAttributeName=‘LogicalServerName’, children=’‘, left=‘null’}]’, left=‘null’}, queryInterval=QueryTime{startDate=Tue Sep 07 23:55:00 IST 2010, endDate=Wed Sep 08 00:00:00 IST 2010, aggregate=true, interval=300000}, queryables=[Weight], queryFilters=, aggregation support=NONE}
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00904: “BAM_FACT_ANALYTI_V1”.“WEIGHT_FACT”: invalid identifier
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.wm.dd.jdbc.base.BaseExceptions.createException(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.wm.dd.jdbc.base.BaseExceptions.getException(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.wm.dd.jdbc.oracle.OracleImplStatement.execute(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.commonExecute(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeQueryInternal(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeQuery(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.event.query.Query.getSliceGrid(Query.java:92)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.event.query.Query.getSliceGrid(Query.java:66)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.common.WarehouseQueryNode.query(WarehouseQueryNode.java:30)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.common.KPIQuery.getAggregateResults(KPIQuery.java:167)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.engine.KPIQueryManager.query(KPIQueryManager.java:29)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.processDBQueryKPIs(KPIAggregator.java:854)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.generateMonitors(KPIAggregator.java:638)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.engine.KPIAggregator$KPIAggregatorState.markEventQueue(KPIAggregator.java:472)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at com.webMethods.optimize.kpi.engine.KPIAggregator$KPIProcessor.run(KPIAggregator.java:1030)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at java.util.TimerThread.mainLoop(Timer.java:512)
(OPTIMIZE) [Analytic Engine v7.1.2.0.Query.UnknownKey] 2010-09-08 00:00:40.115 IST ERROR: at java.util.TimerThread.run(Timer.java:462)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 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] 2010-09-08 00:00:45.418 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:45.418 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 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] 2010-09-08 00:00:55.436 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:00:55.436 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 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] 2010-09-08 00:01:05.460 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:05.460 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 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] 2010-09-08 00:01:15.552 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:15.552 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 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] 2010-09-08 00:01:25.578 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:25.578 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 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] 2010-09-08 00:01:35.600 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:35.600 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 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] 2010-09-08 00:01:45.699 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:45.699 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 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] 2010-09-08 00:01:55.715 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:01:55.715 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: Aborting transaction due to exception
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 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] 2010-09-08 00:02:05.732 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeOneStatementAtATime(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.wm.dd.jdbc.base.BaseStatement.executeBatchEmulation(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.wm.dd.jdbc.base.BasePreparedStatement.executeBatch(Unknown Source)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage$EventBatch.execute(EventInstanceStorage.java:404)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.webMethods.bpo.database.TransactionWrapper.run(TransactionWrapper.java:64)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.webMethods.optimize.event.engine.EventInstanceStorage.writeBatch(EventInstanceStorage.java:75)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.writeEvents(EventWriter.java:231)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:05.732 IST ERROR: at com.webMethods.optimize.event.engine.EventWriter$EventWriterThread.run(EventWriter.java:206)
(OPTIMIZE) [Analytic Engine v7.1.2.0.TransactionWrapper.UnknownKey] 2010-09-08 00:02:15.842 IST ERROR: Aborting transaction due to exception

Could it be the reason of my issue?

I never seen this error before… looks like a database problem but I´m sorry, I can´t help. Maybe trying recreating the ProcessAudit database with the Database Configurator Manager but this will erase el process in your MWS.

Regards.

I am also facing some issue related to BAM_DIM_ANALYTI_V1. But I do not have this table in db at all nor script, can anybody send me the script to generate this table?