BCO_INST_FAIL142: Error while performing Database alignment of table GLOSS_ETLMOD_LOOKUPINFO

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:

    TrueSight Capacity Optimization


    APPLIES TO:

    TSCO 10* 11*



    DETAILS:

    Below an error message occurred while upgrading TSCO 10.7.00 to 11.3.01 version and installation failed.

    BCO_INST_FAIL142: Error while performing Database alignment],Detail=[com.neptuny.cpit.util.sql.AlignException: Error during the align process of table 'GLOSS_ETLMOD_LOOKUPINFO': Identified 2 bad lines.
        at com.neptuny.cpit.util.sql.Align.align(Align.java:180)
        at com.neptuny.cpit.util.sql.Align.align(Align.java:111)
        at com.bmc.install.product.bco.BCOScriptRunnerTask.execDBAlignment(BCOScriptRunnerTask.java:1710)
        at com.bmc.install.product.bco.BCOScriptRunnerTask.performValidation(BCOScriptRunnerTask.java:203)
        at com.bmc.install.task.ValidationTask.execute(ValidationTask.java:54)
        at com.bmc.install.task.InstallationTask.run(InstallationTask.java:93)
        at java.lang.Thread.run(Thread.java:748)

     
      From /opt/bmc/BCO/installation_logs/align.log found below error message...
    =============================
     
       
      Processing table 'GLOSS_ETLMOD_LOOKUPINFO', mode: 'UPDATE' INSERT Batch commit of 11 rows failed. Reduce batch size to identify BAD rows.
    INFO  Align:239 - INSERT.2 Batch commit of 6 rows failed. Reduce batch size to identify BAD rows.
     
      WARN  Align:268 - INSERT.2 Bad element detected (java.sql.SQLIntegrityConstraintViolationException ORA-00001: unique constraint (BCO_OWN.LOSS_ETLMOD_LOOKUPINFO_IDX_1) violated ): 154|gm:azu|STRONG|1|PARENT_RESOURCE_GROUP_NAME&&VM_NAME||
    ===============================

     


    Article Number:

    000161186


    Article Type:

    Product/Service Description



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