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