IS is not coming up

Hi All,

I formatted my pc and installed wM 7.1.2 version. When i am trying to server.bat, getting couple of exceptions. Have attached server.log

Please also observe, when i am running DB component configurator, i am getting below exception. Please help me to get rid of this issues

Error Snippet in DB component configurator:


  • Executing action
  • Action : create
  • Database : Oracle
  • Component : storage
  • Component version : latest
  • URL : jdbc:wm:oracle://localhost:1521;serviceName=xe
  • User : wmuser


  • create Database Component: Storage STR

  • Versions
  • Version: oracle 26 (7.1SP2Fix1)
  • Scripts create
    
  •   Script(1): C:\webMethods7.1.2\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
    
  •   Script(2): C:\webMethods7.1.2\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql
    

  • Executing script : C:\webMethods7.1.2\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
    

Error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

CREATE STORAGE [26] FAILED
CDC ERROR [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored


          Summary of installation errors

Error in executing file C:\webMethods7.1.2\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
SQL error [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored


      Database component configurator summary

Date : Tue Oct 22 20:00:32 IST 2013
Database : Oracle
User : wmuser
Action : create

Following components could not be installed:

Storage 26


server.log (34.9 KB)

DB_CREATE_FILE_DEST parameter needs to be set for the Oracle instance on which you are running the scripts.
Ask your DBA to do this.

Thanks,
Sreenivas

Hi Srinivas,

Its in my local system. Earlier it worked well but after re-installatioin of webMethods s/w i am facing this issue.

Thanks

Have you dropped DB schema earlier while uninstallation of webMethods?

if yes,

Make you sure you remove tablespace directory & rerun create scripts again

if not,

Schema’s still exists in database, it is not necessary to run scripts again. Error even says that table or view exists, i think you have dropped schema earlier

Hi RP,

Start with the beginning and re-run the db scripts after you made sure that DB side schema/account is clean for re-running the scripts.

HTH,
RMG

I did RMG as you specified, still had issue henceforth, i uninstalled and installed software and then it is working fine now.

Thanks all for your valuable inputs.

Thanks

make sense…always start with fresh mind:D

Dear Experts,

I am running into problems while running the database component configuration for wM 9.7 (free trial). I see below errors; I am using Oracle 11.2g express edition. I have browsed through internet and found that the below items needs to be done at the database

1> setting DB_CREATE_FILE_DEST
2> webMethods scripts require ALTER SESSION permission at the
time of creating database tables

[b]Script(1): \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

  • Script(2): \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_user.sql

  • Executing script : \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
    Error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
    PL/SQL: ORA-00942: table or view does not exist
    ORA-06550: line 5, column 9:
    PL/SQL: SQL Statement ignored
    ORA-06550: line 13, column 41:
    PL/SQL: ORA-00942: table or view does not exist
    ORA-06550: line 13, column 9:
    PL/SQL: SQL Statement ignored
    ORA-06550: line 21, column 41:
    PL/SQL: ORA-00942: table or view does not exist
    ORA-06550: line 21, column 9:
    PL/SQL: SQL Statement ignored

CREATE STORAGE [26] FAILED
CDC ERROR [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored

Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored


Summary of installation errors

Error in executing file \common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql
SQL error [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-06550: line 5, column 39:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 5, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 13, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 13, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 21, column 41:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 21, column 9:
PL/SQL: SQL Statement ignored


Following components could not be installed:

Storage 26
------------------------------------------------------------ [/b]