Service Operations Insight

  • 1.  VM Usage Summation CCR Report does not export CSV data

    Broadcom Employee
    Posted Nov 21, 2017 11:01 AM

    Hi,

     

    I am facing a strange problem in a specific CCR report.

    In the "VM Usage Summation" report when I click in Export to CSV, only the empty data.csv file appears.

    Does anyone know if it's a common problem?

    Thanks



  • 2.  Re: VM Usage Summation CCR Report does not export CSV data

    Posted Nov 21, 2017 11:37 AM

    I believe the likely issue is that the core 'NPC' needs to be updated. 

    The following link describes how to apply the Service Packs to the core NPC product:

    Tech Tip: Changing CCR default max row setting of 10 has no effect.



  • 3.  Re: VM Usage Summation CCR Report does not export CSV data

    Broadcom Employee
    Posted Nov 21, 2017 01:34 PM

    Hi Kip,

    I made the all procedures of Tech Tip: Changing CCR default max row setting of 10 has no effect. and I still facing this problem.



  • 4.  Re: VM Usage Summation CCR Report does not export CSV data
    Best Answer

    Posted Nov 21, 2017 01:55 PM

    Ok. The other thing it could be that the report definition does not have the all of the columns defined in the hyperlink section.

    I found a resolution for this that David Dupre dupda03 provided. It requires having RDP access to the CCR server, editing the MySQL_VMWARE_CORE.sql file and re-running it in MySQL session.

     

    The file MySQL_VMWARE_CORE.sql contains the definitions for this view.

     

    This View of interest starts at line 961 showing the line:

    select @controlID := ID from controls where Title = 'VM Usage Summation';

     

    It appears that the line 978 in the file MySQL_VMWARE_CORE.sql file has only enough commas to hold 7 hyperlinks.

     

    There are 8 columns of data on that page.  (See lines 966, 970, 971 each has 8 column definitions.)

    There needs to be 8 locations for hyperlinks also, there is not.  (Line 978)

    Note: there are only 2 columns that have URLs filled in.

     

    I show it is currently set to:

     

    (@controlID, 'N',     'Hyperlinks', 'default.aspx?pg=vmdetail&vm={ENTITY_NAME},default.aspx?pg=vhostdetail&vhost={Physical_HOST},,,,,'),

     

    The correction is to add one more comma to this line:  (shown below)

     

    (@controlID, 'N', 'Hyperlinks', 'default.aspx?pg=vmdetail&vm={ENTITY_NAME},default.aspx?pg=vhostdetail&vhost={Physical_HOST},,,,,,'),

     

    This should fix the problem and allow export to CSV.

     

    !!! Backup the original file BEFORE editing it!!!

     

    To make this change active after saving the change in the file they must reload the MySQL_VMWARE_CORE.SQL file into CCR.

     

    1.  Open MS_DOS box on CCR server.
    2. CD  C:\NETQOS\portal\Integration\DataManager
    3. mysql netqosportal < .\sql\MySQL_VMWARE_CORE.sql
    4. Test the view again


  • 5.  Re: VM Usage Summation CCR Report does not export CSV data

    Broadcom Employee
    Posted Nov 21, 2017 02:20 PM

    Hi Kip,

    Success!!! It's working!!!

     

    Thank you very much