Topic
  • 3 replies
  • Latest Post - ‏2013-02-06T09:06:57Z by SystemAdmin
gorbai
gorbai
2 Posts

Pinned topic Analyzer fails reading CPU data

‏2012-10-10T16:37:55Z |
When trying to analyze an nmon file, I get the following error

runtime error 9
Subscript out of range
The debugger takes me to this section of the code

If Worksheets(1).Name "SYS_SUMM" Then
Worksheets(1).Move After:=Sheets("ZZZZ")
End If
I am using the following command to create the nmon files
/usr/bin/nmon -F /perfstats/nmon_stats/${HOST}_$DATE.nmon -d -T -s 600 -c 144 >> $LOG 2>&1

AIX version is 6100-06-05-1115

Any advice would be appreciated
Updated on 2013-02-06T09:06:57Z at 2013-02-06T09:06:57Z by SystemAdmin
  • nagger
    nagger
    1639 Posts

    Re: Analyzer fails reading CPU data

    ‏2012-10-16T20:27:36Z  
    Hi,
    Are you using the latest nmon Analyser 3.4a ?
    Get it from http://tinyurl.com/nmonanalyser
    thanks Nigel

    ps: if that does not help what Excel version are you using?
  • gorbai
    gorbai
    2 Posts

    Re: Analyzer fails reading CPU data

    ‏2012-10-17T16:18:44Z  
    • nagger
    • ‏2012-10-16T20:27:36Z
    Hi,
    Are you using the latest nmon Analyser 3.4a ?
    Get it from http://tinyurl.com/nmonanalyser
    thanks Nigel

    ps: if that does not help what Excel version are you using?
    I am using nmon analyser v3.4a and excel 2007.
  • SystemAdmin
    SystemAdmin
    2402 Posts

    Re: Analyzer fails reading CPU data

    ‏2013-02-06T09:06:57Z  
    • gorbai
    • ‏2012-10-17T16:18:44Z
    I am using nmon analyser v3.4a and excel 2007.
    I've also faced the same problem. After quite a bit of debugging I think I've found the root cause.
    If you run nmon for a period which is less than 1 unit of measurement, the resultant report will have this issue.

    i.e. if you run nmon -p -s5 -c100
    and then stop nmon before 5 seconds, then the report encounters the issue mentioned.

    Seems to be no workaround.

    cheers,
    Prasanna