ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Unable to see data for a custom metric family in OpenAPI


Article ID: 132294


Updated On:


CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration


After installing a custom metric family ( ex: Ligowave ) the metric shows "no data available in table"  We verified this by adding a query expression in the odata api:



Disconnect between DA and OpenAPI


CAPM 3.x


To resolve do the following:

1. Confirm data is in the tables for vertica.  Connect to vsql and run the following queries
  • select TO_TIMESTAMP(min(tstamp)), TO_TIMESTAMP(max(tstamp)) from ligowave_rate;
  • select TO_TIMESTAMP(min(tstamp)), TO_TIMESTAMP(max(tstamp)) from ligowave_eqd;
  • select TO_TIMESTAMP(min(tstamp)), TO_TIMESTAMP(max(tstamp)) from ligowave_ltd;

2. Assuming current data is returned do the following:

  • http://<da>:8581/system/console/bundles (username and password is karaf / karaf)
  • Search the page for "odata".  There are 4 bundles with an odata prefix.  Stop / Start each bundle using the buttons at the right

Retest the query expression as noted above and it should work


1559051302127000132294_sktwi15okjw4363h2.png get_app