During Upgrade, DBTools are not running the UpgradeScripts Properly (Doc ID 2013952.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Communications Unified Inventory Management - Version 7.2.5.0.0 and later
Information in this document applies to any platform.

Goal

After upgrading to 7.2.5.2.
Cartridges with CharactersticSpecification is not getting deployes as , ISENTITYREFERENCE column is missing from characteristicSpecification.

Reason:

During DB upgrade the DB Scripts related to the 7.2.5.2 upgrade is not being executed and hence the column and tables are missing.

Log during DB Upgrade:

UIM_DB_TOOLS_logs.txt


./runDB.sh /opt/Oracle/installers/Installers/UIMInstallers/uim7252/ /opt/Oracle/jdk1.7.0_79/bin/ upgrade
UIM DB TOOLS *************************
Enter Database SID: SID
Enter Database User Id: UIM_PROD_FINAL
Enter Database Password:
Enter DbRunType(upgrade): upgrade
Enter dbDataTableSpace(optional):
Enter dbIndexTableSpace(optional):
---------------------------------------------------------------------
DbVersionController Invocation Parameters: Monday, May 25, 2015 2:59:43 PM WIB
apply update         = true
version Id           = 1
database config file = /opt/Oracle/installers/Installers/UIMInstallers/uim7252//config/databases.xml
update config file   = null
output folder        = /opt/Oracle/installers/Installers/UIMInstallers/uim7252//logs
database name        = SID
user name            = UIM_PROD_FINAL
database run type    = upgrade
log file             = /opt/Oracle/installers/Installers/UIMInstallers/uim7252/logs/DbVersionController.log

Applying Framework Update: sqlfrmwrk - Success
Applying Framework Update: sqlfrmwrk1 - Success
Applying Framework Update: sqlfrmwrk2 - Success


DbVersionController Completed  Monday, May 25, 2015 2:59:46 PM WIB
---------------------------------------------------------------------

 If you see none of the scripts related to 7.2.5.2 has been executed.


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms