TrueSight Capacity Optimization (TSCO) Capacity View failing with error "BCO_PRV_ERR012 - [DatamartServiceRestWS] Failed to query datamart XXXX"

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.5,11.3, 11.0, 10.7



    PROBLEM:

    In TrueSight Capacity Optimization (TSCO) there is a custom datamart
    After the upgrade from version 10.5 (or lower) to a 10.7 (or greather) when it is used in Sight Presentation Server (TSPS) it raise this error
    BCO_PRV_ERR012 - [DatamartServiceRestWS] Failed to query datamart XXXX
    where XXXX is the ID of the data mart


    SOLUTION:

    TSCO Capacity View failing with error "BCO_PRV_ERR012 - [DatamartServiceRestWS] Failed to query datamart 2257"
    The BCO_PRV_ERR012 error is a bit generic meaning Data provider has detected a query execution error as reported in documentation.

    One thing to validate in TrueSight Capacity Optimization (TSCO) under Advanced Reports -> Data mart is:
    The Datamart SQL is properly executing (a Preview yields the expected output)
    Check the metadata associated with the View in TSCO.  That is the screen after the SQL where specific datatypes and meanings can be assigned to the query output.  One possibility is that a bad datatype has been assigned (such as a timestamp for a string value).

    Checking the metadata associated with the View is particularly important after upgrading from earlier releases of TSCO to version 11.0 or later because the metadata wasn't required for the TSCO embedded views functionality like it is for the TSCO Capacity Views in TSPS.

     


    Article Number:

    000329096


    Article Type:

    Solutions to a Product Problem



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