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

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
    1631 Posts
    ACCEPTED ANSWER

    Re: Analyzer fails reading CPU data

    ‏2012-10-16T20:27:36Z  in response to gorbai
    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
      ACCEPTED ANSWER

      Re: Analyzer fails reading CPU data

      ‏2012-10-17T16:18:44Z  in response to nagger
      I am using nmon analyser v3.4a and excel 2007.
      • SystemAdmin
        SystemAdmin
        2402 Posts
        ACCEPTED ANSWER

        Re: Analyzer fails reading CPU data

        ‏2013-02-06T09:06:57Z  in response to gorbai
        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