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

1 Like

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]