In TSCO 10.7.01 CHF 10.7.01.00.C00007 through C00009 the vCenter Extractor Service is ending in ERROR state, "BCO_SCH_ERR011: Error extracting NET metric ... Statement was canceled or the session timed out"

Version 3
    Share:|

    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 10.7.01



    PROBLEM:

    In the TrueSight Capacity Optimization (TSCO) Cumulative Hot Fix (CHF) 10.7.01.00.C00007 a change was introduced to correct certain VMware network interface statistics being reported double their correct value:
      QM002347473 - VMware network interface stats in TSCO are twice the value as reported by vCenter

    An unintended consequence of this change is that in an environment where the vCenter supports a large number of VMware hosts or guests the vCenter Extractor Service will report the following error during the LOAD:

    2017-11-27 13:26:13,540 ERROR [service-112-1]- BCO_SCH_ERR011: Error extracting NET metric
    StackTrace: org.h2.jdbc.JdbcSQLException: Statement was canceled or the session timed out; SQL statement:
    select (TIMESTAMP/900000)*900000 as timestamp, parentid AS ID, isparentvm AS ISVM, SUM (packetsrx) AS packetsrx, SUM (packetstx) AS packetstx, AVG (received) AS received, AVG (transmitted) AS transmitted, AVG (netrate) AS netrate, MAX(received) AS max_received, MAX(transmitted) AS max_transmitted, MAX(netrate) AS max_netrate, MIN(received) AS min_received, MIN(transmitted) AS min_transmitted, MIN(netrate) AS min_netrate, COUNT(received) AS count_received, COUNT(transmitted) AS count_transmitted, COUNT(netrate) AS count_netrate, SUM (droppedrx) AS droppedrx, SUM (droppedtx) AS droppedtx FROM  ( SELECT  (TIMESTAMP/300000)*300000 AS TIMESTAMP, epn.parentid as parentid, epn.isparentvm as isparentvm, SUM(packetsrx) AS packetsrx, SUM(packetstx) AS packetstx, SUM(received) AS received, SUM(transmitted) AS transmitted, SUM(transmitted) + SUM(received) AS netrate, SUM(droppedrx) AS droppedrx, SUM(droppedtx) AS droppedtx FROM  ESXPERFNET epn, ESXNET esnt where epn.parentid = esnt.parentid and epn.isparentvm = esnt.isparentvm and epn.name = esnt.name GROUP BY  (TIMESTAMP/300000)*300000, parentid ) group by (TIMESTAMP/900000)*900000, parentid [57014-176]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:344)
    <-- cut -->


    Problem symptoms include:

       
    • The 'BCO_SCH_ERR011: Error extracting NET metric StackTrace: org.h2.jdbc.JdbcSQLException: Statement was canceled or the session timed out' error
    •  
    • Missing VMware Network statistics in TSCO

     


    SOLUTION:

     

    This problem will be addressed in TSCO Cumulative Hot Fix (CHF) 10.7.01.00.C00010 scheduled for release the week of January 15th, 2018.

    A one-off hot fix is available for environments running TSCO CHF 10.7.01.00.C00008 or 10.7.01.00.C00009 (released the week of December 4th).

    The one-off hot fix (TSCO_10.7.01.00.00029.patch) is attached to this KA and also available from TSCO Technical Support by request.

      

    In the patch README the fix label is, "Hotfix TSCO_10.7.01.00.00029 .for  Defect QM002347473:  VMware network interface stats in TSCO are twice the value as reported by vCenter" since this is an update to that earlier fix which implements that earlier fix in a way that should avoid the "BCO_SCH_ERR011: Error extracting NET metric" error.

      

    Additional Information

    In the event that the error persists after applying the TSCO_10.7.01.00.00029.patch one-off hot fix or CHF 10.7.01.00.C00010 there is a configuration property available to further reduce the batch size of the number of systems being processed in a single query against the vCenter Extractor Service's local H2 database. 

    The '  extract.vmware.diskperf.batchsize' parameter can be set within the ETL Run Configuration to change the batch size.  The default value is 1000. 
      

     


    Article Number:

    000146088


    Article Type:

    Solutions to a Product Problem



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