IBM Support

ITM Agent Insights: IBM Infrastructure Management Capacity Planner Reports for VMware are not working

Technical Blog Post


Abstract

ITM Agent Insights: IBM Infrastructure Management Capacity Planner Reports for VMware are not working

Body

In this blog I will give an example of an error when Capacity Planner Reports are failing.

 

Are you receiving the following error in your cogserver.log?
An error occurred while performing operation 'sqlPrepareWithOptions' status='-201'.  UDA-SQL-0196 The table or view "CFG_VIRTUAL_MACHINE" was not found in the dictionary.  UDA-SQL-0196 The table or view "ANL_WORKING_SET_V" was not found in the dictionary.

 

ANL_INVENTORY_V is a database view so it can be found under 'Views' node in db2cc.  One can browse through the DB2 client to do this check (i.e. DB2 -> Control Center -> All Databases -> TADFDCDB -> Views).  Also make sure the database user (i.e. db2inst1) has required privileges to view data (i.e. run SQL commands like SELECT etc.) on Capacity Planner database (i.e. TADFDCDB) in the DB2 environment.

 

If the above checks are fine, check the TADFDCDB data source connection in TCR [Common Reporting -> Launch -> IBM Cognos Administration -> Configuration -> Data Source Connections -> TADFDC_REPORTING_DS, i.e. data source name -> TADFDC_REPORTING_DS, i.e. connection name  -> Actions -> Test the connection -> Test ], to ensure that connection is succeeded.

 

Also, refer to the 'IBM Tivoli Monitoring for Virtual Environments Dashboard, Reporting, and Capacity Planning' Users Guide for details on loading configuration data in Capacity Planner environment, which will help to populate data for Capacity Planner.

https://www.ibm.com/support/knowledgecenter/SS9U76_7.2.0.2/com.ibm.tivoli.itmvs.doc_7.2.0.2/dashboards_reports/drcp_landing_user.html

 

Additional ITM Agent Insights series of IBM Tivoli Monitoring Agent blogs are indexed under ITM Agent Insights: Introduction.

 


 

 

 

 

Tutorials Point

 

Subscribe and follow us for all the latest information directly on your social feeds:

 

 

image

 

image

 

image

 

 

  

Check out all our other posts and updates:

Academy Blogs: http://ow.ly/Otue0
Academy Videos: http://ow.ly/PIKFz
Academy Google+: http://ow.ly/Dj3nn
Academy Twitter Handle: http://ow.ly/Dj35c


image

 

[{"Business Unit":{"code":"BU004","label":"Hybrid Cloud"},"Product":{"code":"","label":""},"Component":"","Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

UID

ibm11085013