1
Vote

SSIS Performance Visualization Index out of range

description

Hello,   I have succefully utilized the SSIS Performance Visualization before and loved it. However when I have tried lately I have been receiving multiple index out of range popup errors. I have uninstalled and re-installed BIDS Helper to no avail. I wlll get 2 or 3 popups during an execution and the display will have missing data.   This is with BIDS 2008 - here's the about information: ----------------------------- Microsoft Visual Studio 2008 Version 9.0.30729.4462 QFE Microsoft .NET Framework Version 3.5 SP1   Installed Edition: Enterprise   Microsoft Visual Basic 2008 Microsoft Visual Basic 2008   Microsoft Visual C# 2008 Microsoft Visual C# 2008   Microsoft Visual C++ 2008 Microsoft Visual C++ 2008   Microsoft Visual Studio 2008 Team Explorer Microsoft Visual Studio 2008 Team Explorer Version 9.0.30729.4413   Microsoft Visual Studio 2008 Tools for Office Microsoft Visual Studio 2008 Tools for Office   Microsoft Visual Studio Team System 2008 Architecture Edition Microsoft Visual Studio Team System 2008 Architecture Edition   Microsoft Visual Studio Team System 2008 Database Edition GDR Microsoft Visual Studio Team System 2008 Database Edition GDR Version 9.1.40413.00   Microsoft Visual Studio Team System 2008 Development Edition Microsoft Visual Studio Team System 2008 Development Edition   Portions of International CorrectSpell™ spelling correction system © 1993 by Lernout & Hauspie Speech Products N.V. All rights reserved.   The American Heritage® Dictionary of the English Language, Third Edition Copyright © 1992 Houghton Mifflin Company. Electronic version licensed from Lernout & Hauspie Speech Products N.V. All rights reserved.     Microsoft Visual Studio Team System 2008 Test Edition Microsoft Visual Studio Team System 2008 Test Edition   Microsoft Visual Studio Tools for Applications 2.0 Microsoft Visual Studio Tools for Applications 2.0   Microsoft Visual Web Developer 2008 Microsoft Visual Web Developer 2008   Crystal Reports AAJ60-G0MSA4K-68000CF Crystal Reports Basic for Visual Studio 2008     Enterprise Library v5 Configuration Editor 4.0 Microsoft patterns & practices Enterprise Library v5 Configuration Editor   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB946260) KB946260 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946260.   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB946458) KB946458 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946458.   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB947171) KB947171 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947171.   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB947180) KB947180 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947180.   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB948816) KB948816 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/948816.   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB953318) KB953318 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/953318.   Hotfix for Microsoft Visual Studio 2008 Team Explorer - ENU (KB954435) KB954435 This hotfix is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/954435.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB944899) KB944899 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/944899.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB945282) KB945282 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/945282.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB946040) KB946040 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946040.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB946308) KB946308 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946308.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB946344) KB946344 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946344.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB946581) KB946581 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946581.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB947173) KB947173 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947173.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB947540) KB947540 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947540.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB947789) KB947789 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947789.   Hotfix for Microsoft Visual Studio Team System 2008 Development Edition - ENU (KB948127) KB948127 This hotfix is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/948127.   Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB2465361) KB2465361 This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/2465361.   Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB2538241) KB2538241 This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/2538241.   Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB946673) KB946673 This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/946673.   Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB953256) KB953256 This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/953256.   Hotfix for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB971092) KB971092 This hotfix is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this hotfix will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/971092.   Microsoft Visual Studio 2008 Team Explorer - ENU Service Pack 1 (KB945140) KB945140 This service pack is for Microsoft Visual Studio 2008 Team Explorer - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/945140.   Microsoft Visual Studio Team System 2008 Development Edition - ENU Service Pack 1 (KB947888) KB947888 This service pack is for Microsoft Visual Studio Team System 2008 Development Edition - ENU. If you later install a more recent service pack, this service pack will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/947888.   Process Editor WIT Designer 1.4.0.0 Process Editor for Microsoft Visual Studio Team Foundation Server, Version 1.4.0.0   Security Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB2251487) KB2251487 This security update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this security update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/2251487.   Security Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB972222) KB972222 This security update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this security update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/972222.   Security Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB973675) KB973675 This security update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this security update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/973675.   SQL Server Analysis Services Microsoft SQL Server Analysis Services Designer Version 10.50.2500.0   SQL Server Integration Services Microsoft SQL Server Integration Services Designer Version 10.50.2500.0   SQL Server Reporting Services Microsoft SQL Server Reporting Services Designers Version 10.50.2500.0   Team Foundation Server Power Tools October 2008 Power Tools that extend the Team Foundation Server integration with Visual Studio.   Team Foundation Sidekicks 2.2 Team Foundation Sidekicks utilities package   Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB956453) KB956453 This update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/956453.   Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB967143) KB967143 This update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/967143.   Update for Microsoft Visual Studio Team System 2008 Team Suite - ENU (KB974558) KB974558 This update is for Microsoft Visual Studio Team System 2008 Team Suite - ENU. If you later install a more recent service pack, this update will be uninstalled automatically. For more information, visit http://support.microsoft.com/kb/974558.   BIDSHelper BIDS Helper 2008 - An Addin to extend BI Development Studio (c) 2009 Version 1.5.0.0 http://www.codeplex.com/bidshelper -----------------------------   Any ideas/help would be greatly appreciated.   Thank you,   Aaron Lowe @Vendoran

file attachments

comments

furmangg wrote Aug 17, 2011 at 8:03 PM

Looks like our code that's reading in the log file is running into an issue. Can you do the following to grab a copy of the log files in question, zip them and attach them to this issue?

Start... run... %temp%
Then run SSIS Performance Visualization.
I believe it will create a new directory inside that temp directory
As soon as you get an error, quick as a bunny copy and paste that directory it created to somewhere else. Then zip it up and attach it to this issue.

Studying the code involved, I see a few places where this error is likely being thrown. I should be able to prevent the error, but I want to understand what's being logged since what's being logged is unexpected.

Thanks for your help.

AaronL wrote Aug 17, 2011 at 8:40 PM

See attached, 2 tmp files. Also if it makes a difference I do have SSIS Multiple Hash installed and running in this package as well - http://ssismhash.codeplex.com/.

Thank you,

--Aaron

furmangg wrote Aug 18, 2011 at 7:58 PM

Thanks. I could repro the error with the attached log files. Looking into it.

When you run that package in debug mode inside BIDS, on the data flow named Hierarchy, can you tell me how many rows were pumped through each path on the Hierarchy data flow? Basically I'm asking for you to tell me the numbers you see on the screen in BIDS once the package finishes running in debug mode. Just making sure what I'm seeing in the log is right since I only see rows flowing from the "Lookup Review" output into the input of "Lookup". That seemed odd to me.

furmangg wrote Aug 18, 2011 at 9:48 PM

Also, when you run the package in debug mode, can you confirm whether or not the two source components in the Hierarchy data flow change color or not. The reason I wonder is that BIDS uses the same events to change the color of the components on the screen during execution. So if the events in question are missing for it in addition to missing in the log file you sent me, that's a clue.

furmangg wrote Aug 23, 2011 at 3:53 PM

Thanks for reporting this bug. We've researched this and made a few tweaks in the code that will hopefully prevent this particular error message.

But the main problem we found is that some versions of SSIS weren't logging all the proper events. For example, I could reproduce the problem you were having on SQL2008 SP2. But installing SQL2008 SP3 (the CTP just came out) fixed the problem.

We're checking with a Microsoft contact to see when they plan on fixing this bug in SQL 2008 R2. I'll post back here what we hear.

AaronL wrote Aug 23, 2011 at 8:38 PM

Thanks for the follow up.