I have a report that has 55 data providers. I have found that if one of my queries fails, the report still comes back as successfully run. Is there anyway I can put a trace on the queries to find their start and end run times as well as if they ran successfully or not? I would like to put this into a log file if possible.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trace queries and put in log file
- Thread starter khansen97
- Start date
- Thread starter
- #3
You can look the details up as Sri suggested , but writing them to a log file is another matter. You may want to have a word with the DBA if he can record this information at the database level .....
T. Blom
Information analyst
tbl@shimano-eu.com
T. Blom
Information analyst
tbl@shimano-eu.com
On a side note. 55 data providers is ridulously high.
You must be getting terrible performance out of this.
My guess is it takes 10 minutes to open this document and navigate between tabs.
You should look at consolidating your DPs.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
You must be getting terrible performance out of this.
My guess is it takes 10 minutes to open this document and navigate between tabs.
You should look at consolidating your DPs.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
- Thread starter
- #8
I am trying to put in Union queries as much as I can, but they have time period filters up the wall and Business Objects takes forever to generate the report so we are trying to have everything done on the database side.
It takes about 5 minutes to generate the report and about 2 minutes to switch betweene each tab. I am really stuggling with trying to combine the data providers.
It takes about 5 minutes to generate the report and about 2 minutes to switch betweene each tab. I am really stuggling with trying to combine the data providers.
I suppose both Steve and me are having a hard time figuring out what kind of BO document would have 55 DP's to work with. Don't get me wrong, we haven't seen the document, so it is a bit speculating, but I have a flashback of a user not aware of using sections who created a seperate DP for every section value. The report obviously was a pain to work with.
Are you not overseeing something fundamental or are there so many sources to get data from?
What do you mean with time period filters up the wall?
T. Blom
Information analyst
tbl@shimano-eu.com
Are you not overseeing something fundamental or are there so many sources to get data from?
What do you mean with time period filters up the wall?
T. Blom
Information analyst
tbl@shimano-eu.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question