James, Thank you for the info. You and I are on the same boat. But I can't fault the report design, because another lister is getting pretty good performance.
--- On Mon, 2/9/09, jham36 <[email protected]> wrote: > From: jham36 <[email protected]> > Subject: Re: Somebody please run this ITSM 7 report for me > To: [email protected] > Date: Monday, February 9, 2009, 5:43 PM > I gave up. It returned an error about "Failed to > retrieve data from > the database" I ran it agian and it should have > reported back about > 1100 records. I let that run for 15 minutes. I had to > stop my > aruser.exe process. I have not had much luck with these > canned > reports either. Sorry I couldn't complete the report, > but I need to > go home. > > James > > On Feb 9, 2:04 pm, Rabi Tripathi > <[email protected]> wrote: > > Hi all, > > I have complaints of slow or never-ending reporting in > ITSM 7. After a lot of looking around, I am wondering if the > inherent design of the reports is a big factor. Such as a > Join done in the report (with a subreport), ODBC overhead > etc. > > > > Can somebody run this report for me and tell me how > long it takes. If you can use Remedy User instead of a > browser and do this on a powerful box (may I suggest > production?) that would be nice-- > > > > Incident Management Console->Reports > > > > On "ReportSelection" popup choose this > "Report Name": > > Incident->Incident Information->All > Incidents->Incicent Details By Date Range > > > > For "Start Date" and "End Date" > select dates that would give you at least 500 Incidents in > your environment. Closer to 1000 would be nice. > > > > Choose "Destination" = "Screen" > > > > Click "Run Report" and start your "Stop > Watch" > > > > On the prompt asking for titles, just click > "Ok" > > > > Let me know: > > (1) how long until the report completes...meaning > ReportViewer pop-up has finished loading all data (hint > where it shows page info like this "1/6+", > presence of "+" means its still loading more. > > > > (2) how many Incidents did you catch > > > > (3) does your report have "work info" > included for incidents? > > > > (4) Quick detail of your environment. The network path > between your PC and the server, how "strong" is > the AR Server/Database > > > > Ok, it's quite some work...but may I plead that I > would do this for you? :) > > > > If you want to be really nice to me, if you could do > the same report such that your date criteria catches no > Incidents at all, how much time till the Report windows > shows up and completes loading with no info on the report? > > > > Thank you in advance. > > > > > _______________________________________________________________________________ > > UNSUBSCRIBE or access ARSlist Archives > atwww.arslist.org > > Platinum Sponsor: RMI Solutions ARSlist: "Where > the Answers Are" > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: RMI Solutions ARSlist: "Where the > Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
