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

getting error in optimize predition engine log file

  • 1.  getting error in optimize predition engine log file

    Posted Thu June 24, 2010 03:52 PM

    hi All,

    am working webMethods 8.0.1 today while working on BPM, i have check the optimise predition engine log file showing below error.

    (OPTIMIZE) [Prediction Engine v8.0.0.0.RcfpStorageJdbc.UnknownKey] 2010-06-24 15:28:24.268 CEST ERROR: java.sql.SQLSyntaxErrorException: [wm-cjdbc40-0034][SQLServer JDBC Driver][SQLServer]Invalid column name ‘ProcessInstance_TXN’.
    at com.wm.dd.jdbc.sqlserverbase.BaseExceptions40.createAppropriateSQLExceptionInstance(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseExceptions40.createSQLException(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseExceptions.createException(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseExceptions.getException(Unknown Source)
    at com.wm.dd.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)
    at com.wm.dd.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)
    at com.wm.dd.jdbc.sqlserver.tds.TDSRPCRequest.processReplyToken(Unknown Source)
    at com.wm.dd.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
    at com.wm.dd.jdbc.sqlserver.SQLServerImplStatement.getNextResultType(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseStatement.commonTransitionToState(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseStatement.postImplExecute(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BasePreparedStatement.postImplExecute(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseStatement.commonExecute(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BaseStatement.executeQueryInternal(Unknown Source)
    at com.wm.dd.jdbc.sqlserverbase.BasePreparedStatement.executeQuery(Unknown Source)
    at com.webMethods.optimize.prediction.common.storage.rcfp.RcfpStorageJdbc.doProblemQueries(RcfpStorageJdbc.java:603)
    at com.webMethods.optimize.prediction.common.storage.rcfp.RcfpStorageJdbc.doBusinessProcessQueries(RcfpStorageJdbc.java:408)
    at com.webMethods.optimize.math.rcfp.RcfpPollingMC.doQueries(RcfpPollingMC.java:61)
    at com.webMethods.optimize.prediction.engine.rcfp.RcfpPollingTask.run(RcfpPollingTask.java:50)
    at java.util.TimerThread.mainLoop(Timer.java:512)
    at java.util.TimerThread.run(Timer.java:462)

    Regards,
    Anil kumar ellendula


    #webMethods
    #BPM
    #webMethods-BPMS


Related Content