Greetings... I am attempting to use the MERGE option with nmon analyser v34a.xls, but I receive the following error:
"Run-time error '5': Invalid procedure call or argument
I then click on the "Debug" button, and it points to this line in the code:
Line 933: "Name Filename As aa0"
I receive the error when trying to process two files, as well only trying to process one file (with the MERGE option set to YES).
The NMON files that I am attempting to process were produced by running the following command:
# topasout -a <topasrec file>
Which, in turn, creates a "csv" file.
The topasrec files were produced by the following command running via the "xmdaily" entry in /etc/inittab:
/usr/bin/topasrec -L -s 300 -R 1 -r 7 -o /etc/perf/daily/ -ypersistent=1 -O type=bin -ystart_time=20:52:18,May29,2013
Each processed "topasout" file is 6348 lines. I have done no post-processing on those files (sorts, etc).
The server running topasrec is at AIX 6100-07-06-1241
The version of bos.perf.tools is at: 188.8.131.52
I have attempted to process the NMON files transferred via FTP in both ascii and binary mode, just in case.
I am attempting this on a corporate laptop running Windows XP Pro, Version 2002, SP 3.
The Microsoft Excel versions that I have tried are 2003, 2007, and 2010, all published to my XP laptop via Citrix; and I receive the same error for each Excel version I attempt
I have also attached the copy of the "nmon analyser v34a.xls" file that I am using, as well as copies of the "NMON" files (produced via topasrec command), both the "ftp ascii" files and the "ftp binary" files.
I have reviewed the User Guide, the forums here, as well as some various Google searches; however, I've yet to hit upon this as a known issue.
Not quite sure why the MERGE is producing this error on me..
Any suggestions would be appreciated...