while i am configuring with the data base configurator getting following error pealse help me

, ,
1

Hello,

i am using wM8.2 version,db configurator 8.2 and windows8.1 operating system

  • Executing action
  • Action : create
  • Database : DB2 for Linux, Unix, Windows
  • Product : Trading Networks
  • Product version : Latest
  • URL : jdbc:wm:db2://172.17.0.142:50001;databaseName=itgdb
  • User : mssusr24
  • create Database Component: ComponentTracker CTR
  • Versions
  • Version: db2luw 25
  • Scripts create

  •   Script(1): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_webm_create_component_event.sql

  •   Script(2): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_ctr_c_ddl.sql

  •   Script(3): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/migrate/20_to_25/db2_ctr_m_ccs_set_component_version_def.sql

  •   Script(4): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/migrate/20_to_25/db2_ctr_m_ccs_set_component_version_exec.sql

  • Executing script : C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_webm_create_component_event.sql

Error: [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema
CREATE COMPONENTTRACKER [25] FAILED
CDC ERROR [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema
Suspending execution…
CDC ERROR: java.sql.SQLException: [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema

          Summary of installation errors

Error in executing file C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_webm_create_component_event.sql
SQL error [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema

      Database component configurator summary

Date : Mon Dec 14 14:43:02 IST 2015

2

Hello

Delete all tables by using the DB configurator and restart the db from service.msc and recreate all tables , even if you get the same error delete manually table "WEBM_CREATE_COMPONENT_EVENT " from DB schema.

3

hello ,
did the same but i am getting same errors

  • Executing action
  • Action : create
  • Database : DB2 for Linux, Unix, Windows
  • Product : Trading Networks
  • Product version : Latest
  • URL : jdbc:wm:db2://172.17.0.142:50001;databaseName=itgdb
  • User : mssusr24
  • create Database Component: ComponentTracker CTR
  • Versions
  • Version: db2luw 25
  • Scripts create

  •   Script(1): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_webm_create_component_event.sql

  •   Script(2): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_ctr_c_ddl.sql

  •   Script(3): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/migrate/20_to_25/db2_ctr_m_ccs_set_component_version_def.sql

  •   Script(4): C:\SoftwareAG82\common\db/scripts/db2/componenttracker/migrate/20_to_25/db2_ctr_m_ccs_set_component_version_exec.sql

  • Executing script : C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_webm_create_component_event.sql

Error: [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema
CREATE COMPONENTTRACKER [25] FAILED
CDC ERROR [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema
Suspending execution…
CDC ERROR: java.sql.SQLException: [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema

          Summary of installation errors

Error in executing file C:\SoftwareAG82\common\db/scripts/db2/componenttracker/25/create/db2_webm_create_component_event.sql
SQL error [sag-cjdbc42-0011][DB2 JDBC Driver][DB2]Provided signature in the CREATE statement for user defined or stored procedure MSSUSR24.WEBM_CREATE_COMPONENT_EVENT matches the signature of some other function or procedure already existing in the schema

      Database component configurator summary

Date : Mon Dec 14 23:32:32 IST 2015
Database : DB2 for Linux, Unix, Windows
User : mssusr24
Action : create

Following components could not be installed:

ComponentTracker 25