Problem with Modeler/Monitor in BAM

, ,
1

Hello Experts,

I am using wM6.5 version, while I am installing BAM I am facing a problem with Modeler/Monitor, I have done all the necessary configurations related to database(Oracle9i)… I have run all the scripts from \webMethods65\common\db\scripts\create directory, also i have created/inserted/updated tables for all database components(analysis,process audit, etc…) and also configured my JDBC Pool in IS.

Now while I start my IS it throws an exceptions in log saying

“…[MON.0119.0917E] Failure in migration from 6.0.1 to 6.1: java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist…”

and

“…[MOD.0120.0000D] java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist…”

and

“…[MON.0119.0917E] Failure in migration from 6.0.1 to 6.1: com.wm.monitor.util.MonitorException: [wm.monitor.admin:checkMigrationState] java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist
com.wm.monitor.util.MonitorException: [wm.monitor.admin:checkMigrationState] java.sql.SQLException: [wm-cjdbc34-0042][Oracle JDBC Driver][Oracle]ORA-00942: table or view does not exist…”

I find all my database scripts are of 6.5 versions.

I’ve even gone through the documents (in webMethods directory) in which it says…

1.create_reporting_6-5_database.sql
2.create_staging_6-5_database.sql
3.populate_reporting_6-5_database.sql
4.populate_staging_6-5_database.sql
5.drop_reporting_6-5_database.sql
6.drop_staging_6-5_database.sql

In which I could found the first 3 scripts available in my webMethods directory and i could’nt findout the ‘populate_staging_6-5_database.sql’ script in my directory.

My questions are…

(1). Is ‘populate_staging_6-5_database.sql’ script required?? If required then where can i find it??

(2). My scripts are all of 6.5 version and why i am getting an exception in IS and if migration is required then where can i find out the migration scripts, as there are no migration scripts for the same??

(3). Why and when are ‘drop_reporting_6-5_database.sql’ and ‘drop_staging_6-5_database.sql’ scripts required?

Any suggestions will be grately helpful,

Thanks in Advance,
raffim

2

So what is the reason for this annoying exception at startup? Actually the monitoring functionality is not impacted as it works in MyWebMethods, but I like to have clean from errors server log.