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