DX Infrastructure Management

Expand all | Collapse all

Detail of server not showing data

  • 1.  Detail of server not showing data

    Posted 02-13-2019 01:06 PM

    Hi everyone.

     

    I have a situation unusual. When I consult a server can't see the metrics on tab detail. But if I look in metric tab I see metrics.

     

     

    This happen only with a server.



  • 2.  Re: Detail of server not showing data

    Posted 02-13-2019 01:17 PM

    We noticed this issue in 8.51 and thought it would correct itself when we went to 9.0.2.  It did not correct itself, we are still seeing the same issue with a couple servers.



  • 3.  Re: Detail of server not showing data

    Posted 02-13-2019 06:52 PM

    Bart -

     

    A good place to start tracking this down is the KB000045476 : How Do I Troubleshooting Missing Data Knowledge document.  If this does not help you to figure out why data is missing, I would recommend opening an issue for this with UIM support.



  • 4.  Re: Detail of server not showing data

    Posted 02-14-2019 07:48 AM

    Miller, can you please try:

     

    Set or create on the data_engine on the RAW configuration
    setup
    New Key
    Name:update_metric_id
    value: yes


    Run the following query:

    update S_QOS_DATA set ci_metric_id = NULL WHERE robot = 'robot_name';


    Nis Cache Clean

    At the Robot with the issue please:
    Go to the Controller
    Press CTRL +P
    enable Expert mode
    Select: _Nis_cache_clean ( execute the play green button)
    Select : _reset_device_id_and_restart (execute the play green button)

     

    Finally:

    How to reset discovery in CA UIM 8.10 or later - CA Knowledge 

     

    Basic just remote the Device from the USM inventory and rediscover, just uncheck the options before delete it

     

    Kind Regards,


    Alex Yasuda
    Sr. Support Engineer

    Broadcom Enterprise Software Division



  • 5.  Re: Detail of server not showing data

    Posted 02-14-2019 02:02 PM

    yasal01, I Applied the procedure but the server now not showing metrics.



  • 6.  Re: Detail of server not showing data

    Posted 02-15-2019 02:24 PM

    One possible cause might be duplicate qos definitions in the s_qos_data table.

     

    In your screen shot you do have QOS_CPU_USAGE so we can look at this metric and verify that you do

       not have any duplicates. I like to wildcard % the robot name to catch instances where one can be shortname

       and the other FQDN.

     

    select * from s_qos_data where qos = 'QOS_CPU_USAGE' and robot like 'robotNameHere%' and probe = 'cdm'

     

    If you find duplicates the next steps would be to identify the entry that is not being used and delete it from the s_qos_data table.

     

    Next you can get the cs_id for the robot

     

    select * from CM_COMPUTER_SYSTEM where name like 'robotNameHere%'

     

    And update the cs_id value in the where clause of the next query

     

    SELECT sqd.r_table,
           sqd.table_id,
           sqd.qos_def_id,
           sqd.ci_metric_id,
           cim.ci_metric_type,
           sqd.robot,
           sqd.probe,
           sqd.source,
           sqd.qos,
           sqd.target,
           sqd.origin
      FROM cm_computer_system s,
           cm_device d,
           cm_configuration_item ci,
           cm_configuration_item_metric cim,
           s_qos_data sqd
      WHERE s.cs_id = d.cs_id
        AND d.dev_id = ci.dev_id
        AND ci.ci_id = cim.ci_id
        AND cim.ci_metric_id = sqd.ci_metric_id
        AND ( sqd.probe = 'cdm' OR
              sqd.probe = 'rsp' OR
              sqd.probe = 'net_connect' )
        AND sqd.qos = 'QOS_CPU_USAGE'
        AND s.cs_id = '41'
        AND cim.ci_metric_type = '1.5:1'

     

     

     

    -Greg