In TSCO Hierarchy Manager Task triggers an ORA-22813 Error while evaluating a rule

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:

    TrueSight Capacity Optimization 11.3.01



    PROBLEM:

    The behavior is seen when an ETL causes a failure on the Hierarchy manager task and the Scheduler logs this error:

    <<---cut--->>
    2019-03-29 11:59:21,714 FAILED [taskid=28]- BCO_DB_FAIL104: Generic error detected during execution: 
    StackTrace: com.neptuny.cpit.querymanager.QueryException: [java.sql.SQLException] - ORA-22813: operand value exceeds system limits
    ORA-06512: at "BCO_OWN.REFRESH_ENT_PARENTSHIP", line 540
    ORA-06512: at "BCO_OWN.REFRESH_ENT_PARENTSHIP", line 612
    ORA-06512: at line 1
    query-name: RefreshEntParentship
    sql-code  : refresh_ent_parentship()
     at com.neptuny.cpit.querymanager.QueryManager.execute(QueryManager.java:525)
        at com.neptuny.cpit.querymanager.QueryManager.execute(QueryManager.java:424)
        at com.neptuny.cpit.querymanager.QueryManager.execute(QueryManager.java:355)
        at com.neptuny.cpit.util.EdbhCliBase.executeCustomQuery(EdbhCliBase.java:124)
        at com.neptuny.cpit.util.EdbhCli.executeCustomQuery(EdbhCli.java:215)
        at com.neptuny.cpit.util.EntParentshipHelper.refreshEntParentship(EntParentshipHelper.java:61)
        at com.neptuny.cpit.cmdb.CmdbDatabaseUtils.refreshEntParentship(CmdbDatabaseUtils.java:964)
        at com.neptuny.cpit.cmdb.ChangeApplier.refreshEntParentship(ChangeApplier.java:1046)
        at com.neptuny.cpit.cmdb.ChangeApplier.applyActions(ChangeApplier.java:652)
        at com.neptuny.cpit.cmdb.ChangeApplier.doExecution(ChangeApplier.java:414)
        at com.neptuny.cpit.cmdb.ChangeApplier.runImpl(ChangeApplier.java:290)
        at com.neptuny.cpit.cmdb.ChangeApplier.run(ChangeApplier.java:277)
        at com.neptuny.cpit.task.HierarchyManagerTask.executeObjRelImport(HierarchyManagerTask.java:638
        at com.neptuny.cpit.task.HierarchyManagerTask.doExecution(HierarchyManagerTask.java:305)
        at com.neptuny.cpit.task.HierarchyManagerTask.doExecution(HierarchyManagerTask.java:206)
        at com.neptuny.scheduler.task.AbstractTask.synchronousRun(AbstractTask.java:626)
        at com.neptuny.scheduler.task.AbstractTask$InnerThread.run(AbstractTask.java:896)
    Caused by: java.sql.SQLException: ORA-22813: operand value exceeds system limits
    ORA-06512: at "BCO_OWN.REFRESH_ENT_PARENTSHIP", line 540
    ORA-06512: at "BCO_OWN.REFRESH_ENT_PARENTSHIP", line 612

    <---cut--->

    - It looks like it’s trying to add children to an existing domain calling procedure mat_domain_children_full()
    - For some reason (likely too many children into the same domain)  this is failing and triggering the ORA-22813: operand value exceeds system limits.


    CAUSE:

    DRCOZ-21110


    SOLUTION:

    The internal refresh_ent_parentship procedure on the Database throws this error due to the fact that it processes a high number of variations for a single rule.

    This issue was identified as defect DRCOZ-21110 and included on AS&EE 11.3.01.01.C00015


    Article Number:

    000167086


    Article Type:

    Solutions to a Product Problem



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