Class view is missing from the main schema (Oracle Db)

Version 2
    Share This:

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


    PRODUCT:

    BMC Atrium Core - CMDB


    COMPONENT:

    BMC Atrium Core


    APPLIES TO:

    Atrium CMDB 9.x



    PROBLEM:

    It was found that on a newly created V9 environment the view BMC_CORE_BMC_SYSTEMCOMPONENT was not valid. This is an out of the box view but the view that it is based on - T3784 underpinning BMC.CORE:BMC_SystemComponent was missing.


    CAUSE:

    The view was broken or Invalid. 


    SOLUTION:

    In order to restore the View, added a Display only attribute from Class Manager and allowed it to Sync. 

    This newly added attribute helped restoring the Broken view for the specified Class.

    Also please refer KA(000128356 ) which talks about the views getting invalid in Oracle Database. 

    The same steps can be followed to restore any deleted or missing attributes which is present in the BMC_BaseElement class but is missing from it's child classes.


     


    Article Number:

    000148451


    Article Type:

    Solutions to a Product Problem



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