IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Back to discussions
Expand all | Collapse all

analytic Engine throwing Errors in Error logs

  • 1.  analytic Engine throwing Errors in Error logs

    Posted Mon November 30, 2009 06:15 AM

    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


    #webMethods-BPMS
    #BPM
    #webMethods


  • 2.  RE: analytic Engine throwing Errors in Error logs

    Posted Mon December 21, 2009 04:47 PM

    Hi,

     check if in your AE schema table BAM_FACT_ANALYTI_V11 exists.

    greetings,

    phwm


    #webMethods-BPMS
    #webMethods
    #BPM


Related Content