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