This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
TrueSight Server Automation
TSSA 8.9.04 Patch 3 Oracle Database
When upgrading a TrueSight Server Automation (TSSA) environment, which uses Oracle as the backend DB, to TSSA 8.9.04 Patch 3, the database migration portion of the upgrade fails with the following error in the NSH/br/blmigration.log file:
com.bladelogic.mig.framework.common.MigLogger - EXCEPTION WHILE RUNNING SINGLE STEP MIGRATION FROM 8.9.04.002 TO 8.9.04.003
 ERROR: TSK NM=Alter DBM Schema ; TSK SCR NM= ; TO=8.9.04.003 ; TSK MSG=Error occurred: Error message:ORA-01418: specified index does not exist
****** FINISHED ****** SINGLE STEP MIGRATION FROM 8.9.04.002 TO 8.9.04.003
FROM CONFIG FILE /tmp/Disk1/files/configurations/db_scripts/oracle/upgrade/8.9.04.002_to_8.9.04.003/OM/Migration_actions/
WITH **1** ERRORS
Conflict in primary key used on the DBM_MODULE_TABLES table between old versions of BSA and TSSA 8.9.04 P3
1) This issue does not affected SQL Server DB environments.
2) This Knowledge Article can be followed if the problem has already been encountered but can also be followed before the upgrade is executed in order to proactively avoid the issue.
To confirm this is the exact problem, run the following SQL diagnostic query as the bladelogic db user:
WHERE index_name = 'XPK_DBM_MODULES_TABLES' ;
If the count is 0 -> This looks like a different issue. If the ORA-01418 error is being encountered, contact BMC Customer Support and reference this KA.
If this KA is being followed proactively, before the 8.9.04 P3 upgrade has been launched, and the result of the diagnostic query is 0, proceed with the upgrade.
If the count is 1 -> Run the attached SQL remediation as the bladelogic db user. Then rerun the above diagnostic query
If the new count returned by the diagnostic query is 0, proceed to rerunning the 8.9.04 Patch 3 upgrade.
If the new count is still 1, contact BMC Customer Support and reference this KA
Rerunning the TSSA 8.9.04 P3 upgrade after this error, may fail immediately with the following error message:
"TrueSight Server Automation database version 0.8.9.04.002 or earlier has been detected on this server. Upgrade is not supported from this version. Please upgrade to 8.6.00.000 or higher before attempting this installation."
"Pre Upgrade execution could not be completed successfully. Database Schema Migration is STATUS_FAILED. Application Server upgrade is not attempted."
If this does occur, contact BMC Customer Support for assistance in adjusting the DB back to a state where the upgrade may be resumed.