TSCO - TimeZone offset not populated in TSCO database by Vmware ETL

Version 2
    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




    We have a VMware ETL is running correctly and ending on OK status, but the data being loaded has no offset information, so it would be assumed by the product to be Eastern time (the TZ of AS/DB server) even though we configured AS time disabled = true


    08/21/2019 00:16:06INFO[pool-34896-thread-1]- Time taken to process delta configuration updates: 19.504 seconds
    08/21/2019 00:16:07INFO[pool-34896-thread-1]- Setting host start time: 20/08/2019 15:39:40 +0000, cluster start time: 20/08/2019 15:40:00 +0000, datacenter start time: 20/08/2019 15:35:00 +0000, current VC server time: 20/08/2019 16:16:06 +0000
    08/21/2019 00:16:07INFO[pool-34896-thread-1]- Collector: collecting host/vm performance information
    08/21/2019 00:16:19INFO[pool-34896-thread-1]- Performance extraction for host/vm took: 12.428 second(s)
    08/21/2019 00:16:19INFO[pool-34896-thread-1]- New data has been extracted. Performance data timestamp: 20/08/2019 15:55:00 +0000
    08/21/2019 00:16:24INFO[pool-34896-thread-1]- Opening aggregator on path: ../localdb/vmwservice_2754.db
    08/21/2019 00:16:28INFO[pool-34896-thread-1]- Saving VM FS detailed statistics - [#1300 - pollTimeMs:1566317784131 - Wed Aug 21 00:16:24 HKT 2019]
    08/21/2019 00:16:28INFO[pool-34896-thread-1]- Cleaning spurios BYFS samples starting from 1566317784131 - Wed Aug 21 00:16:24 HKT 2019
    08/21/2019 00:16:28INFO[pool-34896-thread-1]- Finished data extraction
    08/21/2019 00:16:28INFO[service-2754-1]- ... end service [2754]
    Even with this configuration TZOFFSET is not populated into SYS_DATA_STAGE table. 



    Engineering team confirm this as  defect and is being tracked with below ID:

    DRCOZ-23478 - TZOFFSET is not getting stored in database when Use AS TZ is set to No.

    Solution will be provided under CHF

    You can find the latest CHF for TSCO 11.3.01 on below FTP link:


    Article Number:


    Article Type:

    Solutions to a Product Problem

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