DX Unified Infrastructure Management

 View Only
  • 1.  Error in Custom Report DX IM 20.3

    Posted Oct 27, 2020 01:15 PM
    Hello

    I got the following error when I try to create a custom report in DX IM 20.3:


    Anyone had the same problem? Anyone can help?

    Thank you.

    BR
    Bruno Sousa


  • 2.  RE: Error in Custom Report DX IM 20.3

    Posted Oct 27, 2020 03:15 PM
    It could be the .vn relates to VN_QOS_DATA tables which are custom views created via qos_views.sql, it seems to be a Services thing, and not there by default. 
    Basically the VN_ tables(views) are a JOIN on RN + HN data.
    No idea why it popups up for you.

    ------------------------------
    Support Engineer
    Broadcom
    ------------------------------



  • 3.  RE: Error in Custom Report DX IM 20.3

    Broadcom Employee
    Posted Oct 27, 2020 06:15 PM
    Hi Bruno,

    qos_views.sql
    The qos_views.sql script is a custom field-developed script to create views that makes it easier to help feed data into dashboards by querying the views.
    It creates views named V_<qosname>, for example V_QOS_CPU_USAGE but nothing to do with .vn.

    In the CA UIM DB, the VN_QOS_DATA tables are simply views, which do not hold any actual data. They pull data from the RN, DN, and HN tables.

    Nevertheless, ca_uim.vn seems to be related to something custom as Dave initially indicated. Maybe your query is going against a custom table that no longer exists.

    Steve

    ------------------------------
    Support Engineer
    Broadcom
    US
    ------------------------------