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 an error in prediction engine

  • 1.  getting an error in prediction engine

    Posted Thu March 04, 2010 08:04 AM

    hi all,

    today am getting below error in prediction engine, below is error in error.log file

    (OPTIMIZE) [Optimize Prediction Services.RcfpStorageJdbc.UnknownKey] 2010-03-04 01:22:56.790 CET 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)
    (OPTIMIZE) [Optimize Prediction Services.RcfpStorageJdbc.UnknownKey] 2010-03-04 02:22:56.798 CET ERROR: RCFPStorageJdbc.doErrorQueries() exception

    please help me to solve this issue.

    regards,
    anil kumar e


    #webMethods
    #webMethods-BPMS
    #BPM


Related Content