BDSSA: ETL job fails after upgrading BSA to 8.9.01 - java.sql.SQLException: ORA-20104: DW Schema should be equal to or at higher version than OM Schema

Version 2
    Share:|

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


    PRODUCT:

    BMC Decision Support - Server Automation (5 Viewer, 1 Query License)


    APPLIES TO:

    BDSSA 8.9.00



    PROBLEM:

    BSA and BDSSA were both previously running 8.9 and ETL was running to completion.

    BSA was upgraded to 8.9.01 and now ETL fails with the following error:

    ORACLE:

    ODI-1228: Task CHECK_CONFIGURATION (Procedure) fails on the target ORACLE connection BSA_phy_dw_svr_site1. 
    Caused By: java.sql.SQLException: ORA-20104: DW Schema should be equal to or at higher version than OM Schema 
    ORA-06512: at line 43

    SQL Server:
    ODI-1228: Task CHECK_CONFIGURATION (Procedure) fails on the target MICROSOFT_SQL_SERVER connection BSA_phy_dw_svr_site1. 
    Caused By: com.microsoft.sqlserver.jdbc.SQLServerException: DW schema version should be greater than or equal to OM schema.


    CAUSE:

    BDSSA 8.9 must have a hotfix applied in order to be compatible with BSA 8.9.01


    SOLUTION:

    Please see the following documentation for details on where to download the BDSSA 8.9 hotfix

    The hotfix zip file contains a readme_oracle.txt and readme_sqlserver.txt file with detailed installation instructions. Please follow the instructions for your BDSSA DB type.

    BSA Doc:
    https://docs.bmc.com/docs/display/bsa89/Service+Pack+1:+version+8.9.01#ServicePack1:version8.9.01-UsingwithBMCDecisionSupportforServerAutomation8.9

    BDSSA Doc:
    https://docs.bmc.com/docs/display/bdssa89/Prerequisite+for+using+BMC+Decision+Support+for+Server+Automation+8.9.00+with+BMC+Server+Automation+8.9.01


    Note: After applying this hotfix, there may be an unrelated, but also related to BSA 8.9.01,  error downstream in the following ETL step:

    3_PROPERTY -> TEMPLATE_PROPERTY -> LOAD_TEMPLATE_PROP_TRANSPOSE -> LOAD_TEMPLATE_PROP_TRANSPOSE

    Error:
    Caused By: java.sql.SQLException: ORA-20001: Procedure LOAD_TEMPLATE_PROP_TRANSPOSE Failed with error message 
    ORA-20001: Error while reading Template Transpose Metadata Table for CVE_IDS* 
    ORA-06512: at "BSARA_DW.LOAD_TEMPLATE_PROP_TRANSPOSE", line 583 ORA-06512:

    If this issue is encountered, see KA 000137663 for details on how to resolve.


     


    Article Number:

    000136956


    Article Type:

    Solutions to a Product Problem



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