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.


    TrueSight Capacity Optimization


    Capacity Optimization


    TrueSight Capacity Optimization 11.3.01


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

    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(
        at com.neptuny.cpit.querymanager.QueryManager.execute(
        at com.neptuny.cpit.querymanager.QueryManager.execute(
        at com.neptuny.cpit.util.EdbhCliBase.executeCustomQuery(
        at com.neptuny.cpit.util.EdbhCli.executeCustomQuery(
        at com.neptuny.cpit.util.EntParentshipHelper.refreshEntParentship(
        at com.neptuny.cpit.cmdb.CmdbDatabaseUtils.refreshEntParentship(
        at com.neptuny.cpit.cmdb.ChangeApplier.refreshEntParentship(
        at com.neptuny.cpit.cmdb.ChangeApplier.applyActions(
        at com.neptuny.cpit.cmdb.ChangeApplier.doExecution(
        at com.neptuny.cpit.cmdb.ChangeApplier.runImpl(
        at com.neptuny.cpit.task.HierarchyManagerTask.executeObjRelImport(
        at com.neptuny.cpit.task.HierarchyManagerTask.doExecution(
        at com.neptuny.cpit.task.HierarchyManagerTask.doExecution(
        at com.neptuny.scheduler.task.AbstractTask.synchronousRun(
        at com.neptuny.scheduler.task.AbstractTask$
    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


    - 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.




    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

    Article Number:


    Article Type:

    Solutions to a Product Problem

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