This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.
TrueSight Capacity Optimization
TrueSight Capacity Optimization 10.7.01
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]
<-- 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
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 InformationIn 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.