Error while creating Database Components

Hi, After installing 8.0, I am creating database components and facing the following issue:


  • create Database Component: DatabaseManagement DBM

  • Versions
  • Version: oracle 20
  • Scripts create
    
  •   Script(1): C:\wMethods8\common\db/scripts/oracle/databasemanagement/15/create/utilities.pkg
    
  •   Script(2): C:\wMethods8\common\db/scripts/oracle/databasemanagement/15/create/utilities.pkb
    
  •   Script(3): C:\wMethods8\common\db/scripts/oracle/databasemanagement/17/create/jobspkg.pkg
    
  •   Script(4): C:\wMethods8\common\db/scripts/oracle/databasemanagement/17/create/jobspkg.pkb
    
  •   Script(5): C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/metadatapkg.pkg
    
  •   Script(6): C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/swapops.pkg
    
  •   Script(7): C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/metadatapkg.pkb
    
  •   Script(8): C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/swapops.pkb
    
  •   Script(9): C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/ora_dbm_c_dml.sql
    
  •   Script(10): C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/ora_dbm_c_dml_tracking.sql
    

  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/15/create/utilities.pkg
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/15/create/utilities.pkb
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/17/create/jobspkg.pkg
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/17/create/jobspkg.pkb
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/metadatapkg.pkg
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/swapops.pkg
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/metadatapkg.pkb
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/swapops.pkb
    
  • Executing script : C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/ora_dbm_c_dml.sql
    

Error: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-04063: package body “WMUSER.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “WMUSER.OPERATION_MGMT”
ORA-06512: at “WMUSER.SWAPOPS”, line 1869
ORA-06512: at line 6

CREATE DATABASEMANAGEMENT [20] FAILED
CDC ERROR [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-04063: package body “WMUSER.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “WMUSER.OPERATION_MGMT”
ORA-06512: at “WMUSER.SWAPOPS”, line 1869
ORA-06512: at line 6

Suspending execution…
CDC Error: java.sql.SQLException: [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-04063: package body “WMUSER.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “WMUSER.OPERATION_MGMT”
ORA-06512: at “WMUSER.SWAPOPS”, line 1869
ORA-06512: at line 6


          Summary of installation errors

Error in executing file C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/ora_dbm_c_dml.sql
SQL error [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-04063: package body “WMUSER.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “WMUSER.OPERATION_MGMT”
ORA-06512: at “WMUSER.SWAPOPS”, line 1869
ORA-06512: at line 6


      Database component configurator summary

Date : Wed Sep 15 09:37:35 EDT 2010
Database : Oracle
User : WMUSER
Action : create

Successfully installed components

Analysis 45 (Already exists)
BPEL 10 (Already exists)
Blaze 10 (Already exists)
CrossReference 11 (Already exists)
DistributedLocking 20 (Already exists)
OperationManagement 20 (Already exists)

Following components could not be installed:

DatabaseManagement 20

Can someone provide their due diligence on this, if am doing something wrong or missing anything?

best,

Are you running this thru DBConfigurator tool or standalone sql scripts?

HTH,
RMG

I am using DBConfigurator.

I have the same issue. I have tried create and recreate from dbConfiguratorUI.sh

This is in Oracle XE if it makes a difference.

Anyone find a resolution for this? I am running into the same issue, using DCC for creating MWS 8.0.1 tables in a new Oracle 11.202 database.

Figured I would post the resolution for anyone else that runs into this issue. This was the first time I used the GUI instead of command line. First drop all tables and then in the Database Component list select PRODUCT - My webMethods Server to create the new tables. Not sure what the difference is between My webMethods Server and PRODUCT - My webMethods Server but the PRODUCT one worked.

This question is off topic for this forum, but i asked one of our DB gurus and he gave me the following info:

Hope this helps.
–mark

1 Like

yeah dude…it is very simple…
open database congifurator…
next drop all the tables
then recreate
then again drop all tables
then create…
try this funny trick hope u will get successful

Many thanks for the resolution.
I had opened a Service Request with Software Ag . I will close it as it is resolved now.

I followed this solution

In Oracle XE, the sys.UTL_SMTP is not granted for execution by default (referred in OPERATION_MGMT).
To solve this, login to database as a sys and execute the following command:
Grant execute on sys.utl_smtp to public;

Then re-run the dbconfigurator again.