Error when I try to run Database component configurator

, ,
1

Hi All,

Am getting the below error when i try to run Database component configurator:

  • Executing action
  • Action : create
  • Database : Oracle
  • Component : storage
  • Component version : latest
  • URL : jdbc:wm:oracle://localhost:1521;serviceName=XE
  • User : system
  • create Database Component: Storage STR
  • Versions
  • Version: oracle 25 (7.0SP2)
  • Scripts create

  •   Script(1): C:\webMethods7\common\db/scripts/oracle/storage/25/create/ora_str_c_ddl_tablespaces.sql

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

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

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

CREATE STORAGE [25] SUCCESSFUL

      Database component configurator summary

Date : Thu Nov 12 19:49:29 IST 2009
Database : Oracle
User : system
Action : create

Successfully installed components

Storage 25

  • Executing action
  • Action : create
  • Database : Oracle
  • Component : ALL
  • Component version : Latest
  • URL : jdbc:wm:oracle://localhost:1521;serviceName=XE
  • User : system
  • create Database Component: ComponentTracker CTR
  • Versions
  • Version: oracle 20 (7.0)
  • Scripts create

  •   Script(1): C:\webMethods7\common\db/scripts/oracle/componenttracker/20/create/ora_ctr_c_ddl.sql

  •   Script(2): C:\webMethods7\common\db/scripts/oracle/componenttracker/20/create/ora_ctr_c_ddl_view.sql

  •   Script(3): C:\webMethods7\common\db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

  • Executing script : C:\webMethods7\common\db/scripts/oracle/componenttracker/20/create/ora_ctr_c_ddl.sql

  • Executing script : C:\webMethods7\common\db/scripts/oracle/componenttracker/20/create/ora_ctr_c_ddl_view.sql

  • Executing script : C:\webMethods7\common\db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

OPERATIONMANAGEMENT [20] ALREADY EXISTS
ANALYSIS [35] ALREADY EXISTS

  • create Database Component: DistributedLocking DSL
  • Versions
  • Version: oracle 20 (7.1)
  • Scripts create

  •   Script(1): C:\webMethods7\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_ddl.sql

  •   Script(2): C:\webMethods7\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_dml_tracking.sql

  • Executing script : C:\webMethods7\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_ddl.sql

Error: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

CREATE DISTRIBUTEDLOCKING [20] FAILED
CDC ERROR [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

          Summary of installation errors

Error in executing file C:\webMethods7\common\db/scripts/oracle/distributedlocking/20/create/ora_dsl_c_ddl.sql
SQL error [wm-cjdbc36-0007][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

      Database component configurator summary

Date : Thu Nov 12 19:49:33 IST 2009
Database : Oracle
User : system
Action : create

Successfully installed components

Analysis 35 (Already exists)
OperationManagement 20 (Already exists)

Following components could not be installed:

DistributedLocking 20

Could you please help me on this.

Regards,
Sam

2

Sam,

Is this your first installation on the Database or did you previously install and drop them? If it is not a first installation then make sure you drop all the tables previously installed by logging in to the Database and do not drop the tables from the DCC.

Cheers,
Akshith

3

Hi Akshith,

Yes this is first time installation, but i tried more than once since it was not installed properly. which tables we need to drop? Hope we have to go through all the sql scripts to get the table name’s which we need to drop. Let me do and get back to you.

Thanks,
Sam

4

Sam,

I would say drop all the tables in the whole schema (If it has only MWS Tables) from a DB Client. Then rerun the DCC with create option for “Product-My webMethods Server”.

Cheers,
Akshith

5

Hi Akshith,

Thanks. It worked after Drop and Create… Thanks a lot.

Regards,
Sam