This project is read-only.


Runtime error using MOSS 2007


Running PAL v1.3 Beta 5 against Microsoft MOSS 2007 data and receive the error message:
PAL.vbs(2495, 17) Microsoft VBScript runtime error: Subscript out of range: 'UBound'
The BLG file is 15MB in size.
Closed Aug 30, 2008 at 5:21 PM by ClintH
No response from the user in months. Try the latest version of PAL and repost the error if it occurs again.


ClintH wrote May 13, 2008 at 6:56 AM

This is occuring during threshold analysis. Can you tell me which threshold it was analyzing at the time or can you send me your %temp%{GUID}PAL.log file?

ffmatyas wrote May 20, 2008 at 4:18 PM


Im getting the same message:

SELECT QUANTIZE([(PDH-CSV 4.0) (W. Europe Daylight Time)(-120)], 180) AS Interval, MIN(TO_REAL([\CHBBLCES908\LogicalDis
k(C:)\Avg. Disk sec/Write])) AS min, AVG(TO_REAL([\servername\LogicalDisk(C:)\Avg. Disk sec/Write])) AS avg, MAX(TO_RE
AL([\servername\LogicalDisk(C:)\Avg. Disk sec/Write])) AS max FROM D:\DOCUME~1\aaaxxx\LOCALS~1\Temp{3229D277-EED1-4AE
D-B54B-56C8178A4A11}_FilteredPerfmonLog.csv GROUP BY Interval
D:\Program Files\PAL\PAL v1.3 Beta 5\PAL.vbs(2521, 25) Microsoft VBScript runtime error: Subscript out of range: 'oAnaly

this is the last entry in the guidpal.log
[20.05.2008 16:51:00] SELECT QUANTIZE([(PDH-CSV 4.0) (W. Europe Daylight Time)(-120)], 180) AS Interval, MIN(TO_REAL([\CHBBLCES908\LogicalDisk(C:)\Avg. Disk sec/Write])) AS min, AVG(TO_REAL([\CHBBLCES908\LogicalDisk(C:)\Avg. Disk sec/Write])) AS avg, MAX(TO_REAL([\CHBBLCES908\LogicalDisk(C:)\Avg. Disk sec/Write])) AS max FROM D:\DOCUME~1\xz1zd9\LOCALS~1\Temp{3229D277-EED1-4AED-B54B-56C8178A4A11}_FilteredPerfmonLog.csv GROUP BY Interval

do you need more info about this?

Best Regards,
Ferenc Matyas

DanFriesen wrote May 21, 2008 at 9:53 PM

SELECT QUANTIZE([(PDH-CSV 4.0) (Mountain Daylight Time)(360)], 240) AS Interval, MIN(TO_REAL([\CACGSCPSP521\Web Service(_Total)\Connection Attempts/sec])) AS min, AVG(TO_REAL([\CACGSCPSP521\Web Service(_Total)\Connection Attempts/sec])) AS avg, AX(TO_REAL([\CACGSCPSP521\Web Service(_Total)\Connection Attempts/sec])) AS max FROM D:\DOCUME~1\nzvph7\LOCALS~1\Temp{28133E71-8D4F-45EC-9F0D-ACB57DE57FD1}_FilteredPerfmonLog.csv GROUP BY Interval

I believe my issue is related to trying to capture 64bit performance data with a 32bit machine. The .net counters were part of the object set for these servers and a 32bit machine will not capture the 64bit .net counters.

ClintH wrote Jun 3, 2008 at 4:54 AM

Collecting 64-bit counters remotely using a 32-bit computer should work fine. We did that a lot recently in the labs.

The UBound error on line 2495 is odd. I even check the count size of the array before attempting a UBOUND on it.

If you are up for it, try debugging the script by executing it under CScript with the //X argument. This will load the script into the debugger, then let it run until this error occurs. This works great if you have Visual Studio 2003, 2005, or other third party script debuggers. Otherwise, you may just need to send me the BLG file directly, so I can debug it.



wrote Aug 30, 2008 at 5:21 PM

wrote Feb 22, 2013 at 1:47 AM

wrote May 16, 2013 at 12:56 PM