Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Best way to get a consolidated log?
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Best way to get a consolidated log?
 Login/Join
 
Master
posted
I have a process flow that runs process flows that run data flows. It's a big process that moves hundreds of tables.

Is there a way to get a consolidated text file of all of the logs of all of the units that run? Data Migrator seems to do me the favor of breaking each into an individual piece and I don't want to have to consolidate all of them.

This message has been edited. Last edited by: Tamra,



 
Posts: 837 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
Member
posted Hide Post
This can be done by setting the individual property of the data flow to be 'Run as a Stored Procedure'.

This is dangerous however as it has an affect on variables if used in the data flow(s) as well as the 'State' of the data flow. It also makes debugging quite difficult since all the logs are in one log. As well, this cannot be done when flows are being called as part of a parallel process.

One alternative to this is to look at the DM log file on the file system. If the DM log was re-created each time this process is executed, then you would have a single text file that contained the log information from the process flow.

I would definitely go this route, given the reasons given above.

Jim
 
Posts: 5 | Registered: August 01, 2007Reply With QuoteReport This Post
Master
posted Hide Post
At the moment I've written a table file request against the ETLLOG to pull what I need, based on the timestamps of the run. It isn't perfect, but it's sufficient.



 
Posts: 837 | Location: At the Mast | Registered: May 17, 2007Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] Best way to get a consolidated log?

Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.