DM / CCR reports show no data

Document ID:  TEC540224
Last Modified Date:  01/26/2016
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Capacity Command Center (with Data Manager)
  • CA Capacity Management (CA Hyperformix)

Components

  • CA DATA MANAGER:HYDMSE
  • CA CAPACITY COMMAND CENTER:HYPCCC
  • CA CURRENT CAPACITY REPORTER:HYPCCR

Question: 

 

Data Manager Crystal reports show 'No data exists for this report'. How can I check if there is data in the database .

 

Environment:  

 

CCC /  DM with oracle database

 

Answer: 

 

Use the following SQL query to determine whether there is data of interest in Data Manager for the report, by showing the dates for servers with migrated data.

If there is no data of interest in the database, there may be a technical issue with Data Manager or a problem with the Data Source.

In cases where DM Crystal reports show 'No data exists for this report', run the following query to determine if there is data available for these servers.
It takes a snapshot of the data that has been migrated into Data Manager, returning the dates, the server names (host) and maximum GBL_CPU_UTIL

SELECT server_fact.gmt_metric_date AS gmtmetricdate,        server_fact.metric_date AS metricdate,        MAX(server_dim.host_name) AS
host,        MAX(metric_dim.std_name) AS name,        MAX(server_fact.metric_value) AS value   FROM server_fact,        server_dim,    
metric_dim  WHERE server_fact.server_dim_id = server_dim.server_dim_id    AND server_fact.metric_dim_id = metric_dim.metric_dim_id    AND
metric_dim.std_name IN ('GBL_CPU_UTIL')    AND server_fact.metric_value IS NOT NULL GROUP BY server_fact.gmt_metric_date,
server_fact.metric_date ORDER BY 1, 2;

For example, it returns results like the following:

GMTMETRICDATE                    METRICDATE          HOST            NAME                      VALUE
VALUE 27-Nov-1                   27-Nov-1            myserver        GBL_CPU_UTIL              16.6 

 

 

 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >