Re: WWRUG: Ok, I'm officially excited!
Is the hotel actually going to provide the services their Resort Fee says it's supposed to cover this year? Rick On Sat, Sep 11, 2010 at 9:12 PM, Kelly Deaver kdea...@kellydeaver.comwrote: Hi Gang, I just got back from a planning meeting with the Hard Rock Hotel in Las Vega. For those who were there last year, you are in for a surprise. The new tower is open and it brings with it a new night club, spa, larger pool, and a really fun restaurant. On a techie level, the wifi in the conference area is now a full 5 bars (picture me the geek walking around with my laptop checking it out). There will be an Internet cafe for those who don't want to drag their laptop downstairs. For those of you who've not been there, be prepared for a great conference location and a lot of awesome content. As part of my duties working with the vendors, I had to prepare a list for BMC of all items that various groups within BMC have agreed to do. I have to say, it is pretty impressive! To me it is all the technical goodness of a BMC sponsored event without the overdose of sales focus :) BMC is really being great working with us on this and I hope you will show up to take advantage of the opportunity! BMC's involvement - Bob Beauchamp - Key Note Speaker at the General Session on Tuesday October 19th. Doug Mueller -Speaker at the General Session on Wednesday October 20th and generally accessible for the conference to be Doug :) If you've not had one on one time with Doug, you've not experienced Remedy nirvana or changed your self on a technical level. Platinum Booth Sponsor - BMC will have a booth in the Technology Showcase where you can see the latest and greatest, get your questions answered, etc. Evening with Engineering Sponsor - BMC is sponsoring the event which includes dinner. BMC will also be providing engineers/experts in the tradition of RUGs past. Session Presenters - BMC is signed up to deliver the breakout sessions listed below. *BMC: What's New in AR System 7.6.03 *MidTier: Best Practices and Implementation for Optimal Performance *Richer UI Capabilities in AR System 7.6.03 *The New AR-Based, BMC Remedy Knowledge Management- One solution - One Vendor *What is new in ITSM version 7.6.03 *State of the Art Integration for AR System and Atrium *Accelerated Development using Developer Studio in AR System 7.6.03 *Tuning The Mid-Tier/Web Infrastructure for Hi-Performance and Troubleshooting Performance Issues *Life Beyond the Remedy User Tool: Why it's Safe to Leave it Behind *How to Build a Successful Service Request Management Solution *Localize Your AR System Applications using Developer Studio L10n Toolkit *Manage and Create Content for the AR System Home Page *Ad-Hoc Web Reporting for AR System 7.6.03 *Discover the new Full Text Search Infrastructure in AR System version 7.6 *User Interface Design Patterns in AR System *Lean Application Design: The Effects of Normalization *Extending Developer Studio with Custom Plugins *Protecting customizations or extensions across upgrades Executive Session Presenters - *Opening Session with Doug Mueller, Founder of the AR System. *Service Desk Optimization. *Enterprise Change Release Management. *Service Asset Lifecycle Management. As you can see, it is a pretty impressive list. With the release of the 7.6.03 products, I know I'm looking forward to what they have to tell us. See you in Vegas! ... only 6 weeks and counting Kelly Deaver L-3 Stratis / FAA Contractor kdea...@kellydeaver.com (ARSlist mail) kelly.ctr.dea...@faa.gov (Business mail) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Removing the field from Report
Hi, I wanted to know if there is any way by which Character field not get listed in the Field List of Repoting (Tools-Reporting) of ARUser itself?. I am not saying of selecting or removing field from Field List but to not to show the field in Field List itself? Please suggest if any way? -- View this message in context: http://old.nabble.com/Removing-the-field-from-Report-tp29684257p29684257.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: WWRUG: Ok, I'm officially excited!
The Venue is better than ever (and everyone loved it last year), The content is even better than last year (and everyone thought last year's reminded them of RUGs of old for the technical level). Yes what they say is covered by their resort fee will be provided and they have signed an addendum to fix all the (minor) issues from last year. There was also a major clause to cover our internet access, which as Kelly has mentioned seems to have been resolved by them already. We will have wired access when needed as well. The breakfasts are being kicked up a notch so everyone will have the energy for 12 hour days of BMC Remedy AR System and ITSM knowledge intake. Looking forward to seeing you all there! Dan www.wwrug10.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: September-13-10 7:17 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG: Ok, I'm officially excited! ** Is the hotel actually going to provide the services their Resort Fee says it's supposed to cover this year? Rick On Sat, Sep 11, 2010 at 9:12 PM, Kelly Deaver kdea...@kellydeaver.com wrote: Hi Gang, I just got back from a planning meeting with the Hard Rock Hotel in Las Vega. For those who were there last year, you are in for a surprise. The new tower is open and it brings with it a new night club, spa, larger pool, and a really fun restaurant. On a techie level, the wifi in the conference area is now a full 5 bars (picture me the geek walking around with my laptop checking it out). There will be an Internet cafe for those who don't want to drag their laptop downstairs. For those of you who've not been there, be prepared for a great conference location and a lot of awesome content. As part of my duties working with the vendors, I had to prepare a list for BMC of all items that various groups within BMC have agreed to do. I have to say, it is pretty impressive! To me it is all the technical goodness of a BMC sponsored event without the overdose of sales focus :) BMC is really being great working with us on this and I hope you will show up to take advantage of the opportunity! BMC's involvement - Bob Beauchamp - Key Note Speaker at the General Session on Tuesday October 19th. Doug Mueller -Speaker at the General Session on Wednesday October 20th and generally accessible for the conference to be Doug :) If you've not had one on one time with Doug, you've not experienced Remedy nirvana or changed your self on a technical level. Platinum Booth Sponsor - BMC will have a booth in the Technology Showcase where you can see the latest and greatest, get your questions answered, etc. Evening with Engineering Sponsor - BMC is sponsoring the event which includes dinner. BMC will also be providing engineers/experts in the tradition of RUGs past. Session Presenters - BMC is signed up to deliver the breakout sessions listed below. *BMC: What's New in AR System 7.6.03 *MidTier: Best Practices and Implementation for Optimal Performance *Richer UI Capabilities in AR System 7.6.03 *The New AR-Based, BMC Remedy Knowledge Management- One solution - One Vendor *What is new in ITSM version 7.6.03 *State of the Art Integration for AR System and Atrium *Accelerated Development using Developer Studio in AR System 7.6.03 *Tuning The Mid-Tier/Web Infrastructure for Hi-Performance and Troubleshooting Performance Issues *Life Beyond the Remedy User Tool: Why it's Safe to Leave it Behind *How to Build a Successful Service Request Management Solution *Localize Your AR System Applications using Developer Studio L10n Toolkit *Manage and Create Content for the AR System Home Page *Ad-Hoc Web Reporting for AR System 7.6.03 *Discover the new Full Text Search Infrastructure in AR System version 7.6 *User Interface Design Patterns in AR System *Lean Application Design: The Effects of Normalization *Extending Developer Studio with Custom Plugins *Protecting customizations or extensions across upgrades Executive Session Presenters - *Opening Session with Doug Mueller, Founder of the AR System. *Service Desk Optimization. *Enterprise Change Release Management. *Service Asset Lifecycle Management. As you can see, it is a pretty impressive list. With the release of the 7.6.03 products, I know I'm looking forward to what they have to tell us. See you in Vegas! ... only 6 weeks and counting Kelly Deaver L-3 Stratis / FAA Contractor kdea...@kellydeaver.com (ARSlist mail) kelly.ctr.dea...@faa.gov (Business mail) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: WWRUG: Ok, I'm officially excited!
Excellent! I will book my flight today! Be there or be a parallelogram! Rick -Original Message- From: ARSlist arsl...@danielbloom.ca Sender: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG Date: Mon, 13 Sep 2010 09:43:25 To: arslist@ARSLIST.ORG Reply-To: arslist@ARSLIST.ORG Subject: Re: WWRUG: Ok, I'm officially excited! The Venue is better than ever (and everyone loved it last year), The content is even better than last year (and everyone thought last year's reminded them of RUGs of old for the technical level). Yes what they say is covered by their resort fee will be provided and they have signed an addendum to fix all the (minor) issues from last year. There was also a major clause to cover our internet access, which as Kelly has mentioned seems to have been resolved by them already. We will have wired access when needed as well. The breakfasts are being kicked up a notch so everyone will have the energy for 12 hour days of BMC Remedy AR System and ITSM knowledge intake. Looking forward to seeing you all there! Dan www.wwrug10.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: September-13-10 7:17 AM To: arslist@ARSLIST.ORG Subject: Re: WWRUG: Ok, I'm officially excited! ** Is the hotel actually going to provide the services their Resort Fee says it's supposed to cover this year? Rick On Sat, Sep 11, 2010 at 9:12 PM, Kelly Deaver kdea...@kellydeaver.com wrote: Hi Gang, I just got back from a planning meeting with the Hard Rock Hotel in Las Vega. For those who were there last year, you are in for a surprise. The new tower is open and it brings with it a new night club, spa, larger pool, and a really fun restaurant. On a techie level, the wifi in the conference area is now a full 5 bars (picture me the geek walking around with my laptop checking it out). There will be an Internet cafe for those who don't want to drag their laptop downstairs. For those of you who've not been there, be prepared for a great conference location and a lot of awesome content. As part of my duties working with the vendors, I had to prepare a list for BMC of all items that various groups within BMC have agreed to do. I have to say, it is pretty impressive! To me it is all the technical goodness of a BMC sponsored event without the overdose of sales focus :) BMC is really being great working with us on this and I hope you will show up to take advantage of the opportunity! BMC's involvement - Bob Beauchamp - Key Note Speaker at the General Session on Tuesday October 19th. Doug Mueller -Speaker at the General Session on Wednesday October 20th and generally accessible for the conference to be Doug :) If you've not had one on one time with Doug, you've not experienced Remedy nirvana or changed your self on a technical level. Platinum Booth Sponsor - BMC will have a booth in the Technology Showcase where you can see the latest and greatest, get your questions answered, etc. Evening with Engineering Sponsor - BMC is sponsoring the event which includes dinner. BMC will also be providing engineers/experts in the tradition of RUGs past. Session Presenters - BMC is signed up to deliver the breakout sessions listed below. *BMC: What's New in AR System 7.6.03 *MidTier: Best Practices and Implementation for Optimal Performance *Richer UI Capabilities in AR System 7.6.03 *The New AR-Based, BMC Remedy Knowledge Management- One solution - One Vendor *What is new in ITSM version 7.6.03 *State of the Art Integration for AR System and Atrium *Accelerated Development using Developer Studio in AR System 7.6.03 *Tuning The Mid-Tier/Web Infrastructure for Hi-Performance and Troubleshooting Performance Issues *Life Beyond the Remedy User Tool: Why it's Safe to Leave it Behind *How to Build a Successful Service Request Management Solution *Localize Your AR System Applications using Developer Studio L10n Toolkit *Manage and Create Content for the AR System Home Page *Ad-Hoc Web Reporting for AR System 7.6.03 *Discover the new Full Text Search Infrastructure in AR System version 7.6 *User Interface Design Patterns in AR System *Lean Application Design: The Effects of Normalization *Extending Developer Studio with Custom Plugins *Protecting customizations or extensions across upgrades Executive Session Presenters - *Opening Session with Doug Mueller, Founder of the AR System. *Service Desk Optimization. *Enterprise Change Release Management. *Service Asset Lifecycle Management. As you can see, it is a pretty impressive list. With the release of the 7.6.03 products, I know I'm looking forward to what they have to tell us. See you in Vegas! ... only 6 weeks and counting Kelly Deaver L-3 Stratis / FAA Contractor kdea...@kellydeaver.com (ARSlist mail) kelly.ctr.dea...@faa.gov (Business mail) ___
Open a form in Developer Studio from a custom plugin
Does anybody know how I can open a Form, Active Link, Filter, ... in Developer Studio from a custom eclipse plugin? Thanks André ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Removing the field from Report
If I understand correctly, the fields that can be included in a report are displayed in the list based on the permissions associated with the field and the permissions associated with the person creating the report. Dave -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of axneer Sent: Monday, September 13, 2010 7:10 AM To: arslist@ARSLIST.ORG Subject: Removing the field from Report Hi, I wanted to know if there is any way by which Character field not get listed in the Field List of Repoting (Tools-Reporting) of ARUser itself?. I am not saying of selecting or removing field from Field List but to not to show the field in Field List itself? Please suggest if any way? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
64bit linux (lx64) api still broke with 7.6.3?
Been trying to get ARSperl working on a 64bit linux host for a while (snapshots or CVS), but seem to still be having the various 64bit issues, even with the latest 7.6.3 build of the ar API. Does anyone here have any information on this? I don't have any remedy/BMC support access as our AR server is hosted by another campus in our system, but we do use the client and API. Only information I have on the previous bug... is this still not corrected in 7.6.3? defect # SW00330613 Summary: Problems with 64 Bit AR API Libraries under Linux Status: Open Type: Product Product: AR System Target Release: Esc 7.5.0 Server Classification Tentatively Targeted Version: 7.5 Target Release Version: Future Patch Release The symptom I have still is the can't encode arguments rpc error if the login port isn't specified, and glibc double free errors. If I bypass the glibc memory checks with MALLOC_CHECK env var, it looks like it's still unable to connect properly. I'd really like to get moved off of some legacy 32bit systems that are having to be retained to run the AR api, but having to build an entire separate 32bit perl isn't exactly a reasonable alternative. -- Nathan Nathan Neulinger nn...@mst.edu Missouri ST Information Technology(573) 612-1412 System Administrator - Principal KD0DMH ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ARSmarts 2.6 beta program
Hello List, _The beta program for ARSmarts 2.6 is now open._ ARSmarts 2.6 expends the powerful functionalities of the Navigator, the Documenter and the Grapher, already available in previous versions. The main new functionality offered by ARSmarts 2.6 is the *support of Views and Field Display Properties*. This means, for example, that you can now search for a View Alias (which is what your end-user sees on the screen) and for a given Field Label, find fields that have been moved (using the Compare functionality of ARSmarts), and include this information in your documentation (using ARSmarts Documenter). Furthermore, ARSmarts 2.6 also includes a number of improvements, such as the reduction in size of the ARSmarts compiled files (up to 90% smaller), increased decode speed (up to 70% for large applications), Don't hesitate to register on our website (http://www.arsmarts.com/Register) to participate to the beta program. Best regards. Kaïs ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Blue List License Translation
Hi All - Does anyone know of a translation document for the Blue pricing list to the Add Remove Licenses screen in ITSM? I know that I need to translate BMC Remedy Service Desk - Floating User Add-On License to BMC:Incident Mgmt User Floating BMC:Problem Mgmt User Floating. But what about other modules? ARS 7.1 p 6 ITSM 7.0.3 p 9 Window 2003 MS SQ 2005 IIS/Tomcat RKM 7.2 p 2 MidTier 7.1 p 6 Christie Pargeter Legacy Health IS - Programming SR Technical Analyst cparge...@lhs.org 1120 Building tel: 503-415-5149 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: Blue List License Translation
Your BMC Sales representative has access to this information and can assist you in this. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pargeter, Christie :CO IS Sent: Monday, September 13, 2010 10:06 AM To: arslist@ARSLIST.ORG Subject: Blue List License Translation ** Hi All - Does anyone know of a translation document for the Blue pricing list to the Add Remove Licenses screen in ITSM? I know that I need to translate BMC Remedy Service Desk - Floating User Add-On License to BMC:Incident Mgmt User Floating BMC:Problem Mgmt User Floating. But what about other modules? ARS 7.1 p 6 ITSM 7.0.3 p 9 Window 2003 MS SQ 2005 IIS/Tomcat RKM 7.2 p 2 MidTier 7.1 p 6 Christie Pargeter Legacy Health IS - Programming SR Technical Analyst cparge...@lhs.org mailto:cparge...@lhs.org 1120 Building tel: 503-415-5149 _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ADM:Timing Test please ignore
Monday 14:58 EST ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
JD, I am on ARS/ITSM 7.6.03, and for me, hitting enter in that field opens up a dialog window from which to select a Tier 1 Category. The AL that fires is CHG:CRQ:ServiceCatTier1List_100R0-Dialog. For HelpDesk it is HPD:HDD:List_100_R0-Dialog HTH Leonard Neely Column Technologies, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of JD Hood Sent: Monday, September 13, 2010 11:48 AM To: arslist@ARSLIST.ORG Subject: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.comhttp://hood.jdATgmail.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
These have both been reported as bugs and Will be fixed in a future release. I had them as well. -Original Message- From: Neely, Leonard lne...@columnit.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:25 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** JD, I am on ARS/ITSM 7.6.03, and for me, hitting enter in that field opens up a dialog window from which to select a Tier 1 Category. The AL that fires is CHG:CRQ:ServiceCatTier1List_100R0-Dialog. For HelpDesk it is HPD:HDD:List_100_R0-Dialog HTH Leonard Neely Column Technologies, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of JD Hood Sent: Monday, September 13, 2010 11:48 AM To: arslist@ARSLIST.ORG Subject: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
Looks like you're right! Leonard's check of 7.6.03 appears to show a fix... But I don't think we will be upgrading from 7.6.00 just yet, so I think I'll just add the forms to the AL's and see what happens while I'm waiting for BMC to respond (I went ahead and submitted an issue). Thanks Guys! J.D. Hood On Mon, Sep 13, 2010 at 3:43 PM, Roger Justice rjust2...@aol.com wrote: ** These have both been reported as bugs and Will be fixed in a future release. I had them as well. -Original Message- From: Neely, Leonard lne...@columnit.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:25 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** JD, I am on ARS/ITSM 7.6.03, and for me, hitting enter in that field opens up a dialog window from which to select a Tier 1 Category. The AL that fires is CHG:CRQ:ServiceCatTier1List_100R0-Dialog. For HelpDesk it is HPD:HDD:List_100_R0-Dialog HTH *Leonard Neely*** Column Technologies, Inc. *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arsl...@arslist.org?] *On Behalf Of *JD Hood *Sent:* Monday, September 13, 2010 11:48 AM *To:* arslist@ARSLIST.ORG *Subject:* ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.com http://hood.jdatgmail.com/ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
The fields have different DBIDs is why I have not tried. -Original Message- From: JD Hood hood...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:52 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Looks like you're right! Leonard's check of 7.6.03 appears to show a fix... But I don't think we will be upgrading from 7.6.00 just yet, so I think I'll just add the forms to the AL's and see what happens while I'm waiting for BMC to respond (I went ahead and submitted an issue). Thanks Guys! J.D. Hood On Mon, Sep 13, 2010 at 3:43 PM, Roger Justice rjust2...@aol.com wrote: ** These have both been reported as bugs and Will be fixed in a future release. I had them as well. -Original Message- From: Neely, Leonard lne...@columnit.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:25 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** JD, I am on ARS/ITSM 7.6.03, and for me, hitting enter in that field opens up a dialog window from which to select a Tier 1 Category. The AL that fires is CHG:CRQ:ServiceCatTier1List_100R0-Dialog. For HelpDesk it is HPD:HDD:List_100_R0-Dialog HTH Leonard Neely Column Technologies, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of JD Hood Sent: Monday, September 13, 2010 11:48 AM To: arslist@ARSLIST.ORG Subject: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
Turns out, it's a fairly simple fix... For the Operational Tier 1+ field, I only had to modifiy the one AL Leonard mentioned (CHG:CRQ:ServiceCatTier1List_100_R0-Dialog) by adding CHG:Change Dialogs to the form list. For the Product Name+ field, little more involved, but still not too bad... Check the AL's that start with, CHG:CRQ:ProdName(2)Search_0... I just added the form CHG:Change Dialogs to the forms list (with the below exception) and it worked. For the one AL, CHG:CRQ:ProdName(2)Search_025_R5-, it wouldn't work when I tried to share it (like you said, the field ID's were different). So, I copied it to a new AL (save as) and replaced the form, so that the only form listed was CHG:Change Dialogs. To fix the field ID problems, I modified the Set-Fields qual to: 'Company' = $Location Company$) OR ('Company' = - Global -)) AND ($Location Company$ != $NULL$)) OR ($Location Company$ = )) AND (('Product Categorization Tier 1' = $z1D Char01$) OR ($z1D Char01$ = )) AND (('Product Categorization Tier 2' = $z1D Char02$) OR ($z1D Char02$ = )) AND (('Product Categorization Tier 3' = $z1D Char03$) OR ($z1D Char03$ = )) AND ('Status-PDC' = Enabled) AND ('Status-PDA' = Enabled) AND ('Product ID' = $z1D Char05$) AND ('Change Management Selection' = Yes) So, unless BMC Support provides a different resolution, it seems to work for the three use cases (no-match, single-match, multi-match). And it's easy enough to roll-back in any event. Thanks again! J.D. Hood On Mon, Sep 13, 2010 at 4:45 PM, Roger Justice rjust2...@aol.com wrote: ** The fields have different DBIDs is why I have not tried. -Original Message- From: JD Hood hood...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:52 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Looks like you're right! Leonard's check of 7.6.03 appears to show a fix... But I don't think we will be upgrading from 7.6.00 just yet, so I think I'll just add the forms to the AL's and see what happens while I'm waiting for BMC to respond (I went ahead and submitted an issue). Thanks Guys! J.D. Hood On Mon, Sep 13, 2010 at 3:43 PM, Roger Justice rjust2...@aol.com wrote: ** These have both been reported as bugs and Will be fixed in a future release. I had them as well. -Original Message- From: Neely, Leonard lne...@columnit.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:25 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** JD, I am on ARS/ITSM 7.6.03, and for me, hitting enter in that field opens up a dialog window from which to select a Tier 1 Category. The AL that fires is CHG:CRQ:ServiceCatTier1List_100R0-Dialog. For HelpDesk it is HPD:HDD:List_100_R0-Dialog HTH *Leonard Neely*** Column Technologies, Inc. *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arsl...@arslist.org?] *On Behalf Of *JD Hood *Sent:* Monday, September 13, 2010 11:48 AM *To:* arslist@ARSLIST.ORG *Subject:* ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.com http://hood.jdatgmail.com/ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs
Thanks I will try it tomorrow. -Original Message- From: JD Hood hood...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 5:19 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Turns out, it's a fairly simple fix... For the Operational Tier 1+ field, I only had to modifiy the one AL Leonard mentioned (CHG:CRQ:ServiceCatTier1List_100_R0-Dialog) by adding CHG:Change Dialogs to the form list. For the Product Name+ field, little more involved, but still not too bad... Check the AL's that start with, CHG:CRQ:ProdName(2)Search_0... I just added the form CHG:Change Dialogs to the forms list (with the below exception) and it worked. For the one AL, CHG:CRQ:ProdName(2)Search_025_R5-, it wouldn't work when I tried to share it (like you said, the field ID's were different). So, I copied it to a new AL (save as) and replaced the form, so that the only form listed was CHG:Change Dialogs. To fix the field ID problems, I modified the Set-Fields qual to: 'Company' = $Location Company$) OR ('Company' = - Global -)) AND ($Location Company$ != $NULL$)) OR ($Location Company$ = )) AND (('Product Categorization Tier 1' = $z1D Char01$) OR ($z1D Char01$ = )) AND (('Product Categorization Tier 2' = $z1D Char02$) OR ($z1D Char02$ = )) AND (('Product Categorization Tier 3' = $z1D Char03$) OR ($z1D Char03$ = )) AND ('Status-PDC' = Enabled) AND ('Status-PDA' = Enabled) AND ('Product ID' = $z1D Char05$) AND ('Change Management Selection' = Yes) So, unless BMC Support provides a different resolution, it seems to work for the three use cases (no-match, single-match, multi-match). And it's easy enough to roll-back in any event. Thanks again! J.D. Hood On Mon, Sep 13, 2010 at 4:45 PM, Roger Justice rjust2...@aol.com wrote: ** The fields have different DBIDs is why I have not tried. -Original Message- From: JD Hood hood...@gmail.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:52 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Looks like you're right! Leonard's check of 7.6.03 appears to show a fix... But I don't think we will be upgrading from 7.6.00 just yet, so I think I'll just add the forms to the AL's and see what happens while I'm waiting for BMC to respond (I went ahead and submitted an issue). Thanks Guys! J.D. Hood On Mon, Sep 13, 2010 at 3:43 PM, Roger Justice rjust2...@aol.com wrote: ** These have both been reported as bugs and Will be fixed in a future release. I had them as well. -Original Message- From: Neely, Leonard lne...@columnit.com To: arslist arslist@ARSLIST.ORG Sent: Mon, Sep 13, 2010 3:25 pm Subject: Re: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** JD, I am on ARS/ITSM 7.6.03, and for me, hitting enter in that field opens up a dialog window from which to select a Tier 1 Category. The AL that fires is CHG:CRQ:ServiceCatTier1List_100R0-Dialog. For HelpDesk it is HPD:HDD:List_100_R0-Dialog HTH Leonard Neely Column Technologies, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of JD Hood Sent: Monday, September 13, 2010 11:48 AM To: arslist@ARSLIST.ORG Subject: ITSM v7.6: Behavior of Categorization Fields on CHG:Change Dialogs ** Folks, In Change Mgmt v7.6, using the best practices view for the CHG:Infrastructure Change form in either new or modify mode, you get to the Categorizations fields via a dialog in the Quick Links menu. That dialog is the Categorizations View VUI of the CHG:Change Dialogs form. When it opens, I note that the Operational Cat Tier-1 and the Product-Name fields both have the + in their field labels, indicating there is some on-return functionality. However, it does nothing for me. Logging show nothing is firing on-return either. I checked Dev-Studio's Show Relationships feature and it lists quite a few related active links for that field, but I didn't see any that had the expected on-return functionality. If you have access to a v7.6 ITSM or CHG-Mgmt system, would you be so kind as to check that dialog and let me know if you have on-return functionality on either of those fields? I'm just trying to verify what I'm seeing to determine if it works as BMC intended or if something didn't install right... Thanks! JDHood hood.jdATgmail.com _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at
Crystal Reports and Performance issues
Fellow ARSListers, I have been trying to track down a problem with performance. We appear to have located the problem coming from our Crystal Reports server than runs multiple reports against Remedy every day. I have the option enabled to put large result buffer entries in the Thread log file. My goal was to see large queries being executed against the Remedy database. What I found was that several entries in the log file from the login used by our Crystal Reports server. Has anyone see this behavior before? It appears as if Crystal Reports is sending the same query over and over again to Remedy for processing. I have seen a single report generate 3 dozen similar entries to what I have listed below. The report also eats up over half of the CPU's processing power while this report is running. THRD /* Mon Sep 13 2010 16:29:17.2030 */ Thread Id 3100 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134939/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:20.2650 */ Thread Id 2944 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134950/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:23.3440 */ Thread Id 4836 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134962/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:26.4690 */ Thread Id 4604 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134973/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:29.5630 */ Thread Id 1256 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134987/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:32.6560 */ Thread Id 2552 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134998/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:35.7030 */ Thread Id 2616 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135010/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:38.7500 */ Thread Id 5340 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135023/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:41.8130 */ Thread Id 5904 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135034/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:44.7350 */ Thread Id 3296 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135049/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:47.6880 */ Thread Id 5492 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135060/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:50.6880 */ Thread Id 3512 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135072/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:52.9230 */ Thread Id 3668 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135083/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:54.7660 */ Thread Id 2692 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135095/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:57.7980 */ Thread Id 5252 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135106/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:30:00.8920 */ Thread Id 4908 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135117/User: entp_report/Form: HPD:Help Desk_SLA/ Any insight or assistance to resolving why Crystal is doing this would be much appreciated. I have used Crystal Reports in the past, but have never been aware of any behavior like this. However, all of my tests point to the reports being run through Crystal as the source of our performance issues. James Van Sickle Senior Remedy Developer Office: 972-308-4090 Mobile: 214-263-9340 _ This email and its attachments, if any, are intended for the personal use of the named recipient(s) and may contain confidential, privileged, or proprietary information. If you are not a named recipient, or an agent responsible for delivering it to a named recipient, you have received this email in error. In that event, please (a) immediately notify me by
Re: Crystal Reports and Performance issues
If the Crystal report in question contains sub reports then you will get multiple queries. If the main reports result set contains lots of records then you will get as many SQL calls for each of the sub reports. This is not out of the ordinary. On Sep 13, 2010, at 5:53 PM, Van Sickle, James W james.vansic...@cmc.com wrote: ** Fellow ARSListers, I have been trying to track down a problem with performance. We appear to have located the problem coming from our Crystal Reports server than runs multiple reports against Remedy every day. I have the option enabled to put large result buffer entries in the Thread log file. My goal was to see large queries being executed against the Remedy database. What I found was that several entries in the log file from the login used by our Crystal Reports server. Has anyone see this behavior before? It appears as if Crystal Reports is sending the same query over and over again to Remedy for processing. I have seen a single report generate 3 dozen similar entries to what I have listed below. The report also eats up over half of the CPU’s processing power while this report is running. THRD /* Mon Sep 13 2010 16:29:17.2030 */ Thread Id 3100 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134939/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:20.2650 */ Thread Id 2944 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134950/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:23.3440 */ Thread Id 4836 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134962/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:26.4690 */ Thread Id 4604 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134973/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:29.5630 */ Thread Id 1256 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134987/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:32.6560 */ Thread Id 2552 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134998/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:35.7030 */ Thread Id 2616 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135010/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:38.7500 */ Thread Id 5340 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135023/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:41.8130 */ Thread Id 5904 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135034/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:44.7350 */ Thread Id 3296 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135049/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:47.6880 */ Thread Id 5492 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135060/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:50.6880 */ Thread Id 3512 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135072/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:52.9230 */ Thread Id 3668 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135083/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:54.7660 */ Thread Id 2692 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135095/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:57.7980 */ Thread Id 5252 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135106/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:30:00.8920 */ Thread Id 4908 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135117/User: entp_report/Form: HPD:Help Desk_SLA/ Any insight or assistance to resolving why Crystal is doing this would be much appreciated. I have used Crystal Reports in the past, but have never been aware of any behavior like this. However, all of my tests point to the reports being run through Crystal as the source of our performance issues. James Van Sickle Senior Remedy Developer Office:
Re: Crystal Reports and Performance issues
Is it doing any tablescans? I see gfwe but what are the queries. Can you index to help some? Is it the same table? Is it possible to pin that in memory oracle wise to help with io. Just wondering.. You might have increase oracle memory space to allow oracle to breath. Or is the ms? Sent from my iPhone On Sep 13, 2010, at 6:43 PM, Frank caruso.fr...@gmail.com wrote: ** If the Crystal report in question contains sub reports then you will get multiple queries. If the main reports result set contains lots of records then you will get as many SQL calls for each of the sub reports. This is not out of the ordinary. On Sep 13, 2010, at 5:53 PM, Van Sickle, James W james.vansic...@cmc.com wrote: ** Fellow ARSListers, I have been trying to track down a problem with performance. We appear to have located the problem coming from our Crystal Reports server than runs multiple reports against Remedy every day. I have the option enabled to put large result buffer entries in the Thread log file. My goal was to see large queries being executed against the Remedy database. What I found was that several entries in the log file from the login used by our Crystal Reports server. Has anyone see this behavior before? It appears as if Crystal Reports is sending the same query over and over again to Remedy for processing. I have seen a single report generate 3 dozen similar entries to what I have listed below. The report also eats up over half of the CPU’s processing power while this report is running. THRD /* Mon Sep 13 2010 16:29:17.2030 */ Thread Id 3100 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134939/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:20.2650 */ Thread Id 2944 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134950/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:23.3440 */ Thread Id 4836 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134962/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:26.4690 */ Thread Id 4604 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134973/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:29.5630 */ Thread Id 1256 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134987/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:32.6560 */ Thread Id 2552 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 134998/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:35.7030 */ Thread Id 2616 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135010/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:38.7500 */ Thread Id 5340 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135023/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:41.8130 */ Thread Id 5904 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135034/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:44.7350 */ Thread Id 3296 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135049/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:47.6880 */ Thread Id 5492 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135060/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:50.6880 */ Thread Id 3512 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135072/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:52.9230 */ Thread Id 3668 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135083/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:54.7660 */ Thread Id 2692 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135095/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:29:57.7980 */ Thread Id 5252 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135106/User: entp_report/Form: HPD:Help Desk_SLA/ THRD /* Mon Sep 13 2010 16:30:00.8920 */ Thread Id 4908 (GLEWF) large result buffer allocation - /Length: 1505110/Entries: 10729/Client Ver: =10/RPC ID: 135117/User: entp_report/Form: HPD:Help Desk_SLA/
Re: Developer studio encounter out of memory error while importing a whole Appliaction
Hi Jiang, Did you have a chance to try your import with Dev Studio 7.6.03? I'll be interested to see if the import issues are the same as the export issues. Today I tried 7.6.03 Dev Studio against our 7.5 patch 5 server with IM, AM and SLM. It ends up being 55,240 objects. I set the max in devstudio.ini to -Xmx3072m and DS started!!! That was a good sign seeing as the max with 32 bit jvm seems to be around -Xmx1568m. The javaw.exe process ranged from 1,101,920k to 1,102,984k and didn't take up as much memory as I expected it to. After about 2 hours it ended up giving the following error before the def file was ever started: An internal error occurred during: Export Objects. java.nio.BufferUnderflowException I found some references to a BufferUnderflow bug in Eclipse, 262875 ( https://bugs.eclipse.org/bugs/show_bug.cgi?id=262875). It talks about being available in Eclipse ver 2.0.2 on 2010-06-29 and DS appears to use Eclipse 3.4 but I wonder if it exists in 3.x and if DS has been updated post fix? I am trying again right now. May need to submit this one to BMC for review? Can anybody else confirm they have been able to export a large def file using DS 7.6.03? Jason On Sat, Sep 11, 2010 at 11:28 AM, Jason Miller jason.mil...@gmail.comwrote: Yes, 7.6.03 can work with a 64 bit jvm. I have not tried importing a large/full def but have had the same issue exporting a large/full def with prior versions. I plan on to trying a full def export with 7.6.03 in the next few days. I'll report back on how it works. Jason On Sep 11, 2010 8:44 AM, jiangxiaofeng86 jiangxiaofen...@gmail.com wrote: Hello arslist, Win 2003 32bit(virtual machine) JDK 1.6 32bit Developer studio 7.5.03 AR Server 7.5.03 Is there a 64bit version of Developer studio? Regards, 2010-09-11 -- Jiang Xiaofeng 江晓峰 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are