Error while migrating DB (ISInternal, ISCoreAudit) for Integration Server v. 8.0.1.0 to 8.2.2.0

, , ,
1

Hi,

We are facing error while migrating DB components (ISInternal, ISCoreAudit) for Integration Server v. 8.0.1.0 to 8.2.2.0 (non-clustered env.).
#####################################################
$ ./dbConfigurator.sh -a migrate -d oracle -c ISInternal -v latest -l “jdbc:wm:oracle://xxxx:1521;serviceName=orcl” -u dbuser -p dbpass

  • Executing action
  • Action : migrate
  • Database : Oracle
  • Component : ISInternal
  • To version : latest
  • URL : jdbc:wm:oracle://xxxx:1521;serviceName=orcl
  • User : dbuser
  • create Database Component: ComponentTracker CTR
  • Versions
  • Version: oracle 25
  • Scripts create

  •   Script(1): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql

  •   Script(2): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql

  •   Script(3): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql

  •   Script(4): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

  •   Script(5): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql

          Summary of installation errors

“ISInternal” is not installed. Please install the component using create action

      Database component configurator summary

Date : Thu May 02 05:28:13 BST 2013
Database : Oracle
User : dbuser
Action : migrate
Action : migrate
#####################################################

When we tried to install it, then we are getting error like “CDC ERROR [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object” . See below:

         Summary of installation errors

Error in executing file /app/webMethods80_IS/common/db/scripts/oracle/isinternal/40/create/ora_isi_c_ddl.sql
SQL error [sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00955: name is already used by an existing object

      Database component configurator summary

Date : Thu May 02 05:29:28 BST 2013
Database : Oracle
User : dbuser
Action : create

Following components could not be installed:

ISInternal 40

###############################################################

As a result, I am not able to view scheduler information in Integration server and getting below error in server.log:

[sag-cjdbc42-0011][Oracle JDBC Driver][Oracle]ORA-00904: “INTERNALTASK”: invalid identifier

$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$

I have followed complete process as described in SAG upgarde guide 8-2-SP1_webMethods_Upgrade_Guide.

Kindly advise on this.

2

Hi Hukam,

You are executing the Database migration scripts from 8.0 installation. You got to do this from 8.2.2 database component installation folder.

-Senthil

3

Hi Senthil,

Thanks for replying on this!!!

I am did overinstall upgarde and kept same directory structure (I have attached the image which shows the components i chose to install).

######################################################
$ pwd
/app/webMethods80_IS/common/db/bin
$
$ ./dbConfigurator.sh -a migrate -d oracle -c ISCoreAudit -v latest -l “jdbc:wm:oracle://xxxx:1521;serviceName=orcl” -u dbuser -p dbpassword

  • Executing action
  • Action : migrate
  • Database : Oracle
  • Component : ISCoreAudit
  • To version : latest
  • URL : jdbc:wm:oracle://xxxx:1521;serviceName=orcl
  • User : dbuser
  • create Database Component: ComponentTracker CTR
  • Versions
  • Version: oracle 25
  • Scripts create

  •   Script(1): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql

  •   Script(2): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql

  •   Script(3): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql

  •   Script(4): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

  •   Script(5): /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_20_to_25.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/25/create/ora_ctr_c_ddl_view.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql

  • Executing script : /app/webMethods80_IS/common/db/scripts/oracle/componenttracker/migrate/20_to_25/ora_ctr_m_ccs_set_component_version.sql

          Summary of installation errors

“ISCoreAudit” is not installed. Please install the component using create action

      Database component configurator summary

Date : Wed May 08 05:57:53 BST 2013
Database : Oracle
User : dbuser
Action : migrate

######################################################

Regards,
Hukam

wM_components.JPG
wM_components.JPG590×514 54.4 KB

4

Hi Hukam,
Execute the below command and let me know the outcome. This would list what different table schemas are available, and their current version.

$ ./dbConfigurator.sh -a catalog -d oracle -url “jdbc:wm: oracle://xxxx:1521;serviceName=orcl” -u dbuser -p dbpassword

-Senthil

5

Hi Senthil,

Below is the out come and i can’t see the desired component installed here.

  • Executing action
  • Action : catalog
  • Database : Oracle
  • URL : jdbc:wm:oracle://xxxx:1521;serviceName=orcl
  • User : dbuser
  •  Installed Components      *
  • ARC 30 Archive null,null
  • XRF 11 CrossReference WEBMDATA,WEBMINDX
  • DTP 25 Data Purge null,null
  • DBM 20 Database Management null,null
  • DSL 20 DistributedLocking WEBMDATA,WEBMINDX
  • IDR 10 DocumentHistory WEBMDATA,WEBMINDX
  • MED 10 MediatorEvents WEBMDATA,WEBMINDX
  • OPM 20 Operation Management WEBMDATA,WEBMINDX
  • PRA 40 ProcessAudit WEBMDATA,WEBMINDX
  • PRE 41 ProcessEngine WEBMDATA,WEBMINDX
  • PTR 40 ProcessTracker WEBMDATA,WEBMINDX
  • PRP 25 Reporting WEBMDATA,WEBMINDX
  • PST 20 Staging WEBMDATA,WEBMINDX

DO i need to install it again ?

6

Hi Hukam,
If you install ISCoreAudiit and ISInternal, it will work but it will not have any migrated detail of what was there in 8.0.

Your 8.0 environment should be pointing to a particular schema where ISInternal and ISCoreAudit tables are created. It cannot run without that. The URL that you are providing right now is different from where the actual IS tables exists. Providing the right schema/user name, or db info and db scripts will take care of rest…

HTH
Senthil