++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++
Hi, You should check the version of the client you are using. We are currently on 7.0.1 patch 002 and some of our reports take forever to run. After some investigation, we have found that the client issues loads of API calls to get definitions while running the report. We were then advised by support to upgrade to client patch 008 and when running the same report through that client, the response is much faster. Something worth having a look at. Regards Jiri Pospisil -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: 10 February 2009 01:16 To: arslist@ARSLIST.ORG Subject: Re: Somebody please run this ITSM 7 report for me 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 <jha...@gmail.com> wrote: > From: jham36 <jha...@gmail.com> > Subject: Re: Somebody please run this ITSM 7 report for me > To: arslist@ARSLIST.ORG > 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 > <ars_l...@yahoo.com> 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" ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited. If you are not an intended recipient please delete this e-mail and notify postmas...@lchclearnet.com. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited makes no contractual commitment save where confirmed by hard copy. LCH.Clearnet Limited accepts no liability, including liability for negligence, in respect of any statement in this email. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com ************************************************************************************************* _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"