TSSA: Database upgrade to TSSA 8.9.04 Patch 3 fails with error - ORA-01418: specified index does not exist

Version 21
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Server Automation


    COMPONENT:

    TrueSight Installer


    APPLIES TO:

    TSSA 8.9.04 Patch 3 Oracle Database



    PROBLEM:

    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
    ============================================================================================
    [1] 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
     


    CAUSE:

    Conflict in primary key used on the DBM_MODULE_TABLES table between old versions of BSA and TSSA 8.9.04 P3


    SOLUTION:

     

    Notes:
    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:

    SELECT COUNT(1)
      INTO v_cnt
      FROM user_indexes
      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

    Note: 
    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.

     


    Article Number:

    000181889


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles