SCOM ETL Problem after CHF 5

Version 1
    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 Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    BMC CO 10.5 fp1 CHF5 or higher



    PROBLEM:

    Since we installed last CHF5 on our BMC CO 10.5, we started having some problems with the “Moviri - MS SCOM extractor” ETL.
    The error we obtain during loading phase is :
    FAILED java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (BCO_OWN.SYS_OBJECT_IDX_4) violated
    ORA-06512: at "BCO_OWN.ETL_MODULE", line 280
    ORA-06512: at "BCO_OWN.ETL_MODULE", line 615
    ORA-06512: at "BCO_OWN.ETL_MODULE", line 671
    ORA-06512: at "BCO_OWN.ETL_MODULE", line 699
    ORA-06512: at "BCO_OWN.ETL_MODULE", line 721
    ORA-06512: at line 1


    CAUSE:

    Moviri SCOM ETL defect, it does not use the Fillrow() function to load some metrics.


    SOLUTION:

    Please, go to BMC downlaod side, download and deploy last Moviri add-on for SCOM
     


    Article Number:

    000331168


    Article Type:

    Solutions to a Product Problem



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