Delphix Toolkits (dxToolkit and dxmToolkit)

 View Only
  • 1.  dxanalyse

    Posted 02-12-2020 09:15:00 AM
      |   view attached
    Hi everyone,

    Is there anyone here using dxanalytics? Its a really cool project that helps you visualize the analytics data you can get from Delphix Engine using dx_get_analytics


    The problem I am facing with this tool is when I get full analysis report from the Engine and put it into dxanalyse, it produces a report saying that "There is no NFS/ISCSI data available". 

    I checked the files, they are in the right place. I also tried to run with previous analysis files that also failed.

    I suspect that it is related to the MS Office version I am using (I have Office365). 

    Did any of you had same problem? How did you solve it?

    BR,
    -Rahim

    ------------------------------
    BR,
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    Accuras, Turkey
    ------------------------------


  • 2.  RE: dxanalyse

    Posted 02-12-2020 09:58:00 AM
    Edited by Mouhssine Saidi 02-12-2020 10:00:56 AM
    Hi Rahim,

    Can you confirm please you have those workbooks in your folder files that ends with"-analytics-nfs-raw.csv" and "-analytics-iscsi-raw.csv" and have data on them ?

    What version are you using

    From the vba code of the v8 i saw the following conditions that check if there is any NFS/SCSI data to analyze.

    If NFSRowCount > 2 Then
    ErrorCondition = 1
    protocol_type = "NFS"
    nfs_protocol = True
    MaxNFSLatency = Get_MaxLatency(Analytic_name, "nfs")
    End If

    If ISCSIRowCount > 2 Then
    ErrorCondition = 1
    protocol_type = "ISCSI"
    iscsi_protocol = True
    MaxISCSILatency = Get_MaxLatency(Analytic_name, "iscsi")
    End If

    If ErrorCondition = 0 Then
    MsgBox " There is no NFS/ISCSI data available for this engine. Please review the dx_get_analytics output and try again"
    End If

    So it falls to the error because it didn't found any data on files.

    You can also try to debug the VBA code of the DXanalyzer by setting some breakpoints to see where it fails.

    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 3.  RE: dxanalyse

    Posted 02-13-2020 12:57:00 AM

    Hi Mouhssine,

     

    I have checked all of those points you have mentioned. I have also checked if there are NFS files with correct name and if those NFS files have anything in them.

     

    Same as you suggested I also checked the code via Debug and saw the exact same line you mentioned:

     

    If NFSRowCount > 2 Then
    ErrorCondition = 1
    protocol_type = "NFS"
    nfs_protocol = True
    MaxNFSLatency = Get_MaxLatency(Analytic_name, "nfs")
    End If

    If ISCSIRowCount > 2 Then
    ErrorCondition = 1
    protocol_type = "ISCSI"
    iscsi_protocol = True
    MaxISCSILatency = Get_MaxLatency(Analytic_name, "iscsi")
    End If

    If ErrorCondition = 0 Then
    MsgBox " There is no NFS/ISCSI data available for this engine. Please review the dx_get_analytics output and try again"
    End If
    The code sets ErrorCondition = 0 in the beginning and then changes the value to 1 based on the checks. Looks ok. But somehow, that's why I asked whether this might be related to Office version, ErrorCondition is not updated and it goes on and gives error.

     

    Dxanalytics is a great tool but being written in Excel makes it problematic. I guess it would be great if someone would port it to asp.net or something (maybe Google Docs) so that it can become platform independent.

     

     

    BR,

     

    Rahim Cetinel

    Solution Architect | Delphix Blackbelt

    M:+905334112490   | Skype: rahim.cetinel

    www.accuras.com

     

     

     






  • 4.  RE: dxanalyse

    Posted 02-13-2020 02:55:00 AM
    Hi Rahim,

    Would you mind for sharing nfs and scsi file with me, i will try to look at on it for you.

    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------



  • 5.  RE: dxanalyse

    Posted 02-18-2020 12:58:00 AM
    Hi everyone,

    Just want to give the update. With Mouhssine's suggestion I have checked the code and found out that the Excel macro cannot parse the complex directory structure.
    Moved the files and got the results.
    Thanks a lot Mouhssine.

    ------------------------------
    BR,
    Rahim Cetinel
    Solution Architect | Delphix Blackbelt
    Accuras, Turkey
    ------------------------------



  • 6.  RE: dxanalyse
    Best Answer

    Posted 02-18-2020 03:05:00 AM
    Hello World,

    As an addendum to Rahim's last comment, the follwing paragraphe extracted from the factsheet of dx_analyze on github  "https://community.delphix.com/communities/communityhome/digestviewer/viewthread?MessageKey=05be02d5-a7fa-4377-8824-0e15946186dd&CommunityKey=3ec0f05d-bfbf-4206-9b1a-66496eed1147&tab=digestviewer#bm05be02d5-a7fa-4377-8824-0e15946186dd"

    States that you need to have all file (*.csv, xlsb and pptm) under the same folder to get it working right

    3.0 DXANALYZE PREPARATION
    Copy both the dxanalyze_v8.xlsb and Engine_Analysis_
    Template_v8.pptm into the location where the raw data (csv
    files generated with dx_get_analyze) excel files are located.

    Regards,

    Mouhssine

    ------------------------------
    Mouhssine SAIDI
    Community Member
    Delphix Community Members
    ------------------------------