2
Vote

I can´t see the trees

description

Hi, when I execute SSIS Performance Visualization, I can´t see any trees detail in 'Statistics Grid', I only see Data Flow Task line, but there is not any line below it.
My package is executed OK.
 
More over, only 'Duration' column has some figures (all other the columns are blanks)
 
What I miss?
 
(good job with BIDS Helper, it´s really cool!!)

file attachments

comments

furmangg wrote May 10, 2011 at 7:49 PM

Hmm. That doesn't seem right. What version of SSIS? And can you attach the dtsx file to this issue, please?

RURIA wrote May 11, 2011 at 7:42 AM

SSIS 2008 R2 (10.50.1600)
This package was developed originally on 2005, maybe that´s a important thing (I don´t know at all)
I´m using Firebird ODBC Driver 1.2 (http://www.firebirdtest.com/en/odbc-driver/)
... I don´t Know what you need to test, let me know.

Thanks.

furmangg wrote May 12, 2011 at 3:29 PM

I took a look at the package and didn't spot anything obviously wrong yet. Can you do two tests for me?
  1. Can you add an Execute SQL task to the end of the package (so it runs after the data flow) and have it run this SQL: WAITFOR DELAY '00:02'
    Then run Visualize Performance feature. Give it 1 minute to finish the data flow, then do Start... Run... %TEMP%. Sort by date modifed and copy the most recent .tmp file. Paste it onto the desktop (since it will disappear from the TEMP directory after the 2 minute delay finishes). Open it up in Notepad and make sure it's a log file with SSIS log events. Then attach it to this thread.
  2. Create a new package in BIDS 2008 R2 and create a simple data flow with a source and a destination. Then run the Visualize Performance feature and make sure it works and shows the execution tree.
Hope these troubleshooting steps can help me figure out the problem.

RURIA wrote May 14, 2011 at 2:29 PM

Hi furmangg, i did it and nothing happended ;-(
First, I added a delay SQL task (I called it "furmangg task" for simplicity) and I didn´t see any tree. File tmp9FB1.tmp is the event log for that.

I created a silly package (in the same project) and when I run "Execute a Visualize Performance" I got an error, Error.png is the screenshot for that. I´ll try translate it (I´m running spanish)

"It can´t load the package. Error =xC0011008 "Error loading from XML. There is not detailed information... It happens if there is an error in CPackages::LoadFromXML.. "



After that, I created a new package (in a new project) no error, but no trees either.

RURIA wrote May 14, 2011 at 2:29 PM

Error

RURIA wrote May 14, 2011 at 2:30 PM

Log event

furmangg wrote May 14, 2011 at 4:34 PM

It is successfully logging the events we needed. That's hilarious. It's in Spanish! So we'll have to go back to the drawing board on how we parse those execution trees and other events.

User:PipelineExecutionTrees,,,DFT Load Product,{489FFD78-6F0C-4703-88C2-612039F9726C},,14/05/2011 15:57:08,14/05/2011 15:57:08,0,0x,Iniciar ruta de acceso 0
salida "Salida de origen de ADO NET" (5624); componente "Articulos Source" (5619)
entrada "Input 0" (6660); componente "STAT Articulos Source" (6650)
salida "Output 0" (6661); componente "STAT Articulos Source" (6650)
entrada "Entrada de columna derivada" (5935); componente "DER Articulos" (5934)
salida "Salida de columna derivada" (5936); componente "DER Articulos" (5934)
entrada "Entrada de Unión de todo 2" (6453); componente "Unión de todo" (6434)
Finalizar ruta de acceso 0

I'll update this thread if we make progress fixing this issue. I think you've given me enough info to be able to troubleshoot this issue.

Regarding the new package you created, that looks like a plain SSIS error. Did you have the package encrypted by a password or something else that would prevent the object model from being able to load the dtsx package off disk?

TejinaKid wrote Jun 29, 2012 at 11:05 AM

I have the same problem. Is there any fix or update?.

Thanks

furmangg wrote Jun 30, 2012 at 3:27 PM

For those experiencing an issue with this feature, if you have SSIS installed in a non-english language, you're hitting the problem described in this issue report. We have not yet fixed this, and honestly, I don't know how we'll be able to fix it very easily. For now, BIDS Helper only supports English.

If you are running English, then it may be another issue. This thread discusses a bug in SSIS2008 SP2 which was fixed in SSIS2008 SP3. I'm unsure frankly whether this issue impacts SSIS2008 R2 or SSIS2012. http://bidshelper.codeplex.com/workitem/31275

TejinaKid wrote Jul 2, 2012 at 8:58 AM

Ok, thanks for your response.