Tauf, Do me a favor please and check the version/patch of the Remedy ODBC driver in the crystal box.
See another posting under the same subject I just sent a minute ago. Very inefficient queries are being done during the report operation. Assuming that ITSM 7 report's design is already optimum, Remedy ODBC's behavior is the current suspect. James, can you check your ODBC version/patch in your Crystal box as well, please? --- On Mon, 2/9/09, Chowdhury, Tauf <[email protected]> wrote: > From: Chowdhury, Tauf <[email protected]> > Subject: Re: Somebody please run this ITSM 7 report for me > To: [email protected] > Date: Monday, February 9, 2009, 7:45 PM > For your first question, I didn't get the + symbol at > all. After the time I gave you, the report page displayed > with 1/253 pages. > > For the 2nd question, the CSV export was done on all fields > on the incident form for that qualification which returned > 2138 records. The time to completion was: 2 minutes, 38 > seconds. > > > Tauf Chowdhury > Analyst, Service Management > Office: 631.858.7765 > Mobile:646.483.2779 > > > > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[email protected]] On Behalf Of Rabi Tripathi > Sent: Monday, February 09, 2009 7:38 PM > To: [email protected] > Subject: Re: Somebody please run this ITSM 7 report for me > > Wow, that puts my system to shame. How many pages did you > get in the report? > > Can you please confirm that you waited until info about all > the incidents were loaded on the "Report Preview" > screen and that the page counter such as "1/7+" > did not have the "+" sign any more? > > One last favor...can you pleas use the same search criteria > on Incident screen and report on all the incidents, and > report on all fields to a csv file and tell me how long for > that csv report to complete? > > I want to confirm my theory that I have general slowness in > my setup compared to yours, that accounts for all or a big > part of the report slowness here? > > Thanks a lot for trying this out for me. > > > --- On Mon, 2/9/09, Chowdhury, Tauf > <[email protected]> wrote: > > > From: Chowdhury, Tauf <[email protected]> > > Subject: Re: Somebody please run this ITSM 7 report > for me > > To: [email protected] > > Date: Monday, February 9, 2009, 5:52 PM > > Rabi, > > Here's the qualification I ran on that canned > report > > (in user tool): > > ('1000000560' >= "02/01/09 12:00:00 > > AM" AND '1000000560' <= "02/09/09 > > 5:43:53 PM") > > > > It returned 2138 records and it took 1 minute, 12 > seconds. > > Work info IS included in my system. > > > > I am currently in the same building as the datacenter > that > > houses both the App servers and DB server. Obviously, > the DB > > is remote to the application. DB is oracle. > > Our App servers are virtual servers on Win2k3 with 8gb > of > > RAM and Quad 3ghz xeon processors. > > Not too sure about the DB but it is running on an AIX > > cluster with a Gig Ethernet link. > > Hope this helps. > > > > > > Tauf Chowdhury > > Analyst, Service Management > > Office: 631.858.7765 > > Mobile:646.483.2779 > > > > > > > > -----Original Message----- > > From: Action Request System discussion list(ARSList) > > [mailto:[email protected]] On Behalf Of Rabi > Tripathi > > Sent: Monday, February 09, 2009 2:04 PM > > To: [email protected] > > Subject: Somebody please run this ITSM 7 report for me > > > > 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 at > www.arslist.org > > Platinum Sponsor: RMI Solutions ARSlist: "Where > the > > Answers Are" > > > > > ********************************************************************** > > This e-mail and its attachments may contain Forest > > Laboratories, Inc. proprietary information that is > > privileged, confidential or subject to copyright > belonging > > to Forest Laboratories, Inc. This e-mail is intended > solely > > for the use of the individual or entity to which it is > > addressed. If you are not the intended recipient of > this > > e-mail, or the employee or agent responsible for > delivering > > this e-mail to the intended recipient, you are hereby > > notified that any dissemination, distribution, copying > or > > action taken in relation to the contents of and > attachments > > to this e-mail is strictly prohibited and may be > unlawful. > > If you have received this e-mail in error, please > notify the > > sender immediately and permanently delete the original > and > > any copy of this e-mail and any printout. > > > > > _______________________________________________________________________________ > > 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 e-mail and its attachments may contain Forest > Laboratories, Inc. proprietary information that is > privileged, confidential or subject to copyright belonging > to Forest Laboratories, Inc. This e-mail is intended solely > for the use of the individual or entity to which it is > addressed. If you are not the intended recipient of this > e-mail, or the employee or agent responsible for delivering > this e-mail to the intended recipient, you are hereby > notified that any dissemination, distribution, copying or > action taken in relation to the contents of and attachments > to this e-mail is strictly prohibited and may be unlawful. > If you have received this e-mail in error, please notify the > sender immediately and permanently delete the original and > any copy of this e-mail and any printout. > > _______________________________________________________________________________ > 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"
